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
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]>
> 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 ,