Hello, I'm trying to configure presto to query pin...
# troubleshootingd
Dan DC
09/16/2021, 2:00 PMHello, I'm trying to configure presto to query pinot tables. The catalogue seems fine, I can show tables in Pinot. However when I issue a query I get the following error:
Query <id> failed: Cannot fetch from cache <table>m
Mayank
09/16/2021, 2:33 PM
Are you able to run Pinot query directly? Also can you run explain on presto
d
Dan DC
09/16/2021, 2:47 PMThe query runs in Pinot, is a simple statement
select * from <table> limit 1Dan DC
09/16/2021, 3:20 PMI'm running Pinot 0.8.0 and Presto 0.261
Dan DC
09/17/2021, 12:48 PMI've enabled the debug flag in the Presto CLI and there is an issue parsing my schema. The stack trace says that
dataTypedimensionFieldSpecTIMESTAMPDan DC
09/17/2021, 12:49 PMI believe this is a bug in the presto connector
Dan DC
09/17/2021, 12:50 PMI'll raise it in the prestodb project
Dan DC
09/17/2021, 1:13 PMRight, it seems Xiang has upgraded the dependency in pinot-driver already and I just need to wait for the next release
m
Mayank
09/17/2021, 1:55 PM
Thanks @Dan DC for finding this
d
Dan DC
09/17/2021, 2:49 PMNo problem 👍