Krisztian Kasa created HIVE-23101: ------------------------------------- Summary: Fix topnkey_grouping_sets Key: HIVE-23101 URL: https://issues.apache.org/jira/browse/HIVE-23101 Project: Hive Issue Type: Sub-task Reporter: Krisztian Kasa Assignee: Krisztian Kasa Fix For: 4.0.0
Test *topnkey_grouping_sets* fails intermittently. Queries which project 2 columns but order by only one of them can have more than one good result set: {code} CREATE TABLE t_test_grouping_sets( a int, b int, c int ); INSERT INTO t_test_grouping_sets VALUES (NULL, NULL, NULL), (5, 2, 3), (10, 11, 12), (NULL, NULL, NULL), (NULL, NULL, NULL), (6, 2, 1), (7, 8, 4), (7, 8, 4), (7, 8, 4), (5, 1, 2), (5, 1, 2), (5, 1, 2), (NULL, NULL, NULL); SELECT a, b FROM t_test_grouping_sets GROUP BY GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a LIMIT 10; {code} {code} 5 NULL 5 2 5 1 6 2 6 NULL 7 8 7 NULL 10 NULL 10 11 NULL 1 {code} {code} 5 NULL 5 2 5 1 6 2 6 NULL 7 8 7 NULL 10 NULL 10 11 NULL NULL {code} Since we don't order by *b* both result sets are valid. -- This message was sent by Atlassian Jira (v8.3.4#803005)