Skip to main content

Tables Settings

AtScale supports the following settings for configuring aggregate tables.

tables.create.partitions.maximumDynamicPartitionsFactor​

  • Default: 1.2
  • Restart: No

Specifies the maximum number of partitions per table for underlying SQL engines. Some SQL engines have their own maximum number of partitions allowed per table. Before being passed to SQL engines, this value is multiplied by TABLES.CREATE.PARTITIONS.MAXIMUMESTIMATEDNUMBEROFPARTITIONS.

tables.create.partitions.enabled​

  • Default: true
  • Restart: No

Set to True to enable the AtScale engine to partition table types that can be partitioned.

tables.create.partitions.maximumDynamicPartitionsPerNodeFactor​

  • Default: 0.2
  • Restart: No

Specifies the maximum number of partitions per node for underlying SQL engines. Some SQL engines have a maximum number of table partitions per node. Before being passed to SQL engines, this value is multiplied by TABLES.CREATE.PARTITIONS.MAXIMUMESTIMATEDNUMBEROFPARTITIONS.

tables.create.partitions.maximumEstimatedNumberOfPartitions​

  • Default: 800
  • Restart: No

Specifies the maximum estimated number of partitions to consider acceptable for an instance of a user-defined aggregate. The creation of an instance will fail if the estimate is larger or cannot be calculated.

note

Building tables with significantly more than 1,000 partitions may use high amounts of resources and require cluster tuning.