Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Order by Sort by partitioned columns


Copy link to this message
-
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.
>
> Mark
>
> ----- 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 ,
>