Re: ORDER BY clause in Hive

g Systems with Oracle TimesTen and > Coherence Cache* > > > > NOTE: The information in this email is proprietary and confidential. This > message is for the designated recipient only, if you are not the intended > recipient, you should destroy it immediately. Any information in th

RE: ORDER BY clause in Hive

es nor their employees accept any responsibility. From: Lefty Leverenz [mailto:leftylever...@gmail.com] Sent: 31 March 2015 07:18 To: user@hive.apache.org Subject: Re: ORDER BY clause in Hive I've opened HIVE-10160 <https://issues.apache.org/jira/browse/HIVE-10160> : Give a warn

Re: ORDER BY clause in Hive

Leverenz > Date: Tue, Mar 31, 2015 at 1:47 AM > Subject: Re: ORDER BY clause in Hive > To: Mich Talebzadeh > > > Hive as I see it does not support ORDER BY *Column position*. It only >> supports ORDER BY *Column name*. >> > > That's just in Hive release

Fwd: ORDER BY clause in Hive

-- Forwarded message -- From: Lefty Leverenz Date: Tue, Mar 31, 2015 at 1:47 AM Subject: Re: ORDER BY clause in Hive To: Mich Talebzadeh Hive as I see it does not support ORDER BY *Column position*. It only > supports ORDER BY *Column name*. > That's just in H

Fwd: ORDER BY clause in Hive

Oops, failed to send this to user@hive. -- Lefty -- Forwarded message -- From: Lefty Leverenz Date: Mon, Mar 30, 2015 at 12:42 AM Subject: Re: ORDER BY clause in Hive To: Gopal Vijayaraghavan Oho! Good point, Gopal. hive.groupby.orderby.position.alias isn't in the wik

RE: ORDER BY clause in Hive

...@hortonworks.com] On Behalf Of Gopal Vijayaraghavan Sent: 30 March 2015 05:26 To: user@hive.apache.org Cc: Lefty Leverenz Subject: Re: ORDER BY clause in Hive Hi Lefty, Couldn't find the documentation for what hive.groupby.orderby.position.alias=true does. I suspect that might be what Mic

Re: ORDER BY clause in Hive

day, March 29, 2015 at 8:32 PM To: "user@hive.apache.org" Subject: Re: ORDER BY clause in Hive I added information about this in the Order By <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy#Lang uageManualSortBy-SyntaxofOrderBy> section of the wik

Re: ORDER BY clause in Hive

e designated recipient only, if you are not the intended > recipient, you should destroy it immediately. Any information in this > message shall not be understood as given or endorsed by Peridale Ltd, its > subsidiaries or their employees, unless expressly so stated. It is the > respons

RE: ORDER BY clause in Hive

5 00:11 To: user@hive.apache.org Subject: ORDER BY clause in Hive Hi, Can someone point me to doc or otherwise to see if ORDER BY clause in Hive is working OK I have a simple aggregate query as follows: SELECT cust_id AS Customer_ID, COUNT(amount_sold) AS Number_of_orders, SUM

Re: ORDER BY clause in Hive

Have you looked at the Hive wiki? Here's the section on ORDER BY . -- Lefty On Sat, Mar 28, 2015 at 9:45 PM, Gopal Vijayaraghavan wrote: > > > SELECT cust_id AS Customer_ID, > > Š > >

Re: ORDER BY clause in Hive

> 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

ORDER BY clause in Hive

Hi, Can someone point me to doc or otherwise to see if ORDER BY clause in Hive is working OK I have a simple aggregate query as follows: SELECT cust_id AS Customer_ID, COUNT(amount_sold) AS Number_of_orders, SUM(amount_sold) AS Total_customer_amount, AVG(amount_sold) AS