saveDualPartition

swordfish.function.saveDualPartition()

Save a table in the local node before sharing it to other nodes to form a dual partition database. It must be executed by a logged-in user.

It is used together with statement share. If the partition and a table already exist, the function will append the new data to the existing table.

Parameters:

• dbHandle1 (Constant) – The database handle of the first level partition.

• dbHandle2 (Constant) – The database handle of the second level partition.

• table (Constant) – The table in memory to be saved.

• tableName (Constant) – A string indicating the desired name of the saved partitioned table.

• partitionColumn1 (Constant) – A string indicating the partitioning column of the first level partition.

• partitionColumn2 (Constant) – A string indicating the partitioning column of the second level partition.

• compression (Constant, optional) – Boolean variable. It sets the compression mode. When it is set to true, the table will be saved to disk in compression mode. The default value is false.