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

Reply via email to