|Creation date||Minimum version|
The Horizontal Partition extension enables you to split your active table into multiple tables, keeping the schema of the table intact. After horizontal partitioning, you can choose to start operations on only the resultant table of interest, which consists of fewer records than the original table and hence the improved performance.
A partition is a table containing a subset of records that exist in the active table. The column from which you start the extension is the partition column.
A partition contains the rows with the same value in the partition column. You cannot specify the number of rows in a partition. Also, the partition value is determined by the exact value in a column. You cannot specify the condition for the rows in a partition. For example, you cannot specify that the values greater than 100 in the partition column be in one partition and the values less than 100 in the partition column be in another partition.
Understanding the number of horizontal partitions
The number of partitions is the number of tables created by the extension. You can create 1 to 10 partitions.
Xcalar chooses the values with the highest number of occurrences when creating the partitions.
If the specified number of partitions is greater than the number of different values in the partition column, Xcalar will create only the necessary number of partitions. For example, if only four values exist in the partition column and you specify 10 partitions, only four partitions will be created.
Invoking the Horizontal Partition extension
Follow these steps to invoke the Horizontal Partition extension:
- In the My Extensions panel, select Horizontal Partition.
- In the Table field, select the table containing the column you want to perform the partition on.
- In the No. of Partitions field, type a number. This is the number of new tables created by the extension.
- Click APPLY.
- in the table.