Support Questions
Find answers, ask questions, and share your expertise

Impala can not understand sorting in tables

Explorer

I have some tables in impala and in the create tables statement they have sort by( timestamp column) but when I query them they are returning the data not sorted. Why is this happening?

 

For example 

2019-09-18 08:44:10
2020-08-05 13:15:48
2020-08-05 13:24:00
2020-10-15 18:29:34
2020-09-09 09:35:04

5 REPLIES 5

New Contributor

can you share the screenshot? what are you running 

Explorer

The table properties include sort by in a timestamp column. So I am running after select * from db.table1 and it returns me the data like above.  

New Contributor

Your given example is already sorted. I would like to see your query screen and shot and result displayed

Explorer

But it is not sorted 

2019-09-18 08:44:10
2020-08-05 13:15:48
2020-08-05 13:24:00
2020-10-15 18:29:34
2020-09-09 09:35:04

 

Supposed to be asc but its not

New Contributor

2019-09-18 08:44:10
2020-08-05 13:15:48
2020-08-05 13:24:00
2020-10-15 18:29:34
2020-09-09 09:35:04

 

This is already in asc order. check it's format year/mm/dd

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.