Fwd: ORDER BY clause in Hive

2015-03-31 Thread Lefty Leverenz
-- Forwarded message -- From: Lefty Leverenz leftylever...@gmail.com Date: Tue, Mar 31, 2015 at 1:47 AM Subject: Re: ORDER BY clause in Hive To: Mich Talebzadeh m...@peridale.co.uk Hive as I see it does not support ORDER BY *Column position*. It only supports ORDER BY *Column

Fwd: ORDER BY clause in Hive

2015-03-31 Thread Lefty Leverenz
Oops, failed to send this to user@hive. -- Lefty -- Forwarded message -- From: Lefty Leverenz leftylever...@gmail.com Date: Mon, Mar 30, 2015 at 12:42 AM Subject: Re: ORDER BY clause in Hive To: Gopal Vijayaraghavan gop...@apache.org Oho! Good point, Gopal

Re: ORDER BY clause in Hive

2015-03-31 Thread Lefty Leverenz
Leverenz leftylever...@gmail.com Date: Tue, Mar 31, 2015 at 1:47 AM Subject: Re: ORDER BY clause in Hive To: Mich Talebzadeh m...@peridale.co.uk 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 0.10.0

RE: ORDER BY clause in Hive

2015-03-31 Thread Mich Talebzadeh
free, therefore neither Peridale Ltd, its subsidiaries 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

Re: ORDER BY clause in Hive

2015-03-31 Thread Lefty Leverenz
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 warning

RE: ORDER BY clause in Hive

2015-03-30 Thread Mich Talebzadeh
...@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 Mich

Re: ORDER BY clause in Hive

2015-03-29 Thread Lefty Leverenz
...@peridale.co.uk] *Sent:* 29 March 2015 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

Re: ORDER BY clause in Hive

2015-03-29 Thread Gopal Vijayaraghavan
user@hive.apache.org Date: Sunday, March 29, 2015 at 8:32 PM To: user@hive.apache.org 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

Re: ORDER BY clause in Hive

2015-03-29 Thread Lefty Leverenz
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

RE: ORDER BY clause in Hive

2015-03-29 Thread Mich Talebzadeh
@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(amount_sold