You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2016/03/02 12:00:16 UTC
[05/18] hive git commit: HIVE-12994: Implement support for NULLS
FIRST/NULLS LAST (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/9350b693/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out b/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out
index de3cf5b..ea92dac 100644
--- a/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out
@@ -6644,6 +6644,7 @@ STAGE PLANS:
Statistics: Num rows: 348 Data size: 9684 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ null sort order: aaaa
sort order: ++++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 348 Data size: 9684 Basic stats: COMPLETE Column stats: NONE
@@ -6742,6 +6743,7 @@ STAGE PLANS:
Statistics: Num rows: 348 Data size: 9684 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
+ null sort order: aaaa
sort order: ++++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Statistics: Num rows: 348 Data size: 9684 Basic stats: COMPLETE Column stats: NONE
@@ -6813,6 +6815,7 @@ STAGE PLANS:
Statistics: Num rows: 55 Data size: 1862 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 55 Data size: 1862 Basic stats: COMPLETE Column stats: NONE
@@ -8014,6 +8017,7 @@ STAGE PLANS:
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
@@ -8090,6 +8094,7 @@ STAGE PLANS:
Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE Column stats: NONE
@@ -8166,6 +8171,7 @@ STAGE PLANS:
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
@@ -8241,6 +8247,7 @@ STAGE PLANS:
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
@@ -8311,6 +8318,7 @@ STAGE PLANS:
Statistics: Num rows: 154 Data size: 738 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 154 Data size: 738 Basic stats: COMPLETE Column stats: NONE
@@ -8331,6 +8339,7 @@ STAGE PLANS:
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
@@ -8351,6 +8360,7 @@ STAGE PLANS:
Statistics: Num rows: 154 Data size: 738 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 154 Data size: 738 Basic stats: COMPLETE Column stats: NONE
@@ -8625,6 +8635,7 @@ STAGE PLANS:
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
@@ -8700,6 +8711,7 @@ STAGE PLANS:
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
@@ -8792,6 +8804,7 @@ STAGE PLANS:
Statistics: Num rows: 216 Data size: 1037 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 216 Data size: 1037 Basic stats: COMPLETE Column stats: NONE
@@ -8862,6 +8875,7 @@ STAGE PLANS:
Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE Column stats: NONE
@@ -8932,6 +8946,7 @@ STAGE PLANS:
Statistics: Num rows: 216 Data size: 1037 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 216 Data size: 1037 Basic stats: COMPLETE Column stats: NONE
@@ -9203,6 +9218,7 @@ STAGE PLANS:
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
@@ -9278,6 +9294,7 @@ STAGE PLANS:
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 206 Data size: 988 Basic stats: COMPLETE Column stats: NONE
@@ -9367,6 +9384,7 @@ STAGE PLANS:
Statistics: Num rows: 113 Data size: 543 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 113 Data size: 543 Basic stats: COMPLETE Column stats: NONE
@@ -9438,6 +9456,7 @@ STAGE PLANS:
Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 103 Data size: 494 Basic stats: COMPLETE Column stats: NONE
@@ -9507,6 +9526,7 @@ STAGE PLANS:
Statistics: Num rows: 159 Data size: 763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 159 Data size: 763 Basic stats: COMPLETE Column stats: NONE
@@ -9558,6 +9578,7 @@ STAGE PLANS:
Statistics: Num rows: 159 Data size: 763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: bigint)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint)
Statistics: Num rows: 159 Data size: 763 Basic stats: COMPLETE Column stats: NONE