When we run Trino with Pinot 0.8.0, we get the err...
# troubleshooting
m
When we run Trino with Pinot 0.8.0, we get the error
unsupported data table version: 3
. It seems Trino still uses Pinot client 0.6.0. Do we have plans on upgrade it to 0.8.0? If it is as simple as bumping up the version, I can help raise a PR.
m
@Elon is it already in the works?
e
Yes, we already have a pr being actively reviewed and we deployed it. Also we have support for a lot of the newer features: lookup join, groovy functions, grpc streaming, passing query parameters, dimension table support (insert and create table) - will document all the features.
m
thats great to hear! Can you point me to the PR? Any ETA on get that merged and released?
x
For Pinot 0.8.0 you can also add a config in Pinot server config files to make Pinot returns v2 format intermediate results.
pinot.server.instance.currentDataTableVersion=2
m
@Xiang Fu thanks! Will give it a try. Was about to patch Trino on my end.
@Elon I did a quick search in trinodb/trino but didn’t find a relevant PR. Could you help link me?
e
sure:) 1 sec
It seems to be backwards compatible
Also, I will be pushing a lot of updates to it shortly (grpc streaming, dimension table support, lookup join support, having clause support)
Have the above working as a poc, would like to push to github in the next few days
m
Sweet, thanks @Elon! By the way, in case I didn’t say it before, the aggregation pushdowns you implemented work like a charm :)
❤️ 2
e
thanks! great to hear:)