How can I set the sort order of a super projection?

David_P_1

How can I set the sort order of a super projection?

Maybe by setting the tables primary key to the desired sort order?

emoreno

You specify the order by in the projection DDL.

https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/CREATEPROJECTION.htm?Highlight=create%20projection

Projection order by helps query performance, you can read this doc to different considerations

https://my.vertica.com/kb/Redesigning-Projections-for-Query-Optimization/Content/BestPractices/Redesigning-Projections-for-Query-Optimization.htm?Highlight=projection

You can also look at hands on in vertica that talks about how to work with table and projections
https://my.vertica.com/get-started-vertica/creating-tables-projections/

Hope this helps.
Eugenia