http://git-wip-us.apache.org/repos/asf/hive/blob/9350b693/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out b/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out index 431e334..3d1f22f 100644 --- a/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out +++ b/ql/src/test/results/clientpositive/tez/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 @@ -241,6 +245,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 @@ -313,13 +318,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 @@ -342,7 +348,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: @@ -511,10 +517,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 @@ -547,8 +554,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 @@ -578,6 +586,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 @@ -646,6 +655,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 @@ -715,6 +725,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 @@ -737,13 +748,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 @@ -766,7 +778,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: @@ -886,8 +898,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 @@ -924,6 +937,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 @@ -996,7 +1010,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: @@ -1114,8 +1128,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 @@ -1140,8 +1155,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 @@ -1153,8 +1169,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 @@ -1168,8 +1185,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 @@ -1198,6 +1216,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 @@ -1270,13 +1289,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 @@ -1299,7 +1319,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: @@ -1444,8 +1464,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 @@ -1470,8 +1491,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 @@ -1483,8 +1505,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 @@ -1507,8 +1530,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 @@ -1533,6 +1557,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 @@ -1605,13 +1630,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 @@ -1634,7 +1660,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: @@ -1782,8 +1808,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 @@ -1808,8 +1835,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 @@ -1821,8 +1849,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 @@ -1845,8 +1874,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 @@ -1878,6 +1908,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 @@ -1950,7 +1981,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: @@ -1966,6 +1997,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 @@ -1988,7 +2020,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: @@ -2131,8 +2163,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 @@ -2178,6 +2211,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 @@ -2246,6 +2280,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 @@ -2317,7 +2352,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: @@ -2328,6 +2363,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 @@ -2458,8 +2494,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 @@ -2505,6 +2542,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 @@ -2568,6 +2606,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 @@ -2678,7 +2717,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: @@ -2689,6 +2728,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 @@ -2779,11 +2819,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 @@ -2808,11 +2850,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 @@ -2844,7 +2888,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: @@ -2853,6 +2897,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 @@ -2923,7 +2968,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: @@ -2931,6 +2976,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 @@ -2952,7 +2998,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: @@ -3076,8 +3122,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 @@ -3102,8 +3149,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 @@ -3115,8 +3163,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 @@ -3130,8 +3179,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 @@ -3167,7 +3217,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: @@ -3176,6 +3226,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 @@ -3247,7 +3298,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: @@ -3255,6 +3306,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 @@ -3277,7 +3329,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: @@ -3418,8 +3470,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 @@ -3444,8 +3497,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 @@ -3457,8 +3511,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 @@ -3472,8 +3527,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 @@ -3502,6 +3558,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 @@ -3574,13 +3631,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 @@ -3603,7 +3661,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: @@ -3750,11 +3808,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 @@ -3779,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 r TOK_SELEXPR TOK_FUNCTION @@ -3792,8 +3853,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 @@ -3807,8 +3869,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 @@ -3838,6 +3901,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 @@ -3910,7 +3974,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: @@ -3924,7 +3988,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: @@ -3932,7 +3996,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: @@ -3940,6 +4004,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 @@ -3962,7 +4027,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: @@ -3970,13 +4035,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 @@ -3999,7 +4065,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: @@ -4153,8 +4219,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 @@ -4178,8 +4245,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 @@ -4202,8 +4270,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 @@ -4254,6 +4323,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 @@ -4326,13 +4396,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 @@ -4355,7 +4426,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: @@ -4504,8 +4575,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 @@ -4546,10 +4618,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 @@ -4563,10 +4636,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 @@ -4584,10 +4658,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 . @@ -4610,10 +4685,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 @@ -4650,10 +4726,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 @@ -4679,6 +4756,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 @@ -4747,6 +4825,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 @@ -4818,7 +4897,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: @@ -4829,6 +4908,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 @@ -4849,6 +4929,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 @@ -4871,7 +4952,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: @@ -5027,8 +5108,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 @@ -5066,6 +5148,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 @@ -5138,7 +5221,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: @@ -5154,6 +5237,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 @@ -5287,8 +5371,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 @@ -5321,8 +5406,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 @@ -5360,6 +5446,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 @@ -5434,13 +5521,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 @@ -5463,7 +5551,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: @@ -5636,8 +5724,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 @@ -5663,8 +5752,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 @@ -5676,8 +5766,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 @@ -5691,8 +5782,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 @@ -5727,8 +5819,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 @@ -5745,11 +5838,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 @@ -5761,11 +5856,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 @@ -5777,11 +5874,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 @@ -5802,11 +5901,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 @@ -5841,6 +5942,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 @@ -5913,13 +6015,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 @@ -5928,6 +6031,7 @@ STAGE PLANS: auto parallelism: true 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 @@ -5950,7 +6054,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: @@ -6021,7 +6125,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: @@ -6038,6 +6142,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 @@ -6060,7 +6165,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: @@ -6355,8 +6460,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 @@ -6365,11 +6471,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 @@ -6378,11 +6486,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 @@ -6460,6 +6570,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 @@ -6532,14 +6643,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: @@ -6553,7 +6664,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: @@ -6561,7 +6672,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: @@ -6569,6 +6680,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 @@ -6591,7 +6703,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: @@ -6599,13 +6711,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 @@ -6628,7 +6741,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: @@ -6807,8 +6920,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 @@ -6817,19 +6931,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 @@ -6851,8 +6968,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 @@ -6864,8 +6982,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 @@ -6882,8 +7001,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 @@ -6914,6 +7034,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 @@ -6986,20 +7107,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 @@ -7022,13 +7144,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 @@ -7051,13 +7174,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 @@ -7080,7 +7204,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: @@ -7257,19 +7381,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 @@ -7291,8 +7418,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 @@ -7304,8 +7432,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 @@ -7322,8 +7451,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 @@ -7349,6 +7479,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 @@ -7421,20 +7552,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 @@ -7457,20 +7589,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 @@ -7493,7 +7626,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: @@ -7670,19 +7803,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 @@ -7691,11 +7827,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 @@ -7774,6 +7912,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 @@ -7846,20 +7985,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 @@ -7882,7 +8022,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: @@ -7896,7 +8036,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: @@ -7905,6 +8045,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 @@ -7927,7 +8068,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: @@ -7935,6 +8076,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 @@ -7957,7 +8099,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: @@ -8134,19 +8276,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
<TRUNCATED>
