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" <had...@gmx.com> To: "HIVE User" <user@hive.apache.org> Sent: Monday, May 14, 2012 2:28:06 AM Subject: Order by Sort by partitioned columns 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 ,