-- 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
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
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
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
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
...@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
...@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
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
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
@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
10 matches
Mail list logo