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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |