praveenc7 commented on issue #15064:
URL: https://github.com/apache/pinot/issues/15064#issuecomment-2663860662
@yashmayya Yes we do see this in queries having large IN clauses. However
this was observed in some simple queries as well
Query pattern
```
SELECT col_a, MAX(col_b)
FROM table_x
WHERE col_b >= 10000
AND col_c NOT IN ('value_x')
AND col_d = 123456789
// Large IN clause
AND col_a IN (
'x1',
x2',
'x3',
'x4'
.......
'x1000'
);
```
```
SELECT col_a, col_b, col_c, SUM(col_d)
FROM table_y
WHERE col_a IN ('XXXXX') -- High cardinality
AND col_c >= 10000
GROUP BY col_a, col_b, col_c
ORDER BY SUM(col_d) DESC
LIMIT 20000;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
