zhangbutao commented on PR #3288: URL: https://github.com/apache/hive/pull/3288#issuecomment-2635951209
> @wecharyu, I think we need to provide catalog type & connection details: > > ``` > CREATE CATALOG [IF NOT EXISTS] <catalog_name> TYPE 'iceberg' > PROPERTIES ( > 'catalog-type'='rest', > 'uri'='https://iceberg-with-rest:8181/' > ) > ``` > > see https://iceberg.apache.org/docs/1.4.0/flink-ddl/ > > TYPES: > > * Hive (Hive External / ACID tables) - default > * Iceberg (HMS-backed Hive catalog, Hadoop, Rest Catalog ) > > @zhangbutao, @okumin WDYT? I am fine with this syntax. But this PR is really just a supplement to HIVE-18685. It just added sql capabilities on top of HIVE-18685 for ease of operation releated HMS catalog. @deniskuzZ @okumin If we're on the same page, we want a multi-catalog capability like Trino. **And the multi-catalog is different the HMS catalog of HIVE-18685**. Multi-catalog can be used for federated query by using three-layer identifiers like catalog_name.dbName.tblName. For example, **select * from hive_catalog.testhivedb.testhivetbl join iceberg_catalog.testdb.testicetbl on testhivetbl.id = testicetbl.id**; we can also add other datasource in multi-catalog like jdbc catalog. BTW, HIVE-24396 added the data connector which can map a jdbc database instead of a jdbc table, but it can not map all external databases. With multi-catalog, we can map all external databases at once, just like trino jdbc catalog. Now, I have not figured out how to achieve this multi-catalog ability. I think multi-catalog is beyond the scope of this PR. Of course, maybe we can implement the multi-catalog based on this PR & HIVE-18685. :) -- 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: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org
