See Auto-Projections in the Administrator's Guide. Make sure that projections exist before you load data.
This option is invalid for external tables This option and column-name-list are mutually exclusive. ENCODING encoding-type: Specifies the type of encoding to use on the column.ACCESSRANK integer: Overrides the default access rank for a column, useful for prioritizing access to a column.
However, this load method applies to load operations only after the table is created.įor details, see Creating a Table from a Query in the Administrator's Guide.Ī list of columns from the source table, where each column is qualified by one or both of the following encoding options: The CREATE TABLE statement can also specify a load method. The names in column-name-list and queried columns must be the same in number. If you omit this list, Vertica uses the query output column names. Valid only when creating a table from a query ( AS query), defines column names that map to the query output. If a CREATE TEMPORARY TABLE statement sets k‑num greater than 0, Vertica returns an warning. For general information, see K-Safety in Vertica Concepts.Įon Mode: K‑safety of temporary tables is always set to 0, regardless of system K‑safety. If you omit this option, the projection uses the system K-safety level. Invalid for external tables, specifies K-safety of auto-projections created for this table, where k‑num must be equal to or greater than system K‑safety. If this clause is omitted, Vertica generates auto-projections with default hash segmentation. unsegmented‑clause: Specifies to create an unsegmented projection.For details, see Hash Segmentation Clause. Vertica recommends segmenting large tables. hash‑segmentation‑clause: Specifies to segment data evenly and distribute across cluster nodes.
Invalid for external tables, specifies how to distribute data for auto-projections of this table.
If you omit the ORDER BY clause, Vertica uses the SELECT list order as the projection sort order. Vertica always stores projection data in ascending sort order. The ORDER BY clause cannot include qualifiers ASC or DESC. Invalid for external tables, specifies columns from the SELECT list on which to sort the superprojection that is automatically created for this table.
LOCAL: the table definition is visible only to the session in which it is created, and is dropped when the session ends.GLOBAL (default): The table definition is visible to all sessions, and persists until you explicitly drop the table.Specifies visibility of the table definition: