Re: Order by Sort by partitioned columns

2012-05-16 Thread Tim Havens
I frequently sort by partitioned columns, without issues. Post your table schema, and your query that's failing, lets see what's going on? Tim On Mon, May 14, 2012 at 1:28 AM, Shin Chan wrote: > Hi All > > Just curious if its possible to Order by or Sort by partitioned columns. > > I tried it

Re: Order by Sort by partitioned columns

2012-05-15 Thread Sukhendu Chakraborty
t failed and the query used to create the > tables in question, that would be very helpful. > > Mark > > - Original Message - > From: "Shin Chan" > To: "HIVE User" > Sent: Monday, May 14, 2012 2:28:06 AM > Subject: Order by Sort by partitioned

Re: Order by Sort by partitioned columns

2012-05-14 Thread Mark Grover
Hi Shin, If you could list the query that failed and the query used to create the tables in question, that would be very helpful. Mark - Original Message - From: "Shin Chan" To: "HIVE User" Sent: Monday, May 14, 2012 2:28:06 AM Subject: Order by Sort by partiti

Order by Sort by partitioned columns

2012-05-13 Thread Shin Chan
Hi All Just curious if its possible to Order by or Sort by partitioned columns. I tried it , it fails as it is not able to find those columns. They are present as partitions. Any help would be appreciated. Thanks and Regards ,