Skip to content
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

Report enforce predicate in JDBC connectors' getTableProperties #4607

Open
findepi opened this issue Jul 28, 2020 · 1 comment
Open

Report enforce predicate in JDBC connectors' getTableProperties #4607

findepi opened this issue Jul 28, 2020 · 1 comment
Labels
enhancement New feature or request

Comments

@findepi
Copy link
Member

findepi commented Jul 28, 2020

Once we do #4111 we should enhance io.prestosql.plugin.jdbc.JdbcMetadata#getTableProperties
to return information about enforced predicate.

Depends on #4111.

@findepi findepi added the enhancement New feature or request label Jul 28, 2020
@findepi findepi changed the title Reported enforce predicate in JDBC connectors' getTableProperties Report enforce predicate in JDBC connectors' getTableProperties Jul 28, 2020
@findepi
Copy link
Member Author

findepi commented Jul 28, 2020

I scenario where this could be visible is

SELECT *
FROM (SELECT * FROM table_a WHERE ak = 42)
INNER JOIN  (SELECT * FROM table_b WHERE bk = 42) ON ak = bk

Once we push predicates into JDBC table scan, we need getTableProperties
to let the optimizer know that the join is actually a cross join.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Development

No branches or pull requests

1 participant