I’ve been running warm-up SQL queries on our Pinot...
# troubleshooting
a
I’ve been running warm-up SQL queries on our Pinot hybrid table early in the morning to ensure that my team can run queries on it smoothly throughout the day. This approach was implemented after I noticed that basic SQL queries were returning inconsistent results initially. However, when rerunning the same query multiple times, the results started stabilizing and returning the expected output. It appeared that some segments weren’t fully loaded, and after repeatedly querying the same segments, the complete data was eventually reflected. Has anyone else encountered similar behavior? Any suggestions or solutions to address this issue?
x
are those large queries and you are encountering timeout and incompleted results?
technically you can increase the timeout for the query, then it will hit all the segments.
also what’s the data volume and number of segments you have in the table(realtime/offline) and the sample queries?
a
I have increased the timeout for the query and the results are now showing properly