[HIVE-23101] Fix topnkey_grouping_sets

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 30/Mar/20 08:15
• Updated: 17/Nov/22 08:50
• Resolved: 02/Apr/20 08:32

Description

Example:

Client Execution succeeded but contained differences (error code = 1) after executing topnkey_grouping_sets.q 
260c260
< NULL NULL
---
> NULL 1

 

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:

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;

5	NULL
5	2
5	1
6	2
6	NULL
7	8
7	NULL
10	NULL
10	11
NULL	1

5	NULL
5	2
5	1
6	2
6	NULL
7	8
7	NULL
10	NULL
10	11
NULL	NULL

Since we don't order by b both result sets are valid.

Issue Links

• relates to: HIVE-17896 TopNKey: Create a standalone vectorizable TopNKey operator
• links to: Review Board