How can I set the sort order of a super projection?
Maybe by setting the tables primary key to the desired sort order?
You specify the order by in the projection DDL.
Projection order by helps query performance, you can read this doc to different considerations
You can also look at hands on in vertica that talks about how to work with table and projectionshttps://my.vertica.com/get-started-vertica/creating-tables-projections/
Hope this helps.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.