We have a realtime table with a field `timestamp ns` which i

Question

We have a realtime table with a field `timestamp ns` which is the `segmentsConfig timeColumnName` and has range index When I used `order by timestamp ns` in an SQL query it will time out Why I expect range index to help `order by`

Kishore G · Answer

which version are you using

Kishore G · Answer

range index is not really needed for time columns since the data is mostly time partitioned

Shen Wan · Answer

It should not hurt at least

Kishore G · Answer

it wont hurt whats the pinot version you are using

Shen Wan · Answer

without `order by` the query is fast

Shen Wan · Answer

how do I see the version

Kishore G · Answer

there is a rest api

Kishore G · Answer

ok this was fixed

Kishore G · Answer

Kishore G · Answer

try it with the latest docker snapshot 0 5 0 will be released next week