REORGANIZE can also qualify a new partition clause. ALTER TABLE…REORGANIZE and Vertica meta-function PARTITION_TABLE operate identically. Valid only for partitioned tables, invokes the Tuple Mover to reorganize ROS storage containers as needed to conform with the table's current partition clause. See Renaming Columns in the Administrator's Guide. Renames the specified column within the table. The Tuple Mover subsequently removes existing partitions from ROS containers. Specifies to remove partitioning from a table definition. If you qualify the partition clause with REORGANIZE and the table previously specified no partitioning, the Vertica Tuple Mover immediately implements the partition clause. If the table previously specified partitioning, the Tuple Mover evaluates ROS storage containers and reorganizes them as needed to conform with the new partition clause. Change schema privileges without affecting the table.Use schema-level privileges as a template.Grant more specific privileges at the table level.This disables the inherited privileges flag on the table, so you can: MATERIALIZE: Copies grants to the table and creates a GRANT object on the table. INCLUDE PRIVILEGES grants the table the same privileges granted to its schema.EXCLUDE PRIVILEGES (default) disables inheritance of privileges from the schema.Specifies default inheritance of schema privileges for this table: For details, see Controlling Join Inputs in Analyzing Data. Specifies whether a table is joined to another as an inner or outer input. See Dropping Table Columns in the Administrator's Guide. RESTRICT drops the column only from the given table.CASCADE is required if the column has dependencies.If you omit this option and the column does not exist, Vertica generates a ROLLBACK error message. IF EXISTS specifies to generate an informational message if the column does not exist.You can qualify DROP COLUMN with one of these options: Sets or drops a setting for a column of a scalar data type (not ROW), as follows:ĭROP column See Constraints in the Administrator's Guide. ALL PROJECTIONS adds the column to all projections of this table, excluding projections with pre-aggregated data.Īdds a constraint to a table that does not have any associated projections.The projection list cannot include projections with pre-aggregated data such as live aggregate projections otherwise, Vertica rolls back the ALTER TABLE statement. Vertica adds the column to all buddies of each projection.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |