[
https://issues.apache.org/jira/browse/HIVE-27898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yongzhi.shao updated HIVE-27898:
--------------------------------
Description:
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-TEZ 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}
was:
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}
> 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
> Priority: Critical
>
> 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-TEZ 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)
