Vertica Analytics Platform Version 9.2.x Documentation

PARTITION_TABLE

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

Syntax

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

Parameters

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

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.