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 was looking for (though I tend to write the column names explicitly). Cheers, Gopal From: Lefty Leverenz Reply-To: "user@hive.apache.org" Date: Sunday, March

Re: Sort order in Hive plan?

Thanks Xiaoyong Zhu and Prasanth Jayachandran, I've added this information to the wiki in EXPLAIN Syntax after the example stage plans. -- Lefty On Fri, Mar 27, 2015 at 8:07 PM, Xiaoyon

Re: ORDER BY clause in Hive

I added information about this in the Order By section of the wiki. Thanks, Mich and Gopal! -- Lefty On Sun, Mar 29, 2015 at 5:24 AM, Mich Talebzadeh wrote: > Hi Lefty, Gopal, > > > >

RE: ORDER BY clause in Hive

Hi Lefty, Gopal, It appears that ORDER BY 3 is not interpreted as ORDERR BY "the result set column three" which standard SQL as evident from Oracle and Sybase does. So I made it an ORDER BY from the result set EXPLICITELY as shown below and it worked OK SELECT rs.Customer_ID