-Re: Order by Sort by partitioned columns
Sukhendu Chakraborty 2012-05-16, 02:47
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" <[EMAIL PROTECTED]> 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.
> ----- 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
> 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 ,