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

[BUG] Creating Iceberg View yields 'Unknown Error' when attempting to run SHOW TABLES #56390

Open
xsfa opened this issue Feb 27, 2025 · 0 comments
Labels
type/bug Something isn't working

Comments

@xsfa
Copy link

xsfa commented Feb 27, 2025

Steps to reproduce the behavior (Required)

CREATE OR REPLACE VIEW catalog.db.table AS SELECT
. . . 

View subsequently gets registered as a VIEW in the Iceberg REST Catalog, and is perfectly queryable

However, now SHOW TABLES from the db where the view was created is broken

SHOW TABLES FROM db

Expected behavior (Required)

SHOW TABLES should work as expected and show all tables in the selected iceberg namespace

Real behavior (Required)

Client Error:
SQL Error [1064] [42000]: Unknown error

Server Error:

2025-02-27 18:37:16.298Z ERROR (starrocks-mysql-nio-pool-1552|1154433) [MetadataMgr.listTableNames():259] Failed to listTableNames on [gold.ServiceDM]
java.lang.UnsupportedOperationException: null
  at org.apache.iceberg.relocated.com.google.common.collect.ImmutableCollection.addAll(ImmutableCollection.java:297) ~[iceberg-bundled-guava-1.6.0.jar:?]
  at com.starrocks.connector.iceberg.rest.IcebergRESTCatalog.listTables(IcebergRESTCatalog.java:199) ~[starrocks-fe.jar:?]
  at com.starrocks.connector.iceberg.IcebergMetadata.listTableNames(IcebergMetadata.java:237) ~[starrocks-fe.jar:?]
  at com.starrocks.connector.CatalogConnectorMetadata.listTableNames(CatalogConnectorMetadata.java:114) ~[starrocks-fe.jar:?]
  at com.starrocks.server.MetadataMgr.listTableNames(MetadataMgr.java:257) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ShowExecutor$ShowExecutorVisitor.visitShowTableStatement(ShowExecutor.java:486) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ShowExecutor$ShowExecutorVisitor.visitShowTableStatement(ShowExecutor.java:291) ~[starrocks-fe.jar:?]
  at com.starrocks.sql.ast.ShowTableStmt.accept(ShowTableStmt.java:131) ~[starrocks-fe.jar:?]
  at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ShowExecutor.execute(ShowExecutor.java:288) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.StmtExecutor.handleShow(StmtExecutor.java:1749) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:699) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:366) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:565) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:903) ~[starrocks-fe.jar:?]
  at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
  at java.lang.Thread.run(Thread.java:829) ~[?:?]
2025-02-27 18:37:16.298Z WARN (starrocks-mysql-nio-pool-1552|1154433) [StmtExecutor.execute():765] execute Exception, sql /* ApplicationName=DBeaver 23.2.5 - SQLEditor <Script-45.sql> */ show tables
java.lang.UnsupportedOperationException: null
  at org.apache.iceberg.relocated.com.google.common.collect.ImmutableCollection.addAll(ImmutableCollection.java:297) ~[iceberg-bundled-guava-1.6.0.jar:?]
  at com.starrocks.connector.iceberg.rest.IcebergRESTCatalog.listTables(IcebergRESTCatalog.java:199) ~[starrocks-fe.jar:?]
  at com.starrocks.connector.iceberg.IcebergMetadata.listTableNames(IcebergMetadata.java:237) ~[starrocks-fe.jar:?]
  at com.starrocks.connector.CatalogConnectorMetadata.listTableNames(CatalogConnectorMetadata.java:114) ~[starrocks-fe.jar:?]
  at com.starrocks.server.MetadataMgr.listTableNames(MetadataMgr.java:257) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ShowExecutor$ShowExecutorVisitor.visitShowTableStatement(ShowExecutor.java:486) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ShowExecutor$ShowExecutorVisitor.visitShowTableStatement(ShowExecutor.java:291) ~[starrocks-fe.jar:?]
  at com.starrocks.sql.ast.ShowTableStmt.accept(ShowTableStmt.java:131) ~[starrocks-fe.jar:?]
  at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:79) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ShowExecutor.execute(ShowExecutor.java:288) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.StmtExecutor.handleShow(StmtExecutor.java:1749) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:699) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:366) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:565) ~[starrocks-fe.jar:?]
  at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:903) ~[starrocks-fe.jar:?]
  at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
  at java.lang.Thread.run(Thread.java:829) ~[?:?]
2025-02-27 18:37:16.299Z INFO (starrocks-mysql-nio-pool-1552|1154433) [MetadataMgr.removeQueryMetadata():200] Succeed to deregister query level connector metadata on query id: Optional[de472465-f539-11ef-a651-00505691c707]

StarRocks version (Required)

3.3.7-00177de

@xsfa xsfa added the type/bug Something isn't working label Feb 27, 2025
@xsfa xsfa changed the title Creating Iceberg View yields 'Unknown Error' when attempting to run SHOW TABLES [BUG] Creating Iceberg View yields 'Unknown Error' when attempting to run SHOW TABLES Feb 27, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant