hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: ORDER BY clause in Hive
Date Sun, 29 Mar 2015 05:58:52 GMT
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 <gopalv@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
>
>
>

Mime
View raw message