Have you looked at the Hive wiki? Here's the section on ORDER BY <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy#LanguageManualSortBy-SyntaxofOrderBy> .
-- Lefty On Sat, Mar 28, 2015 at 9:45 PM, Gopal Vijayaraghavan <gop...@apache.org> wrote: > > > SELECT cust_id AS Customer_ID, > > Š > > ORDER BY 3 ; > > > You¹re sorting on a constant (literal value 3). The results are what you > get when you run a non-stable sort on a constant. > > Cheers, > Gopal > > >
