satanson opened a new issue, #7835: URL: https://github.com/apache/paimon/issues/7835
### Search before asking - [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar. ### Paimon version 1.2.0 <paimon.version>1.2.0</paimon.version> <dependency> <groupId>org.apache.paimon</groupId> <artifactId>paimon-bundle</artifactId> <version>${paimon.version}</version> <exclusions> <exclusion> <artifactId>lz4-java</artifactId> <groupId>org.lz4</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.apache.paimon</groupId> <artifactId>paimon-s3</artifactId> <version>${paimon.version}</version> </dependency> <dependency> <groupId>org.apache.paimon</groupId> <artifactId>paimon-oss</artifactId> <version>${paimon.version}</version> </dependency> ### Compute Engine StarRocks 3.5.16 ### Minimal reproduce step ## step1: create paimon catalog: ```sql CREATE EXTERNAL CATALOG mrs_paimon PROPERTIES ( "type" = "paimon", "paimon.catalog.type"="hive", "paimon.catalog.warehouse"="obs://hwem-gri-oversea-m241-la-mrs-uat-mex2-oss/bdp/paimon/warehouse", "hive.metastore.uris"="thrift://[10.205.200.146:9083](http://10.205.200.146:9083/),thrift://[10.205.200.64:9083](http://10.205.200.64:9083/)", "aws.s3.enable_ssl" = "false", "aws.s3.enable_path_style_access" = "true", "aws.s3.endpoint" = "[obs.la-north-2.myhuaweicloud.com](http://obs.la-north-2.myhuaweicloud.com/)", "aws.s3.access_key" = "xxxx", "aws.s3.secret_key" = "xxxxxxx" ) USE mrs_paimon; SHOW DATABASES FROM mrs_paimon; ``` ## 2. issue query report error query as follows ```sql SELECT * FROM `mrs_paimon`.`paimon_db`.`my_table` LIMIT 20 ``` FE report error to mysql client: ``` Error 1064 (HY000): org.apache.paimon.fs.UnsupportedSchemeException: Could not find a file io implementation for scheme 'obs' in the classpath. Hadoop FileSystem also cannot access this path 'obs://hwem-gri-oversea-m241-la-mrs-uat-mex2-oss/bdp/paimon/warehouse'. ``` detail error info in fe.log ``` (starrocks-mysql-nio-pool-176|11849049) [StmtExecutor.execute():975] execute Exception, sql: SELECT * FROM `mrs_paimon`.`paimon_db`.`my_table` LIMIT 20, error: Getting analyzing error. Detail message: Unknown table 'paimon_db.my_table'. WARN (starrocks-mysql-nio-pool-176|11849049) [StmtExecutor.logOptimizerTraceOnGenerateExecPlanFailure():697] Generate exec plan failed. Planner profile: query_id=c2661632-4d18-11f1-ad90-fa163e2e29f1, sql=SELECT * FROM `mrs_paimon`.`paimon_db`.`my_table` LIMIT 20, err=SemanticException: Getting analyzing error. Detail message: Unknown table 'paimon_db.my_table'., profile=Planner: - -- Parser[1] 0 - -- Total[1] 35ms - -- Analyzer[1] 35ms - -- Lock[1] 0 - -- AnalyzeDatabase[1] 0 - -- AnalyzeTemporaryTable[1] 0 - -- AnalyzeTable[1] 35ms Reason: ``` ## 3. desc paimon table also report error ``` SHOW CATALOGS; SHOW CREATE CATALOG mrs_paimon; SET CATALOG mrs_paimon; SHOW DATABASES; USE paimon_db; desc my_table; ``` ``` 2026-05-12 14:49:25.861+08:00 WARN (starrocks-mysql-nio-pool-1|171) [StmtExecutor.logOptimizerTraceOnGenerateExecPlanFailure():697] Generate exec plan Planner profile: query_id=b73fcf55-4dce-11f1-a1d0-fa163e2e29fa, sql=desc my_table, err=SemanticException: Getting analyzing error. Detail message: Unknown node path: /catalog/mrs_paimon/paimon_db/my_table/schema. msg: table : my_table not exists., profile=Planner: --- Parser[1] 1ms --- Total[1] 37ms Reason: 2026-05-12 14:49:25.860+08:00 ERROR (starrocks-mysql-nio-pool-1|171) [PaimonMetadata.getTable():243] Paimon table paimon_db.my_table does not exist. org.apache.paimon.Catalog$TableNotExistException: Table paimon_db.my_table does not exist. at org.apache.paimon.hive.HiveCatalog.lambda$loadTableSchema$18(HiveCatalog.java:709) at java.util.Optional.orElseThrow(Optional.java:403) at org.apache.paimon.hive.HiveCatalog.loadTableSchema(HiveCatalog.java:709) at org.apache.paimon.hive.HiveCatalog.loadTableMetadata(HiveCatalog.java:692) at org.apache.paimon.hive.HiveCatalog.loadTableMetadata(HiveCatalog.java:686) at org.apache.paimon.catalog.CatalogUtils.loadTable(CatalogUtils.java:200) at org.apache.paimon.catalog.AbstractCatalog.getTable(AbstractCatalog.java:460) at org.apache.paimon.catalog.CachingCatalog.getTable(CachingCatalog.java:242) at com.starrocks.connector.paimon.PaimonMetadata.getTable(PaimonMetadata.java:241) at com.starrocks.connector.CatalogConnectorMetadata.getTable(CatalogConnectorMetadata.java:148) at com.starrocks.server.MetadataMgr.lambda$getTables$5(MetadataMgr.java:507) at java.util.Optional.map(Optional.java:260) at com.starrocks.server.MetadataMgr.getTable(MetadataMgr.java:507) at com.starrocks.common.proc.ExternalTablesProcDir.lookup(ExternalTablesProcDir.java:60) at com.starrocks.common.proc.ProcService.open(ProcService.java:112) at com.starrocks.sql.analyzer.ShowStmtAnalyzer$ShowStmtAnalyzerVisitor.descExternalCatalogTable(ShowStmtAnalyzer.java:549) at com.starrocks.sql.analyzer.ShowStmtAnalyzer$ShowStmtAnalyzerVisitor.visitDescTableStmt(ShowStmtAnalyzer.java:368) at com.starrocks.sql.analyzer.ShowStmtAnalyzer$ShowStmtAnalyzerVisitor.visitDescTableStmt(ShowStmtAnalyzer.java:108) at com.starrocks.sql.ast.DescribeStmt.accept(DescribeStmt.java:210) at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:102) at com.starrocks.sql.analyzer.ShowStmtAnalyzer$ShowStmtAnalyzerVisitor.analyze(ShowStmtAnalyzer.java:114) at com.starrocks.sql.analyzer.ShowStmtAnalyzer.analyze(ShowStmtAnalyzer.java:105) at com.starrocks.sql.analyzer.Analyzer$AnalyzerVisitor.visitShowStatement(Analyzer.java:432) at com.starrocks.sql.analyzer.Analyzer$AnalyzerVisitor.visitDescTableStmt(Analyzer.java:190) at com.starrocks.sql.ast.AstVisitor.visitDescTableStmt(AstVisitor.java:244) at com.starrocks.sql.ast.DescribeStmt.accept(DescribeStmt.java:210) at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:102) at com.starrocks.sql.analyzer.Analyzer.analyze(Analyzer.java:187) at com.starrocks.qe.StmtExecutor.generateExecPlan(StmtExecutor.java:612) at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:757) at com.starrocks.qe.ConnectProcessor.executeQueryStatement(ConnectProcessor.java:547) at com.starrocks.qe.ConnectProcessor.runWithParserStageRetry(ConnectProcessor.java:435) at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:372) at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:758) at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:1148) at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:71) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ... ``` ## step4: Transform obs path into s3 path in catalog ddl, it also does not work. ``` CREATE EXTERNAL CATALOG mrs_paimon PROPERTIES ( "type" = "paimon", "paimon.catalog.type" = "hive", "paimon.catalog.warehouse" = "s3://hwem-gri-oversea-m241-la-mrs-uat-mex2-oss/bdp/paimon/warehouse", "hive.metastore.uris" = "thrift://[10.205.200.146:9083](http://10.205.200.146:9083/),thrift://[10.205.200.64:9083](http://10.205.200.64:9083/)", "aws.s3.enable_ssl" = "true", "aws.s3.enable_path_style_access" = "true", "aws.s3.endpoint" = "https://obs.la-north-2.myhuaweicloud.com/";, "aws.s3.region" = "la-north-2", "aws.s3.access_key" = "xxxx", "aws.s3.secret_key" = "xxxxxxx" ); CREATE EXTERNAL CATALOG mrs_paimon PROPERTIES ( "type" = "paimon", "paimon.catalog.type" = "hive", "hive.metastore.uris" = "thrift://[10.205.200.146:9083](http://10.205.200.146:9083/),thrift://[10.205.200.64:9083](http://10.205.200.64:9083/)", "paimon.catalog.warehouse" = "s3a://hwem-gri-oversea-m241-la-mrs-uat-mex2-oss/bdp/paimon/warehouse", "aws.s3.enable_ssl" = "true", "aws.s3.enable_path_style_access" = "true", "aws.s3.endpoint" = "[obs.la-north-2.myhuaweicloud.com](http://obs.la-north-2.myhuaweicloud.com/)", "aws.s3.access_key" = "xxx", "aws.s3.secret_key" = "xxx" ); ``` ### What doesn't meet your expectations? Paimon catalog StarRocks can access paimon data on OBS. ### Anything else? _No response_ ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
