If you could list the query that failed and the query used to create the tables in question, that would be very helpful.
----- Original Message -----
From: "Shin Chan" <[EMAIL PROTECTED]>
To: "HIVE User" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2012 2:28:06 AM
Subject: Order by Sort by partitioned columns
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 ,