Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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]>
> 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 ,
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB