yongzhi.shao created HIVE-27898:
-----------------------------------
Summary: HIVE4 can't use ICEBERG table in subqueries
Key: HIVE-27898
URL: https://issues.apache.org/jira/browse/HIVE-27898
Project: Hive
Issue Type: Bug
Components: Iceberg integration
Affects Versions: 4.0.0-beta-1
Reporter: yongzhi.shao
Currently, we found that when using HIVE4-BETA1 version, if we use ICEBERG
table in the subquery, we can't get any data in the end.
I have used HIVE3 for cross validation and HIVE3 does not have this problem
when querying ICEBERG.
{code:java}
--iceberg
select * from iceberg_dwd.b_std_trade
where uni_shop_id = 'TEST|11111' limit 10 --10 rows
select *
from (
select * from iceberg_dwd.b_std_trade
where uni_shop_id = 'TEST|11111' limit 10
) t1; --10 rows
select uni_shop_id
from (
select * from iceberg_dwd.b_std_trade
where uni_shop_id = 'TEST|11111' limit 10
) t1; --0 rows
select uni_shop_id
from (
select uni_shop_id as uni_shop_id from iceberg_dwd.b_std_trade
where uni_shop_id = 'TEST|11111' limit 10
) t1; --0 rows
--orc
select uni_shop_id
from (
select * from iceberg_dwd.trade_test
where uni_shop_id = 'TEST|11111' limit 10
) t1; --10 ROWS{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
