I frequently sort by partitioned columns, without issues. Post your table
schema, and your query that's failing, lets see what's going on?
Tim
On Mon, May 14, 2012 at 1:28 AM, Shin Chan wrote:
> Hi All
>
> Just curious if its possible to Order by or Sort by partitioned columns.
>
> I tried it
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" wrote:
> Hi Shin,
> If you could list the query that failed and the q
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"
To: "HIVE User"
Sent: Monday, May 14, 2012 2:28:06 AM
Subject: Order by Sort by partitioned columns
Hi All
Ju
