[HIVE-27076] Constant field will be wrongly propagated in grouping sets

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.3.8, 3.1.3, 4.0.0-alpha-2
• Component/s: Query Planning
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Genmao Yu
• Created: 13/Feb/23 14:21
• Updated: 23/Apr/23 00:21

Description

Reproduce issue:

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));

Issue Links

• links to: GitHub Pull Request #4057