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