So playing with the Dynamic tables section on the ...
# troubleshootings
Stuart Millholland
03/16/2022, 4:53 PMSo playing with the Dynamic tables section on the Trino Pinot connector here. I'm finding that in order to filter on a column it has to be in the SELECT portion within the double quotes. I'm wondering if the documentation needs to be adjusted there, or I could also be doing something wrong.
Stuart Millholland
03/16/2022, 4:54 PMIs this what the document should say?
Copy code
SELECT *
FROM pinot.default."SELECT col3, col4, MAX(col1), COUNT(col2) FROM pinot_table GROUP BY col3, col4"
WHERE col3 IN ('FOO', 'BAR') AND col4 > 50
LIMIT 30000m
Mayank
03/16/2022, 4:55 PM
@User to confirm. Definitely +1 on fixing the doc if it needs to.
e
Elon
03/16/2022, 4:56 PMThanks for catching this! Agreed, will update.
🙏 1
s
Stuart Millholland
03/16/2022, 4:56 PMAwesome, ty!
m
Mayank
03/16/2022, 4:56 PM
That was quick (as always), thanks @User
😃 2