The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Order by clause in Views
I created a view against a table using the following format "select col1, count(col2), count(distinct col3) from table group by col1, order by col1 desc". But when I do a select * from view_name, it seems that the results are not sorted according to my view definition. They should be sorted in descending order by the first column. Does Vertica not respect the order by clause in views? If no then why are my results not coming out correctly? and If yes, why does it have an example of a query in the SQL Documentation that has an order by clause? Edit: I am running on version 6.1.3.