Skip to content

SQL with filter condition "or" can not be pushed down to Iceberg metadata when do sql plan #9786

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
Xiangakun opened this issue Oct 27, 2021 · 2 comments

Comments

@Xiangakun
Copy link
Contributor

SQL with filter condition "or" (e.g. ' select * from iceberg.iceberg_schema.tableA where id = 1 or data = 'test' ') can not be pushed down to Iceberg metadata when doing sql plan stage, which lead to such scenario can not make full use of iceberg’s MIN/MAX index. As far as I know, Iceberg itself supports filter with 'or' condition. I am wondering if it's the limit by current framework of trino ?Does anyone has good idea on this? Thanks in advance

@Xiangakun
Copy link
Contributor Author

I am now using trino with version: 355

@findepi
Copy link
Member

findepi commented Oct 30, 2021

This is going to be covered by #7994.
See #18 for more info.

@findepi findepi closed this as completed Oct 30, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants