https://pinot.apache.org/ logo
s

Shen Wan

09/03/2020, 6:25 PM
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
.
k

Kishore G

09/03/2020, 6:31 PM
which version are you using
range index is not really needed for time columns since the data is mostly time partitioned
s

Shen Wan

09/03/2020, 7:10 PM
It should not hurt at least?
k

Kishore G

09/03/2020, 7:10 PM
it wont hurt, whats the pinot version you are using
s

Shen Wan

09/03/2020, 7:10 PM
without
order by
the query is fast
how do I see the version?
k

Kishore G

09/03/2020, 7:11 PM
there is a rest api
s

Shen Wan

09/03/2020, 7:13 PM
k

Kishore G

09/03/2020, 7:27 PM
ok, this was fixed
try it with the latest docker snapshot (0.5.0 will be released next week(
🙌 2