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
t 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
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 partiti
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 ,