Has anyone seen this error when running Trino with...
# troubleshootingm
Map
07/30/2021, 2:31 PMHas anyone seen this error when running Trino with Pinot? Googled about this error but didn't find something useful.
Copy code
trino:default> select count(*) from table1 group by MSGTIME limit 10;
Query 20210730_141801_00012_uani3, FAILED, 1 node
Splits: 51 total, 0 done (0.00%)
0.16 [0 rows, 0B] [0 rows/s, 0B/s]
Query 20210730_141801_00012_uani3 failed: Segment query returned '50001' rows per split, maximum allowed is '50000' rows. with query "SELECT MSGTIME FROM table1_REALTIME LIMIT 50001"a
Ashhar Hasan
07/30/2021, 2:52 PMYou can set
pinot.max-rows-per-split-for-segment-queriesAshhar Hasan
07/30/2021, 2:53 PMAnother alternative is to do pass-through queries as described at https://trino.io/docs/current/connector/pinot.html#dynamic-tables
m
Map
07/30/2021, 3:01 PMah thanks @Ashhar Hasan! I did remember there is such a setting that allows you to configure it but the doc doesn't say it
Map
07/30/2021, 3:01 PMhad to go look at the code to unearth it
Map
07/30/2021, 3:08 PMis it correct to say that only predicate and limit pushdowns are supported and we don't do any aggregation pushdowns?
k
Kishore G
07/30/2021, 3:15 PM
aggregate push down is supported in presto and trino also added it recently - @Elon - can you please confirm?
e
Elon
07/30/2021, 4:29 PMThe pull request is still open but is very close to being merged.
👍 1