I think in HIVE the partitioned columns are virtual. They are not physical data columns but a directory name corr. to the partition key value to facilitate partition pruning during select. On May 14, 2012 6:29 AM, "Mark Grover" <mgro...@oanda.com> wrote:
> 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 , >
