Krisztian Kasa created HIVE-29655:
-------------------------------------
Summary: 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
{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)
