We have a realtime table with a field `timestamp_n...
# troubleshooting
s
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
which version are you using
range index is not really needed for time columns since the data is mostly time partitioned
s
It should not hurt at least?
k
it wont hurt, whats the pinot version you are using
s
without
order by
the query is fast
how do I see the version?
k
there is a rest api
s
Untitled
k
ok, this was fixed
try it with the latest docker snapshot (0.5.0 will be released next week(
🙌 2