[
https://issues.apache.org/jira/browse/HIVE-29655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa updated HIVE-29655:
----------------------------------
Priority: Minor (was: Major)
> Show original definition query of Iceberg views
> -----------------------------------------------
>
> Key: HIVE-29655
> URL: https://issues.apache.org/jira/browse/HIVE-29655
> Project: Hive
> Issue Type: Improvement
> Components: Iceberg integration
> Reporter: Krisztian Kasa
> Priority: Minor
>
> {code}
> create or replace view v_ice tblproperties ('view-format'='iceberg')
> as select first_name || '-' || dept_id from src_ice where dept_id = 1;
> desc formatted v_ice;
> {code}
> Both Original and Expanded Query are the same
> {code}
> Original Query: select `src_ice`.`first_name` || '-' ||
> `src_ice`.`dept_id` from `ice_native_view_db`.`src_ice` where
> `src_ice`.`dept_id` = 1
> Expanded Query: select `src_ice`.`first_name` || '-' ||
> `src_ice`.`dept_id` from `ice_native_view_db`.`src_ice` where
> `src_ice`.`dept_id` = 1
> {code}
> However Original Query should be:
> {code}
> select first_name || '-' || dept_id from src_ice where dept_id = 1
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
