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 Average_order

Re: Understanding Hive's execution plan

Try this, it has a chapter on hive http://hdl.handle.net/10919/5122 3 On Thursday, March 26, 2015, Daniel Haviv wrote: > Hi, > Can anyone direct me to a good explanation on understanding Hive's > execution plan? > > Thanks, > Daniel >

Re: Understanding Hive's execution plan

Hi Daniel - the below link can shed some light on it. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain --Bala G. On Thu, Mar 26, 2015 at 10:26 AM, Daniel Haviv < daniel.ha...@veracity-group.com> wrote: > Hi, > Can anyone direct me to a good explanation on understanding Hi