hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arafat, Moiz" <moiz.ara...@teamaol.com>
Subject Hive - Sorting on the Partition Column data type Int . Output is Alphabetic Sort
Date Tue, 11 Mar 2014 13:21:14 GMT
Hi ,

I have a table that has a partition column partition_hr . Data Type is int (partition_hr	int)
. When i run a sort on this column the output is like this. 

0
1
10
11
12
13
14
15
16
17
18
19
2
20
21
22
23
3
4
5
6
7
8
9

I expected the output like this  . 

0
1
2
3
4
5
6
7
8
9
10
.
.
and so on.

It works fine for non-partition columns. Please advise.

Thanks,
Moiz


Mime
View raw message