Hi Team, I am having issues with a basic select qu...
# troubleshooting
w
Hi Team, I am having issues with a basic select query in a REALTIME table (SELECT var1, var2 ... FROM table WHERE var1 = 'XXXXXXXXXX' LIMIT 1000000). When I run this query from the PinotUI, the query
timeUsedMs
is 3022Ms but the wall-time between between me running the query and the results being returned in the Pinot UI is over 40s . Some more facts about the query: totalDocs: 366534278 numDocsScanned: 790596 numSegmentsQueried: 107 The table I am querying's segments are split over 20 server instances per pool. (I am using pool-based instance assignment with 2 pools of 20 servers in each) Can anyone explain what might be causing the wall-time to be so much longer than the
timeUsedMs
?