The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Strict subset of columns in sort order of superprojection

I can't find in the documentation what happens when a user provide a sort order in a CREATE TABLE statement (or superprojection) where the columns provided is a strict subset of the table column-list.

 

 

CREATE TEMP TABLE order_subset (a int, b int, c int, d int)
ORDER BY d, c;

 

 

Will Vertica enforce a total ordering of the rows by joining the missing column with the ordering in the column-list. In this case, the previous CREATE statement would be equivalent to

 

CREATE TEMP TABLE order_subset (a int, b int, c int, d int)
ORDER BY d, c, a, b;

 

The documentation state the default case when the user doesn't provide an ordering, I'd like to know the behaviour when the ordering is strictly partial.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.