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:19 UTC
[08/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/vectorized_ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out b/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out
index 426527f..f0a4444 100644
--- a/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out
@@ -157,8 +157,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -183,8 +184,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -196,8 +198,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_FUNCTION
@@ -211,8 +214,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
unbounded
@@ -240,6 +244,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -312,13 +317,14 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -341,7 +347,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:
@@ -510,10 +516,11 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- .
- TOK_TABLE_OR_COL
- j
- p_name
+ TOK_NULLS_FIRST
+ .
+ TOK_TABLE_OR_COL
+ j
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -546,8 +553,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
deltaSz
@@ -576,6 +584,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: p_partkey (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: p_partkey (type: int)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -644,6 +653,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: p_partkey (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: p_partkey (type: int)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -712,6 +722,7 @@ STAGE PLANS:
Statistics: Num rows: 28 Data size: 17646 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 28 Data size: 17646 Basic stats: COMPLETE Column stats: NONE
@@ -734,13 +745,14 @@ 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:
Statistics: Num rows: 28 Data size: 17646 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 28 Data size: 17646 Basic stats: COMPLETE Column stats: NONE
@@ -763,7 +775,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:
@@ -883,8 +895,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -920,6 +933,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -992,7 +1006,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:
@@ -1110,8 +1124,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -1136,8 +1151,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -1149,8 +1165,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_FUNCTION
@@ -1164,8 +1181,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
unbounded
@@ -1193,6 +1211,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -1265,13 +1284,14 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -1294,7 +1314,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:
@@ -1439,8 +1459,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -1465,8 +1486,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -1478,8 +1500,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_TABLE_OR_COL
@@ -1502,8 +1525,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
deltaSz
@@ -1527,6 +1551,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -1599,13 +1624,14 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -1628,7 +1654,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:
@@ -1776,8 +1802,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -1802,8 +1829,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -1815,8 +1843,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_TABLE_OR_COL
@@ -1839,8 +1868,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
deltaSz
TOK_GROUPBY
TOK_TABLE_OR_COL
@@ -1871,6 +1901,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -1943,7 +1974,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:
@@ -1959,6 +1990,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
+ null sort order: aaa
sort order: +++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -1981,7 +2013,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:
@@ -2124,8 +2156,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_TABREF
TOK_TABNAME
part_orc
@@ -2170,6 +2203,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -2238,6 +2272,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: p_partkey (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: p_partkey (type: int)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -2309,7 +2344,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:
@@ -2320,6 +2355,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 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: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -2449,8 +2485,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
=
.
TOK_TABLE_OR_COL
@@ -2495,6 +2532,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: p_partkey (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: p_partkey (type: int)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -2558,6 +2596,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -2667,7 +2706,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:
@@ -2678,6 +2717,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 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: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -2768,11 +2808,13 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_TABSORTCOLNAMEDESC
- TOK_TABLE_OR_COL
- p_size
+ TOK_NULLS_LAST
+ TOK_TABLE_OR_COL
+ p_size
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -2797,11 +2839,13 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_TABSORTCOLNAMEDESC
- TOK_TABLE_OR_COL
- p_size
+ TOK_NULLS_LAST
+ TOK_TABLE_OR_COL
+ p_size
r
@@ -2832,7 +2876,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:
@@ -2841,6 +2885,7 @@ STAGE PLANS:
Map-side function: true
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string), p_size (type: int)
+ null sort order: aaz
sort order: ++-
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -2911,7 +2956,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:
@@ -2919,6 +2964,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int)
+ null sort order: aaz
sort order: ++-
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -2940,7 +2986,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:
@@ -3064,8 +3110,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -3090,8 +3137,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -3103,8 +3151,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_FUNCTION
@@ -3118,8 +3167,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
unbounded
@@ -3154,7 +3204,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:
@@ -3163,6 +3213,7 @@ STAGE PLANS:
Map-side function: true
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -3234,7 +3285,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:
@@ -3242,6 +3293,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -3264,7 +3316,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:
@@ -3405,8 +3457,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -3431,8 +3484,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -3444,8 +3498,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_FUNCTION
@@ -3459,8 +3514,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
unbounded
@@ -3488,6 +3544,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -3560,13 +3617,14 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -3589,7 +3647,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:
@@ -3736,11 +3794,13 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -3765,8 +3825,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -3778,8 +3839,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_FUNCTION
@@ -3793,8 +3855,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
unbounded
@@ -3823,6 +3886,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -3895,7 +3959,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, _col7: double
partition by: _col2
raw input shape:
@@ -3909,7 +3973,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:
@@ -3917,7 +3981,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:
@@ -3925,6 +3989,7 @@ STAGE PLANS:
Map-side function: true
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -3947,7 +4012,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:
@@ -3955,13 +4020,14 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -3984,7 +4050,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:
@@ -4138,8 +4204,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -4163,8 +4230,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
cd
TOK_SELEXPR
TOK_TABLE_OR_COL
@@ -4187,8 +4255,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
2
@@ -4238,6 +4307,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -4310,13 +4380,14 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -4339,7 +4410,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:
@@ -4488,8 +4559,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_TABREF
TOK_TABNAME
part_orc
@@ -4530,10 +4602,11 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- .
- TOK_TABLE_OR_COL
- abc
- p_name
+ TOK_NULLS_FIRST
+ .
+ TOK_TABLE_OR_COL
+ abc
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -4547,10 +4620,11 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- .
- TOK_TABLE_OR_COL
- abc
- p_name
+ TOK_NULLS_FIRST
+ .
+ TOK_TABLE_OR_COL
+ abc
+ p_name
dr
TOK_SELEXPR
TOK_FUNCTION
@@ -4568,10 +4642,11 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- .
- TOK_TABLE_OR_COL
- abc
- p_name
+ TOK_NULLS_FIRST
+ .
+ TOK_TABLE_OR_COL
+ abc
+ p_name
cd
TOK_SELEXPR
.
@@ -4594,10 +4669,11 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- .
- TOK_TABLE_OR_COL
- abc
- p_name
+ TOK_NULLS_FIRST
+ .
+ TOK_TABLE_OR_COL
+ abc
+ p_name
TOK_WINDOWRANGE
preceding
unbounded
@@ -4634,10 +4710,11 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- .
- TOK_TABLE_OR_COL
- abc
- p_name
+ TOK_NULLS_FIRST
+ .
+ TOK_TABLE_OR_COL
+ abc
+ p_name
deltaSz
@@ -4662,6 +4739,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -4730,6 +4808,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: p_partkey (type: int)
+ null sort order: a
sort order: +
Map-reduce partition columns: p_partkey (type: int)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -4801,7 +4880,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:
@@ -4812,6 +4891,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 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: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -4831,6 +4911,7 @@ STAGE PLANS:
Statistics: Num rows: 28 Data size: 17646 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 28 Data size: 17646 Basic stats: COMPLETE Column stats: NONE
@@ -4853,7 +4934,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:
@@ -5009,8 +5090,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -5047,6 +5129,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -5119,7 +5202,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:
@@ -5135,6 +5218,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
+ null sort order: aaa
sort order: +++
Map-reduce partition columns: _col0 (type: string), _col1 (type: string), _col2 (type: int)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -5268,8 +5352,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -5302,8 +5387,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_brand
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_brand
TOK_WINDOWRANGE
preceding
2
@@ -5340,6 +5426,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -5414,13 +5501,14 @@ 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:
Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 13 Data size: 8021 Basic stats: COMPLETE Column stats: NONE
@@ -5443,7 +5531,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:
@@ -5616,8 +5704,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_TAB
@@ -5643,8 +5732,9 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -5656,8 +5746,9 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_FUNCTION
@@ -5671,8 +5762,9 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
unbounded
@@ -5707,8 +5799,9 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_size
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_size
TOK_WINDOWVALUES
preceding
5
@@ -5725,11 +5818,13 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -5741,11 +5836,13 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_FUNCTION
@@ -5757,11 +5854,13 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
cud
TOK_SELEXPR
TOK_FUNCTION
@@ -5782,11 +5881,13 @@ TOK_QUERY
p_mfgr
TOK_SORTBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
2
@@ -5820,6 +5921,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -5892,7 +5994,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:
@@ -5963,7 +6065,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:
@@ -5980,6 +6082,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -6002,7 +6105,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:
@@ -6079,12 +6182,13 @@ 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: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -6106,12 +6210,13 @@ 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: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col5 (type: int)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -6348,8 +6453,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_PARTITIONINGSPEC
TOK_DISTRIBUTEBY
TOK_TABLE_OR_COL
@@ -6358,11 +6464,13 @@ TOK_QUERY
p_name
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_PARTITIONINGSPEC
TOK_DISTRIBUTEBY
TOK_TABLE_OR_COL
@@ -6371,11 +6479,13 @@ TOK_QUERY
p_name
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -6452,6 +6562,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -6524,14 +6635,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:
@@ -6545,7 +6656,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:
@@ -6553,7 +6664,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:
@@ -6561,6 +6672,7 @@ STAGE PLANS:
Map-side function: true
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string), _col1 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -6583,7 +6695,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:
@@ -6591,13 +6703,14 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string), _col1 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -6620,7 +6733,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:
@@ -6799,8 +6912,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_PARTITIONINGSPEC
TOK_DISTRIBUTEBY
TOK_TABLE_OR_COL
@@ -6809,19 +6923,22 @@ TOK_QUERY
p_name
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_PARTITIONINGSPEC
TOK_DISTRIBUTEBY
TOK_TABLE_OR_COL
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -6843,8 +6960,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -6856,8 +6974,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_TABLE_OR_COL
@@ -6874,8 +6993,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_WINDOWRANGE
preceding
unbounded
@@ -6905,6 +7025,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: p_mfgr (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -6977,20 +7098,21 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string), _col1 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7013,13 +7135,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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7042,13 +7165,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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7071,7 +7195,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:
@@ -7248,19 +7372,22 @@ TOK_QUERY
p_name
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_PARTITIONINGSPEC
TOK_DISTRIBUTEBY
TOK_TABLE_OR_COL
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -7282,8 +7409,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
r
TOK_SELEXPR
TOK_FUNCTION
@@ -7295,8 +7423,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
dr
TOK_SELEXPR
TOK_TABLE_OR_COL
@@ -7313,8 +7442,9 @@ TOK_QUERY
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
s1
@@ -7339,6 +7469,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string), p_name (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7411,20 +7542,21 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7447,20 +7579,21 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7483,7 +7616,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:
@@ -7660,19 +7793,22 @@ TOK_QUERY
p_name
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_PARTITIONINGSPEC
TOK_DISTRIBUTEBY
TOK_TABLE_OR_COL
p_mfgr
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_PARTITIONINGSPEC
TOK_DISTRIBUTEBY
TOK_TABLE_OR_COL
@@ -7681,11 +7817,13 @@ TOK_QUERY
p_name
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_name
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_name
TOK_INSERT
TOK_DESTINATION
TOK_DIR
@@ -7763,6 +7901,7 @@ STAGE PLANS:
GatherStats: false
Reduce Output Operator
key expressions: p_mfgr (type: string), p_name (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: p_mfgr (type: string), p_name (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7835,20 +7974,21 @@ 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:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
+ null sort order: a
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7871,7 +8011,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:
@@ -7885,7 +8025,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:
@@ -7894,6 +8034,7 @@ STAGE PLANS:
Map-side function: true
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string), _col1 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7916,7 +8057,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:
@@ -7924,6 +8065,7 @@ STAGE PLANS:
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col1 (type: string)
+ null sort order: aa
sort order: ++
Map-reduce partition columns: _col2 (type: string), _col1 (type: string)
Statistics: Num rows: 26 Data size: 16042 Basic stats: COMPLETE Column stats: NONE
@@ -7946,7 +8088,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:
@@ -8123,19 +8265,22 @@ TOK_QUERY
p_name
TOK_ORDERBY
TOK_TABSORTCOLNAMEASC
- TOK_TABLE_OR_COL
- p_mfgr
+ TOK_NULLS_FIRST
+ TOK_TABLE_OR_COL
+ p_mfgr
<TRUNCATED>