Impala order by asc clause is giving me results in a different way (Please see below)
I want results to be in numeric ascending order. How to fix this?
What type is the column you are ordering on? It looks like it's text, since the order you have is lexicographic. Try ORDER BY CAST(col AS INT).