Genmao Yu created HIVE-27076:
--------------------------------
Summary: Constant field will be wrongly propagated in grouping sets
Key: HIVE-27076
URL: https://issues.apache.org/jira/browse/HIVE-27076
Project: Hive
Issue Type: Bug
Components: Query Planning
Affects Versions: 4.0.0-alpha-2, 3.1.3, 2.3.8
Reporter: Genmao Yu
Reproduce issue:
{code:sql}
create table tb1 (key string, value string);
insert into tb1 values("a", "b");
with mid1 as (
select 'test_value' as test_field, * from tb1
)
select key, nvl(test_field, 'default_test_value')
from mid1 group by key, test_field
grouping sets(key, test_field, (key, test_field));
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
