Hi we are querying Pinot via Trino with dynamic ta...
# troubleshooting
m
Hi we are querying Pinot via Trino with dynamic tables and have recently encountered this error:
Copy code
SELECT * FROM pinot.default."SELECT max(COL1) from table0";
Query 20210810_205808_00168_gj79s failed: class java.lang.String cannot be cast to class java.lang.Number (java.lang.String and java.lang.Number are in module java.base of loader 'bootstrap')
COL1
can be type of INT, LONG, FLOAT, or DOUBLE in here...not sure if someone has seen this before?
j
@Elon Can you please help take a look?
e
Yep, this is a known issue and is resolved with https://github.com/trinodb/trino/pull/6069
m
Oh thanks Elon! Good to know the aggregation pushdown is going to resolve this. Hope it will get merged soon!
👍 1
e
Seems like it's very close!
👍 1
a
The aggregation pushdown PR has been merged and will be a part of the next release which is 361. It should be out soon. Thanks a lot for the work on that @Elon. ❤️
🎉 2
e
Thanks @Ashhar Hasan!!!!
m
thanks @Elon and @Ashhar Hasan for making this happen! 😃
👍 2