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:21 UTC
[10/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/spark/outer_join_ppr.q.java1.7.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/outer_join_ppr.q.java1.7.out b/ql/src/test/results/clientpositive/spark/outer_join_ppr.q.java1.7.out
index 4edb4a9..9b1a503 100644
--- a/ql/src/test/results/clientpositive/spark/outer_join_ppr.q.java1.7.out
+++ b/ql/src/test/results/clientpositive/spark/outer_join_ppr.q.java1.7.out
@@ -129,6 +129,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -196,6 +197,7 @@ STAGE PLANS:
Statistics: Num rows: 2000 Data size: 21248 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: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
@@ -614,6 +616,7 @@ STAGE PLANS:
Statistics: Num rows: 55 Data size: 584 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: 584 Basic stats: COMPLETE Column stats: NONE
@@ -685,6 +688,7 @@ STAGE PLANS:
Statistics: Num rows: 111 Data size: 1179 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: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
http://git-wip-us.apache.org/repos/asf/hive/blob/9350b693/ql/src/test/results/clientpositive/spark/pcr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/pcr.q.out b/ql/src/test/results/clientpositive/spark/pcr.q.out
index 681251d..3886272 100644
--- a/ql/src/test/results/clientpositive/spark/pcr.q.out
+++ b/ql/src/test/results/clientpositive/spark/pcr.q.out
@@ -85,11 +85,13 @@ TOK_QUERY
5
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
STAGE DEPENDENCIES:
@@ -119,6 +121,7 @@ STAGE PLANS:
Statistics: Num rows: 13 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col2 (type: string)
+ null sort order: aa
sort order: ++
Statistics: Num rows: 13 Data size: 104 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -312,8 +315,9 @@ TOK_QUERY
5
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
STAGE DEPENDENCIES:
@@ -343,6 +347,7 @@ STAGE PLANS:
Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
+ null sort order: a
sort order: +
Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -627,11 +632,13 @@ TOK_QUERY
'val_2'
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
STAGE DEPENDENCIES:
@@ -661,6 +668,7 @@ STAGE PLANS:
Statistics: Num rows: 13 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col2 (type: string)
+ null sort order: aa
sort order: ++
Statistics: Num rows: 13 Data size: 104 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -869,11 +877,13 @@ TOK_QUERY
'val_5'
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
STAGE DEPENDENCIES:
@@ -903,6 +913,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 80 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col2 (type: string)
+ null sort order: aa
sort order: ++
Statistics: Num rows: 10 Data size: 80 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -1113,11 +1124,13 @@ TOK_QUERY
'val_5'
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
STAGE DEPENDENCIES:
@@ -1147,6 +1160,7 @@ STAGE PLANS:
Statistics: Num rows: 16 Data size: 128 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col2 (type: string)
+ null sort order: aa
sort order: ++
Statistics: Num rows: 16 Data size: 128 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -1413,11 +1427,13 @@ TOK_QUERY
'val_5'
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
STAGE DEPENDENCIES:
@@ -1447,6 +1463,7 @@ STAGE PLANS:
Statistics: Num rows: 33 Data size: 264 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col2 (type: string)
+ null sort order: aa
sort order: ++
Statistics: Num rows: 33 Data size: 264 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -1713,11 +1730,13 @@ TOK_QUERY
14
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- value
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ value
STAGE DEPENDENCIES:
@@ -1747,6 +1766,7 @@ STAGE PLANS:
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: 14 (type: int), _col1 (type: string)
+ null sort order: aa
sort order: ++
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -1929,11 +1949,13 @@ TOK_QUERY
'2000-04-09'
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- value
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ value
STAGE DEPENDENCIES:
@@ -1959,6 +1981,7 @@ STAGE PLANS:
Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
+ null sort order: aa
sort order: ++
Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -2181,11 +2204,13 @@ TOK_QUERY
'2000-04-10'
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- value
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ value
STAGE DEPENDENCIES:
@@ -2211,6 +2236,7 @@ STAGE PLANS:
Statistics: Num rows: 60 Data size: 480 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string)
+ null sort order: aa
sort order: ++
Statistics: Num rows: 60 Data size: 480 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -2514,14 +2540,17 @@ TOK_QUERY
2
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- value
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ value
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
STAGE DEPENDENCIES:
@@ -2551,6 +2580,7 @@ STAGE PLANS:
Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string)
+ null sort order: aaa
sort order: +++
Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -2749,10 +2779,11 @@ TOK_QUERY
TOK_ALLCOLREF
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- .
- TOK_TABLE_OR_COL
- t1
- key
+ TOK_NULLS_FIRST
+ .
+ TOK_TABLE_OR_COL
+ t1
+ key
STAGE DEPENDENCIES:
@@ -2783,6 +2814,7 @@ STAGE PLANS:
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
@@ -2855,6 +2887,7 @@ STAGE PLANS:
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
@@ -2924,6 +2957,7 @@ STAGE PLANS:
Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
+ null sort order: a
sort order: +
Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -3062,10 +3096,11 @@ TOK_QUERY
TOK_ALLCOLREF
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- .
- TOK_TABLE_OR_COL
- t1
- key
+ TOK_NULLS_FIRST
+ .
+ TOK_TABLE_OR_COL
+ t1
+ key
STAGE DEPENDENCIES:
@@ -3096,6 +3131,7 @@ STAGE PLANS:
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
@@ -3168,6 +3204,7 @@ STAGE PLANS:
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 20 Data size: 160 Basic stats: COMPLETE Column stats: NONE
@@ -3237,6 +3274,7 @@ STAGE PLANS:
Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
+ null sort order: a
sort order: +
Statistics: Num rows: 22 Data size: 176 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -3390,14 +3428,17 @@ TOK_QUERY
2
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- value
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ value
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
STAGE DEPENDENCIES:
@@ -3427,6 +3468,7 @@ STAGE PLANS:
Statistics: Num rows: 48 Data size: 384 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string)
+ null sort order: aaa
sort order: +++
Statistics: Num rows: 48 Data size: 384 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -3760,14 +3802,17 @@ TOK_QUERY
2
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- value
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ value
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
STAGE DEPENDENCIES:
@@ -3797,6 +3842,7 @@ STAGE PLANS:
Statistics: Num rows: 30 Data size: 240 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string)
+ null sort order: aaa
sort order: +++
Statistics: Num rows: 30 Data size: 240 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -4630,8 +4676,9 @@ TOK_QUERY
11
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_LIMIT
10
@@ -4659,6 +4706,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
+ null sort order: a
sort order: +
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -4814,14 +4862,17 @@ TOK_QUERY
11
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- hr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ hr
STAGE DEPENDENCIES:
@@ -4851,6 +4902,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: '11' (type: string), '2008-04-08' (type: string), _col3 (type: string)
+ null sort order: aaa
sort order: +++
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
tag: -1
@@ -5044,14 +5096,17 @@ TOK_QUERY
11
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- key
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ key
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- ds
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ ds
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- hr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ hr
STAGE DEPENDENCIES:
@@ -5081,6 +5136,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: '11' (type: string), _col2 (type: string), '11' (type: string)
+ null sort order: aaa
sort order: +++
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
tag: -1
http://git-wip-us.apache.org/repos/asf/hive/blob/9350b693/ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out b/ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out
index e87ded7..9f94f16 100644
--- a/ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out
+++ b/ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out
@@ -147,6 +147,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -219,6 +220,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -330,6 +332,7 @@ STAGE PLANS:
Statistics: Num rows: 83 Data size: 881 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: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
@@ -526,6 +529,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -598,6 +602,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -709,6 +714,7 @@ STAGE PLANS:
Statistics: Num rows: 83 Data size: 881 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: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
@@ -905,6 +911,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -977,6 +984,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1088,6 +1096,7 @@ STAGE PLANS:
Statistics: Num rows: 83 Data size: 881 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: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
@@ -1284,6 +1293,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1356,6 +1366,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -1467,6 +1478,7 @@ STAGE PLANS:
Statistics: Num rows: 83 Data size: 881 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: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE
http://git-wip-us.apache.org/repos/asf/hive/blob/9350b693/ql/src/test/results/clientpositive/spark/ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/ptf.q.out b/ql/src/test/results/clientpositive/spark/ptf.q.out
index a826bc3..0640ca3 100644
--- a/ql/src/test/results/clientpositive/spark/ptf.q.out
+++ b/ql/src/test/results/clientpositive/spark/ptf.q.out
@@ -62,7 +62,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -88,7 +88,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -266,7 +266,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -292,7 +292,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -417,7 +417,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -540,7 +540,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -566,7 +566,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -717,7 +717,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -743,7 +743,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -897,7 +897,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -932,7 +932,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col0
raw input shape:
window functions:
@@ -1092,7 +1092,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col0: int, _col1: string, _col2: string, _col3: string, _col4: string, _col5: int, _col6: string, _col7: double, _col8: string
partition by: _col2
raw input shape:
@@ -1262,7 +1262,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col0: int, _col1: string, _col2: string, _col3: string, _col4: string, _col5: int, _col6: string, _col7: double, _col8: string
partition by: _col2
raw input shape:
@@ -1369,7 +1369,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: p_name, p_size(DESC)
+ order by: p_name ASC NULLS FIRST, p_size DESC NULLS LAST
output shape: p_name: string, p_mfgr: string, p_size: int
partition by: p_mfgr
raw input shape:
@@ -1396,7 +1396,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col1, _col5(DESC)
+ order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -1422,7 +1422,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1, _col5(DESC)
+ order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -1540,7 +1540,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: p_name
+ order by: p_name ASC NULLS FIRST
output shape: p_name: string, p_mfgr: string, p_size: int, p_retailprice: double
partition by: p_mfgr
raw input shape:
@@ -1568,7 +1568,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1595,7 +1595,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -1742,7 +1742,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1768,7 +1768,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -1918,7 +1918,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2(DESC), _col1
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1932,7 +1932,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2(DESC), _col1
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1940,7 +1940,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2(DESC), _col1
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1967,7 +1967,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2(DESC), _col1
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1975,7 +1975,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2(DESC), _col1
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -2001,7 +2001,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -2158,7 +2158,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -2184,7 +2184,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -2351,7 +2351,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col0: int, _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -2396,7 +2396,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -2558,7 +2558,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -2723,7 +2723,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col0
+ order by: _col0 ASC NULLS FIRST
output shape: _col0: string, _col1: string, _col2: double
partition by: _col0
raw input shape:
@@ -2749,7 +2749,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col0
raw input shape:
window functions:
@@ -2936,7 +2936,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -2988,7 +2988,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col5
+ order by: _col5 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -3024,7 +3024,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col3, _col2
+ order by: _col3 ASC NULLS FIRST, _col2 ASC NULLS FIRST
partition by: _col3
raw input shape:
window functions:
@@ -3082,7 +3082,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
@@ -3106,7 +3106,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
@@ -3336,14 +3336,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -3357,7 +3357,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3365,7 +3365,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3392,7 +3392,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3400,7 +3400,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3426,7 +3426,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
partition by: _col2, _col1
raw input shape:
window functions:
@@ -3607,14 +3607,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -3640,7 +3640,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3666,7 +3666,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -3692,7 +3692,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -3868,14 +3868,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3901,14 +3901,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -3934,7 +3934,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -4111,14 +4111,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4144,7 +4144,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4158,7 +4158,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4186,7 +4186,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4213,7 +4213,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
partition by: _col2, _col1
raw input shape:
window functions:
@@ -4391,7 +4391,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4405,7 +4405,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4413,7 +4413,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4440,7 +4440,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4448,7 +4448,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4474,7 +4474,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
partition by: _col2, _col1
raw input shape:
window functions:
@@ -4646,14 +4646,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4667,7 +4667,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4695,7 +4695,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4722,7 +4722,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
http://git-wip-us.apache.org/repos/asf/hive/blob/9350b693/ql/src/test/results/clientpositive/spark/ptf_matchpath.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/ptf_matchpath.q.out b/ql/src/test/results/clientpositive/spark/ptf_matchpath.q.out
index fc35091..1098240 100644
--- a/ql/src/test/results/clientpositive/spark/ptf_matchpath.q.out
+++ b/ql/src/test/results/clientpositive/spark/ptf_matchpath.q.out
@@ -100,7 +100,7 @@ STAGE PLANS:
input alias: ptf_1
arguments: 'LATE.LATE+', 'LATE', (_col5 > 15.0), 'origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath'
name: matchpath
- order by: _col2, _col3, _col4
+ order by: _col2 ASC NULLS FIRST, _col3 ASC NULLS FIRST, _col4 ASC NULLS FIRST
output shape: tpath: int
partition by: _col6
raw input shape:
@@ -226,7 +226,7 @@ STAGE PLANS:
input alias: ptf_1
arguments: 'LATE.LATE+', 'LATE', (_col5 > 15.0), 'origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath'
name: matchpath
- order by: _col6, _col2, _col3, _col4
+ order by: _col6 ASC NULLS FIRST, _col2 ASC NULLS FIRST, _col3 ASC NULLS FIRST, _col4 ASC NULLS FIRST
output shape: tpath: int
partition by: 0
raw input shape:
@@ -349,7 +349,7 @@ STAGE PLANS:
input alias: ptf_1
arguments: 'LATE.LATE+', 'LATE', (_col5 > 15.0), 'origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath'
name: matchpath
- order by: _col6, _col2, _col3, _col4
+ order by: _col6 ASC NULLS FIRST, _col2 ASC NULLS FIRST, _col3 ASC NULLS FIRST, _col4 ASC NULLS FIRST
output shape: tpath: int
partition by: 0
raw input shape:
http://git-wip-us.apache.org/repos/asf/hive/blob/9350b693/ql/src/test/results/clientpositive/spark/ptf_streaming.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/ptf_streaming.q.out b/ql/src/test/results/clientpositive/spark/ptf_streaming.q.out
index ecaa779..8e47b11 100644
--- a/ql/src/test/results/clientpositive/spark/ptf_streaming.q.out
+++ b/ql/src/test/results/clientpositive/spark/ptf_streaming.q.out
@@ -62,7 +62,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -88,7 +88,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -266,7 +266,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -292,7 +292,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -433,7 +433,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noopstreaming
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col0: int, _col1: string, _col2: string, _col3: string, _col4: string, _col5: int, _col6: string, _col7: double, _col8: string
partition by: _col2
raw input shape:
@@ -557,7 +557,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: p_name, p_size(DESC)
+ order by: p_name ASC NULLS FIRST, p_size DESC NULLS LAST
output shape: p_name: string, p_mfgr: string, p_size: int
partition by: p_mfgr
raw input shape:
@@ -584,7 +584,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col1, _col5(DESC)
+ order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -610,7 +610,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1, _col5(DESC)
+ order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -728,7 +728,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: p_name
+ order by: p_name ASC NULLS FIRST
output shape: p_name: string, p_mfgr: string, p_size: int, p_retailprice: double
partition by: p_mfgr
raw input shape:
@@ -756,7 +756,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -783,7 +783,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -933,7 +933,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -947,7 +947,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -955,7 +955,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -982,7 +982,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -990,7 +990,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1016,7 +1016,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -1168,7 +1168,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1182,7 +1182,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1190,7 +1190,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1217,7 +1217,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1225,7 +1225,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1251,7 +1251,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -1403,7 +1403,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1417,7 +1417,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1425,7 +1425,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1452,7 +1452,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1460,7 +1460,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1486,7 +1486,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -1655,7 +1655,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noopstreaming
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
output shape: _col0: int, _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1700,7 +1700,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -1885,14 +1885,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -1906,7 +1906,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -1914,7 +1914,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -1941,7 +1941,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -1949,7 +1949,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -1975,7 +1975,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
partition by: _col2, _col1
raw input shape:
window functions:
@@ -2156,14 +2156,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -2189,7 +2189,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2215,7 +2215,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2
+ order by: _col2 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -2241,7 +2241,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
@@ -2415,14 +2415,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2436,7 +2436,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2464,7 +2464,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2, _col1
+ order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2491,7 +2491,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1
+ order by: _col1 ASC NULLS FIRST
partition by: _col2
raw input shape:
window functions:
http://git-wip-us.apache.org/repos/asf/hive/blob/9350b693/ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out b/ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out
index b38a96b..83988d3 100644
--- a/ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out
+++ b/ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out
@@ -58,6 +58,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -421,6 +422,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE