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

Iceberg view not registered in system.jdbc.tables #11060

Closed
mdesmet opened this issue Feb 16, 2022 · 1 comment · Fixed by #11063
Closed

Iceberg view not registered in system.jdbc.tables #11060

mdesmet opened this issue Feb 16, 2022 · 1 comment · Fixed by #11063
Assignees
Labels
bug Something isn't working jdbc Relates to Trino JDBC driver

Comments

@mdesmet
Copy link
Contributor

mdesmet commented Feb 16, 2022

When creating a view in iceberg, this view is not registered in system.jdbc.tables. This is making BI tools using the JDBC driver (eg Tableau) not discover the existence of the view as they make use of these tables to show objects in their respective UI's.

How to reproduce using https://github.com/bitsondatadev/trino-getting-started/tree/main/iceberg/trino-iceberg-minio

create schema iceberg.test with (location='s3a://test/test/')
create view iceberg.test.view2 as select * from tpch.sf1.customer limit 100
select * from system.jdbc.tables where table_cat = 'iceberg' and table_type = 'VIEW'
select * from iceberg.test.view2;

Although the view exists and is queryable, it's not registered in system.jdbc.tables.

@mdesmet
Copy link
Contributor Author

mdesmet commented Feb 16, 2022

Same applies to MV's:

create materialized view iceberg.test.mv1 as select * from tpch.sf1.customer limit 100;
select * from iceberg.test.mv1;

@findepi findepi added the bug Something isn't working label Feb 16, 2022
@findepi findepi self-assigned this Feb 16, 2022
@findepi findepi added the jdbc Relates to Trino JDBC driver label Mar 1, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working jdbc Relates to Trino JDBC driver
Development

Successfully merging a pull request may close this issue.

2 participants