[
https://issues.apache.org/jira/browse/HIVE-28908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18079448#comment-18079448
]
Butao Zhang commented on HIVE-28908:
------------------------------------
[~krisztiankasa]
Sure, feel free to pick up this task. Thank you for your interest in this
feature!
Additionally, this JIRA and HIVE-29279 have some overlap in terms of code
development, as both aim to support the `cat.db.tbl` table reference syntax in
Hive. You can combine the development efforts with HIVE-29279.
Currently, Hive uses the `db.tbl.metatbl` reference syntax to query Iceberg
metadata tables, which conflicts with the introduction of the `cat.db.tbl`
syntax. Therefore, we may need to make an incompatible change regarding the
querying of Iceberg metadata tables. Refer to:
[https://github.com/apache/hive/pull/6252#discussion_r2652627443]
and
[https://docs.google.com/document/d/1SX8OPd_KdBuynMr-D8AZ7V5tKkoUDKFterUSjeRpOW0/edit?disco=AAAB2qdl4d4]
We can continue discussing this incompatible change on the community dev
mailing list:
[https://lists.apache.org/thread/g9hg52hkk4lv596ylkggrvgcd4kj70pb]
Of course, if you can come up with any compatible changes that don't break the
current functionality, that would be best.
Thanks
> From clause supports catalog.db.tbl pattern
> -------------------------------------------
>
> Key: HIVE-28908
> URL: https://issues.apache.org/jira/browse/HIVE-28908
> Project: Hive
> Issue Type: Sub-task
> Components: Query Processor
> Reporter: Butao Zhang
> Priority: Major
> Labels: pull-request-available
>
> For example, we can query a iceberg table by the{color:#FF0000}
> catalog.db.tbl{color} pattern:
> {code:java}
> // The catalog of hive can be the HMS native catalog or other external
> catalog(rest)
> select * from hive.testicedb.testice;{code}
>
> For the iceberg metadata table, we can use the{color:#FF0000}
> catalog.db.tbl.meta{color} pattern
> {code:java}
> select * from hive.testicedb.testice.history;{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
