wow. its still sorting based on string context. ok, some followups.
1. did you start clean? ie. did you do a "drop table moiz_partition_test" before you started?
2. lets see the output of "show create table moiz_partition_test" (if that doesn't work [its hive v0.11 i think] lets see "desc moiz_partition_test" ) 3. what version of hive are you running? pretty bizarre. On Thu, Mar 13, 2014 at 3:48 AM, Arafat, Moiz <[EMAIL PROTECTED]>wrote:
Re: Hive - Sorting on the Partition Column data type Int . Output is Alphabetic Sort
i agree. back in the days of v0.7 who knows if this was a bug or not. What i do know is i have int partitions all over the place and they sort in numeric context just fine every day. i'm running v0.12. pretty sure this worked fine at v0.8 as well - that's when i started in hive.
good luck! On Fri, Mar 14, 2014 at 4:21 AM, Nitin Pawar <[EMAIL PROTECTED]>wrote:
All projects made searchable here are trademarks of the Apache Software Foundation.
Service operated by Sematext