This is an automated email from the ASF dual-hosted git repository. pvary pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push: new 94f90bc HIVE-23101: Fix topnkey_grouping_sets (Kasa Krisztian, reviewed by Zoltan Haindrich) 94f90bc is described below commit 94f90bcef60c9a527d9a689283b4fe0004f4c946 Author: Krisztian Kasa <kk...@cloudera.com> AuthorDate: Wed Apr 1 11:12:42 2020 +0200 HIVE-23101: Fix topnkey_grouping_sets (Kasa Krisztian, reviewed by Zoltan Haindrich) --- .../test/resources/testconfiguration.properties | 1 + .../queries/clientpositive/topnkey_grouping_sets.q | 54 +- .../llap/topnkey_grouping_sets.q.out | 188 ++- .../clientpositive/topnkey_grouping_sets.q.out | 1236 -------------------- 4 files changed, 120 insertions(+), 1359 deletions(-) diff --git a/itests/src/test/resources/testconfiguration.properties b/itests/src/test/resources/testconfiguration.properties index cfe83d6..3e89071 100644 --- a/itests/src/test/resources/testconfiguration.properties +++ b/itests/src/test/resources/testconfiguration.properties @@ -16,6 +16,7 @@ disabled.query.files=cbo_rp_subq_in.q,\ sample4.q,\ root_dir_external_table.q,\ sort_acid.q,\ + topnkey_grouping_sets.q,\ input31.q diff --git a/ql/src/test/queries/clientpositive/topnkey_grouping_sets.q b/ql/src/test/queries/clientpositive/topnkey_grouping_sets.q index e8c5401..3efd0b9 100644 --- a/ql/src/test/queries/clientpositive/topnkey_grouping_sets.q +++ b/ql/src/test/queries/clientpositive/topnkey_grouping_sets.q @@ -20,75 +20,75 @@ INSERT INTO t_test_grouping_sets VALUES set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3; -SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3; +SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3; +SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3; set hive.optimize.topnkey=false; -SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3; +SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3; set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10; set hive.optimize.topnkey=false; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10; set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3; set hive.optimize.topnkey=false; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3; set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1; set hive.optimize.topnkey=false; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1; set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7; set hive.optimize.topnkey=false; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7; set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7; set hive.optimize.topnkey=false; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7; set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7; set hive.optimize.topnkey=false; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7; set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7; set hive.optimize.topnkey=false; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7; set hive.optimize.topnkey=true; EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7; set hive.optimize.topnkey=false; -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7; +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7; set hive.optimize.topnkey=true; diff --git a/ql/src/test/results/clientpositive/llap/topnkey_grouping_sets.q.out b/ql/src/test/results/clientpositive/llap/topnkey_grouping_sets.q.out index 41a8c3a..c376b15 100644 --- a/ql/src/test/results/clientpositive/llap/topnkey_grouping_sets.q.out +++ b/ql/src/test/results/clientpositive/llap/topnkey_grouping_sets.q.out @@ -44,12 +44,12 @@ POSTHOOK: Lineage: t_test_grouping_sets.a SCRIPT [] POSTHOOK: Lineage: t_test_grouping_sets.b SCRIPT [] POSTHOOK: Lineage: t_test_grouping_sets.c SCRIPT [] PREHOOK: query: EXPLAIN -SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 +SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 +SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -109,17 +109,17 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 26 Data size: 712 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator - key expressions: _col0 (type: int) - null sort order: z - sort order: + + key expressions: _col0 (type: int), _col1 (type: int) + null sort order: zz + sort order: ++ Statistics: Num rows: 26 Data size: 712 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 - value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint) + value expressions: _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint) Reducer 3 Execution mode: llap Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: bigint), VALUE._col3 (type: bigint) + expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type: bigint), VALUE._col2 (type: bigint) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 26 Data size: 712 Basic stats: COMPLETE Column stats: COMPLETE Limit @@ -139,22 +139,22 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 +PREHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 +POSTHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### 5 1 0 0 0 5 2 0 0 0 5 NULL 0 1 1 -PREHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 +PREHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 +POSTHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a, b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 3 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -162,12 +162,12 @@ POSTHOOK: Input: default@t_test_grouping_sets 5 2 0 0 0 5 NULL 0 1 1 PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -224,17 +224,16 @@ STAGE PLANS: Statistics: Num rows: 26 Data size: 296 Basic stats: COMPLETE Column stats: COMPLETE pruneGroupingSetId: true Reduce Output Operator - key expressions: _col0 (type: int) - null sort order: z - sort order: + + key expressions: _col0 (type: int), _col1 (type: int) + null sort order: zz + sort order: ++ Statistics: Num rows: 26 Data size: 296 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 - value expressions: _col1 (type: int) Reducer 3 Execution mode: llap Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int) + expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 26 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE Limit @@ -254,49 +253,49 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### 5 1 5 2 5 NULL -6 NULL 6 2 +6 NULL 7 8 7 NULL 10 11 10 NULL -NULL 2 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 +NULL 1 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY a, b LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### 5 1 5 2 5 NULL -6 NULL 6 2 -7 NULL +6 NULL 7 8 +7 NULL 10 11 10 NULL NULL 1 PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -346,23 +345,22 @@ STAGE PLANS: Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE pruneGroupingSetId: true Top N Key Operator - sort order: + - keys: _col1 (type: int) - null sort order: z + sort order: ++ + keys: _col1 (type: int), _col0 (type: int) + null sort order: zz Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE top n: 3 Reduce Output Operator - key expressions: _col1 (type: int) - null sort order: z - sort order: + + key expressions: _col1 (type: int), _col0 (type: int) + null sort order: zz + sort order: ++ Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 - value expressions: _col0 (type: int) Reducer 3 Execution mode: llap Reduce Operator Tree: Select Operator - expressions: VALUE._col0 (type: int), KEY.reducesinkkey0 (type: int) + expressions: KEY.reducesinkkey1 (type: int), KEY.reducesinkkey0 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 26 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE Limit @@ -382,22 +380,22 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### 5 1 NULL 1 5 2 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 3 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -405,12 +403,12 @@ POSTHOOK: Input: default@t_test_grouping_sets NULL 1 5 2 PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -460,23 +458,22 @@ STAGE PLANS: Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE pruneGroupingSetId: true Top N Key Operator - sort order: + - keys: _col1 (type: int) - null sort order: z + sort order: ++ + keys: _col1 (type: int), _col0 (type: int) + null sort order: zz Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE top n: 1 Reduce Output Operator - key expressions: _col1 (type: int) - null sort order: z - sort order: + + key expressions: _col1 (type: int), _col0 (type: int) + null sort order: zz + sort order: ++ Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 - value expressions: _col0 (type: int) Reducer 3 Execution mode: llap Reduce Operator Tree: Select Operator - expressions: VALUE._col0 (type: int), KEY.reducesinkkey0 (type: int) + expressions: KEY.reducesinkkey1 (type: int), KEY.reducesinkkey0 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 26 Data size: 88 Basic stats: COMPLETE Column stats: COMPLETE Limit @@ -496,31 +493,31 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### 5 1 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a), (b), ()) ORDER BY b, a LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### 5 1 PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -570,23 +567,22 @@ STAGE PLANS: Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE pruneGroupingSetId: true Top N Key Operator - sort order: + - keys: _col1 (type: int) - null sort order: z + sort order: ++ + keys: _col1 (type: int), _col0 (type: int) + null sort order: zz Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE top n: 7 Reduce Output Operator - key expressions: _col1 (type: int) - null sort order: z - sort order: + + key expressions: _col1 (type: int), _col0 (type: int) + null sort order: zz + sort order: ++ Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 - value expressions: _col0 (type: int) Reducer 3 Execution mode: llap Reduce Operator Tree: Select Operator - expressions: VALUE._col0 (type: int), KEY.reducesinkkey0 (type: int) + expressions: KEY.reducesinkkey1 (type: int), KEY.reducesinkkey0 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 13 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE Limit @@ -606,11 +602,11 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -618,14 +614,14 @@ NULL 1 NULL 2 NULL 8 NULL 11 -10 NULL -NULL NULL +5 NULL 6 NULL -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 +7 NULL +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b, a LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -633,16 +629,16 @@ NULL 1 NULL 2 NULL 8 NULL 11 -10 NULL -NULL NULL +5 NULL 6 NULL +7 NULL PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -728,11 +724,11 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -743,11 +739,11 @@ POSTHOOK: Input: default@t_test_grouping_sets 6 2 6 NULL 5 1 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (a)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -759,12 +755,12 @@ POSTHOOK: Input: default@t_test_grouping_sets 6 NULL 5 1 PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -850,11 +846,11 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -865,11 +861,11 @@ POSTHOOK: Input: default@t_test_grouping_sets 5 2 NULL 1 NULL 2 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), (b)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -881,12 +877,12 @@ POSTHOOK: Input: default@t_test_grouping_sets NULL 1 NULL 2 PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -972,11 +968,11 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -987,11 +983,11 @@ POSTHOOK: Input: default@t_test_grouping_sets 5 2 NULL NULL NULL NULL -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a, b), ()) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -1003,12 +999,12 @@ POSTHOOK: Input: default@t_test_grouping_sets NULL NULL NULL NULL PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 +SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -1094,11 +1090,11 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### @@ -1109,11 +1105,11 @@ POSTHOOK: Input: default@t_test_grouping_sets 5 2 NULL NULL NULL NULL -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 +PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7 PREHOOK: type: QUERY PREHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 +POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a, b)) ORDER BY a DESC, b ASC LIMIT 7 POSTHOOK: type: QUERY POSTHOOK: Input: default@t_test_grouping_sets #### A masked pattern was here #### diff --git a/ql/src/test/results/clientpositive/topnkey_grouping_sets.q.out b/ql/src/test/results/clientpositive/topnkey_grouping_sets.q.out deleted file mode 100644 index 27998ef..0000000 --- a/ql/src/test/results/clientpositive/topnkey_grouping_sets.q.out +++ /dev/null @@ -1,1236 +0,0 @@ -PREHOOK: query: CREATE TABLE t_test_grouping_sets( - a int, - b int, - c int -) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@t_test_grouping_sets -POSTHOOK: query: CREATE TABLE t_test_grouping_sets( - a int, - b int, - c int -) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@t_test_grouping_sets -PREHOOK: query: 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) -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@t_test_grouping_sets -POSTHOOK: query: 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) -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@t_test_grouping_sets -POSTHOOK: Lineage: t_test_grouping_sets.a SCRIPT [] -POSTHOOK: Lineage: t_test_grouping_sets.b SCRIPT [] -POSTHOOK: Lineage: t_test_grouping_sets.c SCRIPT [] -PREHOOK: query: EXPLAIN -SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: _col0 (type: int), _col1 (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: +++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: _col0 (type: int), _col1 (type: int), grouping(_col2, 1L) (type: bigint), grouping(_col2, 0L) (type: bigint), grouping(_col2, 1L, 0L) (type: bigint) - outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 26 Data size: 776 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: int) - null sort order: z - sort order: + - Statistics: Num rows: 26 Data size: 776 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint) - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: bigint), VALUE._col3 (type: bigint) - outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 26 Data size: 776 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 3 - Statistics: Num rows: 3 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 3 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 3 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -5 NULL 0 1 1 -5 2 0 0 0 -5 1 0 0 0 -PREHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b, grouping(a), grouping(b), grouping(a, b) FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -5 NULL 0 1 1 -5 2 0 0 0 -5 1 0 0 0 -PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: a, b - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: +++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: int) - null sort order: z - sort order: + - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col1 (type: int) - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 26 Data size: 152 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 10 - Statistics: Num rows: 10 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 10 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -5 NULL -5 2 -5 1 -6 2 -6 NULL -7 NULL -7 8 -10 11 -10 NULL -NULL 1 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY a LIMIT 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -5 NULL -5 2 -5 1 -6 2 -6 NULL -7 NULL -7 8 -10 11 -10 NULL -NULL 1 -PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: a, b - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: +++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col1 (type: int) - null sort order: z - sort order: + - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col0 (type: int) - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: int), KEY.reducesinkkey0 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 26 Data size: 152 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 3 - Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 3 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -NULL 1 -5 1 -6 2 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -NULL 1 -5 1 -6 2 -PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: a, b - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: +++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col1 (type: int) - null sort order: z - sort order: + - Statistics: Num rows: 26 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col0 (type: int) - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: int), KEY.reducesinkkey0 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 26 Data size: 152 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 1 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -5 1 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a), (b), ()) ORDER BY b LIMIT 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -5 1 -PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: a, b - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: +++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col1 (type: int) - null sort order: z - sort order: + - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col0 (type: int) - Reduce Operator Tree: - Select Operator - expressions: VALUE._col0 (type: int), KEY.reducesinkkey0 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 7 - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 7 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -NULL 1 -NULL 2 -NULL 8 -NULL 11 -5 NULL -7 NULL -NULL NULL -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a), (b)) ORDER BY b LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -NULL 1 -NULL 2 -NULL 8 -NULL 11 -5 NULL -7 NULL -NULL NULL -PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: a, b - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: -++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int) - null sort order: zz - sort order: -+ - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 7 - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 7 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 -10 NULL -7 8 -7 NULL -6 2 -6 NULL -5 1 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (a)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 -10 NULL -7 8 -7 NULL -6 2 -6 NULL -5 1 -PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: a, b - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: -++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int) - null sort order: zz - sort order: -+ - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 7 - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 7 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 -7 8 -6 2 -5 1 -5 2 -NULL 1 -NULL 2 -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), (b)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 -7 8 -6 2 -5 1 -5 2 -NULL 1 -NULL 2 -PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: a, b - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: -++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int) - null sort order: zz - sort order: -+ - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 7 - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 7 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 -7 8 -6 2 -5 1 -5 2 -NULL NULL -NULL NULL -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((a,b), ()) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 -7 8 -6 2 -5 1 -5 2 -NULL NULL -NULL NULL -PREHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int) - outputColumnNames: a, b - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: -++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int) - null sort order: zz - sort order: -+ - Statistics: Num rows: 13 Data size: 184 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 13 Data size: 80 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 7 - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 7 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 7 - Processor Tree: - ListSink - -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 -7 8 -6 2 -5 1 -5 2 -NULL NULL -NULL NULL -PREHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT a, b FROM t_test_grouping_sets GROUP BY a,b GROUPING SETS ((), (a,b)) ORDER BY a DESC, b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 -7 8 -6 2 -5 1 -5 2 -NULL NULL -NULL NULL -PREHOOK: query: EXPLAIN -SELECT tmp.a, tmp.b, max(tmp.c) FROM - (SELECT a, b, c FROM t_test_grouping_sets GROUP BY a, b, c) tmp -GROUP BY tmp.a, tmp.b GROUPING SETS ((), (tmp.a,tmp.b)) ORDER BY tmp.a DESC, tmp.b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: EXPLAIN -SELECT tmp.a, tmp.b, max(tmp.c) FROM - (SELECT a, b, c FROM t_test_grouping_sets GROUP BY a, b, c) tmp -GROUP BY tmp.a, tmp.b GROUPING SETS ((), (tmp.a,tmp.b)) ORDER BY tmp.a DESC, tmp.b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-3 depends on stages: Stage-2 - Stage-0 depends on stages: Stage-3 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: t_test_grouping_sets - Statistics: Num rows: 13 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: a (type: int), b (type: int), c (type: int) - outputColumnNames: a, b, c - Statistics: Num rows: 13 Data size: 120 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - keys: a (type: int), b (type: int), c (type: int) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 6 Data size: 60 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int) - null sort order: zzz - sort order: +++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: int) - Statistics: Num rows: 6 Data size: 60 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Operator Tree: - Group By Operator - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: int) - mode: mergepartial - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 6 Data size: 60 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: max(_col2) - keys: _col0 (type: int), _col1 (type: int), 0L (type: bigint) - minReductionHashAggr: 0.99 - mode: hash - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 6 Data size: 112 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - null sort order: zzz - sort order: -++ - Map-reduce partition columns: _col0 (type: int), _col1 (type: int), _col2 (type: bigint) - Statistics: Num rows: 6 Data size: 112 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col3 (type: int) - Reduce Operator Tree: - Group By Operator - aggregations: max(VALUE._col0) - keys: KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: bigint) - mode: mergepartial - outputColumnNames: _col0, _col1, _col3 - Statistics: Num rows: 6 Data size: 112 Basic stats: COMPLETE Column stats: COMPLETE - pruneGroupingSetId: true - Select Operator - expressions: _col0 (type: int), _col1 (type: int), _col3 (type: int) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 6 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-3 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: int), _col1 (type: int) - null sort order: zz - sort order: -+ - Statistics: Num rows: 6 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col2 (type: int) - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 (type: int), VALUE._col0 (type: int) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 6 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 7 - Statistics: Num rows: 6 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 6 Data size: 64 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: 7 - Processor Tree: - ListSink - -PREHOOK: query: SELECT tmp.a, tmp.b, max(tmp.c) FROM - (SELECT a, b, c FROM t_test_grouping_sets GROUP BY a, b, c) tmp -GROUP BY tmp.a, tmp.b GROUPING SETS ((), (tmp.a,tmp.b)) ORDER BY tmp.a DESC, tmp.b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT tmp.a, tmp.b, max(tmp.c) FROM - (SELECT a, b, c FROM t_test_grouping_sets GROUP BY a, b, c) tmp -GROUP BY tmp.a, tmp.b GROUPING SETS ((), (tmp.a,tmp.b)) ORDER BY tmp.a DESC, tmp.b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 12 -7 8 4 -6 2 1 -5 1 2 -5 2 3 -NULL NULL 12 -NULL NULL NULL -PREHOOK: query: SELECT tmp.a, tmp.b, max(tmp.c) FROM - (SELECT a, b, c FROM t_test_grouping_sets GROUP BY a, b, c) tmp -GROUP BY tmp.a, tmp.b GROUPING SETS ((), (tmp.a,tmp.b)) ORDER BY tmp.a DESC, tmp.b ASC LIMIT 7 -PREHOOK: type: QUERY -PREHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -POSTHOOK: query: SELECT tmp.a, tmp.b, max(tmp.c) FROM - (SELECT a, b, c FROM t_test_grouping_sets GROUP BY a, b, c) tmp -GROUP BY tmp.a, tmp.b GROUPING SETS ((), (tmp.a,tmp.b)) ORDER BY tmp.a DESC, tmp.b ASC LIMIT 7 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@t_test_grouping_sets -#### A masked pattern was here #### -10 11 12 -7 8 4 -6 2 1 -5 1 2 -5 2 3 -NULL NULL 12 -NULL NULL NULL -PREHOOK: query: DROP TABLE IF EXISTS t_test_grouping_sets -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@t_test_grouping_sets -PREHOOK: Output: default@t_test_grouping_sets -POSTHOOK: query: DROP TABLE IF EXISTS t_test_grouping_sets -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@t_test_grouping_sets -POSTHOOK: Output: default@t_test_grouping_sets