PARTITION_TABLE

Invokes the Tuple Mover to reorganize ROS storage containers as needed to conform with the current partitioning policy.

This is a meta-function. You must call meta-functions in a top-level SELECT statement.

Behavior type

Syntax

PARTITION_TABLE ( '[schema.]table-name')

Parameters

[database.]schema

Database and schema. The default schema is public. If you specify a database, it must be the current database.

table-name

The table to partition.

Privileges

• Table owner

• USAGE privilege on schema

Restrictions

• You cannot run PARTITION_TABLE on a table that is an anchor table for a live aggregate projection or a Top-K projection.

• To reorganize storage to conform to a new policy, run PARTITION_TABLE after changing the partition GROUP BY expression.

See also

• PARTITION_PROJECTION
• Partitioning existing table data