You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by tc...@apache.org on 2018/09/14 02:49:22 UTC
[18/20] hive git commit: HIVE-20423: Set NULLS LAST as the default
null ordering (Teddy Choi, reviewed by Jesus Camacho Rodriguez)
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out b/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out
index b8ea5cf..42c2f5b 100644
--- a/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_ppd_basic.q.out
@@ -207,7 +207,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n2
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 16675
+ HDFS_BYTES_READ: 16681
HDFS_BYTES_WRITTEN: 104
HDFS_READ_OPS: 7
HDFS_LARGE_READ_OPS: 0
@@ -267,7 +267,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n2
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 1055
+ HDFS_BYTES_READ: 1047
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -288,9 +288,9 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 1048576
- ALLOCATED_USED_BYTES: 2732
+ ALLOCATED_USED_BYTES: 2731
CACHE_HIT_BYTES: 24
- CACHE_MISS_BYTES: 1055
+ CACHE_MISS_BYTES: 1047
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
NUM_VECTOR_BATCHES: 1
@@ -327,7 +327,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 22
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -365,7 +365,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 16
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -403,7 +403,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 2
@@ -441,7 +441,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 1
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -479,7 +479,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 32
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -517,7 +517,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 32
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -555,7 +555,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 1697
RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 2
@@ -593,7 +593,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 12
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -631,7 +631,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 1713
RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 2
@@ -657,7 +657,7 @@ Stage-1 FILE SYSTEM COUNTERS:
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 1000
+ RECORDS_IN_Map_1: 100
RECORDS_OUT_0: 1
RECORDS_OUT_INTERMEDIATE_Map_1: 6
RECORDS_OUT_INTERMEDIATE_Reducer_2: 0
@@ -667,14 +667,14 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_MAP_0: 0
RECORDS_OUT_OPERATOR_RS_3: 6
RECORDS_OUT_OPERATOR_SEL_2: 6
- RECORDS_OUT_OPERATOR_TS_0: 1000
+ RECORDS_OUT_OPERATOR_TS_0: 100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
NUM_VECTOR_BATCHES: 1
- ROWS_EMITTED: 1000
+ ROWS_EMITTED: 100
SELECTED_ROWGROUPS: 1
Stage-1 INPUT COUNTERS:
GROUPED_INPUT_SPLITS_Map_1: 1
@@ -707,7 +707,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 50
RECORDS_OUT_OPERATOR_TS_0: 1100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 2
@@ -745,7 +745,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 318
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -827,7 +827,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 0
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 830
+ CACHE_HIT_BYTES: 823
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
SELECTED_ROWGROUPS: 0
@@ -862,7 +862,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 0
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 830
+ CACHE_HIT_BYTES: 823
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
SELECTED_ROWGROUPS: 0
@@ -920,7 +920,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 1310720
- ALLOCATED_USED_BYTES: 13810
+ ALLOCATED_USED_BYTES: 13812
CACHE_HIT_BYTES: 24
CACHE_MISS_BYTES: 5911
METADATA_CACHE_HIT: 2
@@ -1095,7 +1095,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 0
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1726
+ CACHE_HIT_BYTES: 1728
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
SELECTED_ROWGROUPS: 0
@@ -1232,7 +1232,7 @@ Stage-1 FILE SYSTEM COUNTERS:
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 2100
+ RECORDS_IN_Map_1: 2000
RECORDS_OUT_0: 1
RECORDS_OUT_INTERMEDIATE_Map_1: 81
RECORDS_OUT_INTERMEDIATE_Reducer_2: 0
@@ -1242,15 +1242,15 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_MAP_0: 0
RECORDS_OUT_OPERATOR_RS_3: 81
RECORDS_OUT_OPERATOR_SEL_2: 81
- RECORDS_OUT_OPERATOR_TS_0: 2100
+ RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
CACHE_HIT_BYTES: 5935
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
- NUM_DECODED_BATCHES: 3
- NUM_VECTOR_BATCHES: 3
- ROWS_EMITTED: 2100
- SELECTED_ROWGROUPS: 3
+ NUM_DECODED_BATCHES: 2
+ NUM_VECTOR_BATCHES: 2
+ ROWS_EMITTED: 2000
+ SELECTED_ROWGROUPS: 2
Stage-1 INPUT COUNTERS:
GROUPED_INPUT_SPLITS_Map_1: 1
INPUT_DIRECTORIES_Map_1: 1
@@ -1270,7 +1270,7 @@ Stage-1 FILE SYSTEM COUNTERS:
Stage-1 HIVE COUNTERS:
CREATED_FILES: 1
DESERIALIZE_ERRORS: 0
- RECORDS_IN_Map_1: 2100
+ RECORDS_IN_Map_1: 2000
RECORDS_OUT_0: 1
RECORDS_OUT_INTERMEDIATE_Map_1: 74
RECORDS_OUT_INTERMEDIATE_Reducer_2: 0
@@ -1280,15 +1280,15 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_MAP_0: 0
RECORDS_OUT_OPERATOR_RS_3: 74
RECORDS_OUT_OPERATOR_SEL_2: 74
- RECORDS_OUT_OPERATOR_TS_0: 2100
+ RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
CACHE_HIT_BYTES: 5935
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
- NUM_DECODED_BATCHES: 3
- NUM_VECTOR_BATCHES: 3
- ROWS_EMITTED: 2100
- SELECTED_ROWGROUPS: 3
+ NUM_DECODED_BATCHES: 2
+ NUM_VECTOR_BATCHES: 2
+ ROWS_EMITTED: 2000
+ SELECTED_ROWGROUPS: 2
Stage-1 INPUT COUNTERS:
GROUPED_INPUT_SPLITS_Map_1: 1
INPUT_DIRECTORIES_Map_1: 1
@@ -1472,7 +1472,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 0
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1726
+ CACHE_HIT_BYTES: 1728
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
SELECTED_ROWGROUPS: 0
@@ -1507,7 +1507,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 0
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1726
+ CACHE_HIT_BYTES: 1728
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
SELECTED_ROWGROUPS: 0
@@ -1542,7 +1542,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 0
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1726
+ CACHE_HIT_BYTES: 1728
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
SELECTED_ROWGROUPS: 0
@@ -1653,7 +1653,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 2
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 6990
+ CACHE_HIT_BYTES: 6982
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -1691,7 +1691,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 2
RECORDS_OUT_OPERATOR_TS_0: 100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 6990
+ CACHE_HIT_BYTES: 6982
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -1709,7 +1709,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n2
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 4896
+ HDFS_BYTES_READ: 4892
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 4
HDFS_LARGE_READ_OPS: 0
@@ -1732,7 +1732,7 @@ Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 524288
ALLOCATED_USED_BYTES: 8527
CACHE_HIT_BYTES: 24
- CACHE_MISS_BYTES: 4896
+ CACHE_MISS_BYTES: 4892
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
NUM_VECTOR_BATCHES: 3
@@ -1749,7 +1749,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n2
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 1750
+ HDFS_BYTES_READ: 1759
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 4
HDFS_LARGE_READ_OPS: 0
@@ -1771,8 +1771,8 @@ Stage-1 HIVE COUNTERS:
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 262144
ALLOCATED_USED_BYTES: 2376
- CACHE_HIT_BYTES: 4920
- CACHE_MISS_BYTES: 1750
+ CACHE_HIT_BYTES: 4916
+ CACHE_MISS_BYTES: 1759
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
NUM_VECTOR_BATCHES: 1
@@ -1809,7 +1809,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 2
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 4920
+ CACHE_HIT_BYTES: 4916
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -1847,7 +1847,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 2
RECORDS_OUT_OPERATOR_TS_0: 100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 6670
+ CACHE_HIT_BYTES: 6675
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -1866,7 +1866,7 @@ PREHOOK: Input: default@orc_ppd_staging_n1
PREHOOK: Output: database:default
PREHOOK: Output: default@orc_ppd_1
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 10569
+ HDFS_BYTES_READ: 10583
HDFS_BYTES_WRITTEN: 1467
HDFS_READ_OPS: 6
HDFS_LARGE_READ_OPS: 0
@@ -1886,8 +1886,8 @@ Stage-1 HIVE COUNTERS:
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 2359296
ALLOCATED_USED_BYTES: 44198
- CACHE_HIT_BYTES: 30613
- CACHE_MISS_BYTES: 10569
+ CACHE_HIT_BYTES: 30620
+ CACHE_MISS_BYTES: 10583
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
NUM_VECTOR_BATCHES: 1
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/llap/orc_ppd_schema_evol_3a.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/orc_ppd_schema_evol_3a.q.out b/ql/src/test/results/clientpositive/llap/orc_ppd_schema_evol_3a.q.out
index e197126..8a6a004 100644
--- a/ql/src/test/results/clientpositive/llap/orc_ppd_schema_evol_3a.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_ppd_schema_evol_3a.q.out
@@ -207,7 +207,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 17010
+ HDFS_BYTES_READ: 17011
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 7
HDFS_LARGE_READ_OPS: 0
@@ -228,9 +228,9 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 1048576
- ALLOCATED_USED_BYTES: 382
+ ALLOCATED_USED_BYTES: 381
CACHE_HIT_BYTES: 0
- CACHE_MISS_BYTES: 359
+ CACHE_MISS_BYTES: 354
METADATA_CACHE_MISS: 2
NUM_DECODED_BATCHES: 3
NUM_VECTOR_BATCHES: 3
@@ -289,7 +289,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 8
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -307,7 +307,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 720
+ HDFS_BYTES_READ: 717
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 4
HDFS_LARGE_READ_OPS: 0
@@ -329,8 +329,8 @@ Stage-1 HIVE COUNTERS:
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 262144
ALLOCATED_USED_BYTES: 2376
- CACHE_HIT_BYTES: 359
- CACHE_MISS_BYTES: 720
+ CACHE_HIT_BYTES: 354
+ CACHE_MISS_BYTES: 717
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
NUM_VECTOR_BATCHES: 1
@@ -367,7 +367,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -405,7 +405,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 2
@@ -447,7 +447,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -507,7 +507,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 8
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -545,7 +545,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 8
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -583,7 +583,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -621,7 +621,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 2
@@ -663,7 +663,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -723,7 +723,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 8
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -761,7 +761,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 8
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -799,7 +799,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -837,7 +837,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 2
@@ -879,7 +879,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 0
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -939,7 +939,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 8
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -977,7 +977,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 8
RECORDS_OUT_OPERATOR_TS_0: 1000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
@@ -1015,7 +1015,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 359
+ CACHE_HIT_BYTES: 354
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -1053,7 +1053,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 18
RECORDS_OUT_OPERATOR_TS_0: 2000
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 1079
+ CACHE_HIT_BYTES: 1071
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 2
@@ -1075,7 +1075,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 16900
+ HDFS_BYTES_READ: 16905
HDFS_BYTES_WRITTEN: 104
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1107,7 +1107,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 17730
+ HDFS_BYTES_READ: 17728
HDFS_BYTES_WRITTEN: 104
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1139,7 +1139,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 16900
+ HDFS_BYTES_READ: 16905
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1171,7 +1171,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 17730
+ HDFS_BYTES_READ: 17728
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1203,7 +1203,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 16900
+ HDFS_BYTES_READ: 16905
HDFS_BYTES_WRITTEN: 102
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1235,7 +1235,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 17730
+ HDFS_BYTES_READ: 17728
HDFS_BYTES_WRITTEN: 102
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1267,7 +1267,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 4896
+ HDFS_BYTES_READ: 4892
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 4
HDFS_LARGE_READ_OPS: 0
@@ -1290,7 +1290,7 @@ Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 524288
ALLOCATED_USED_BYTES: 8527
CACHE_HIT_BYTES: 24
- CACHE_MISS_BYTES: 4896
+ CACHE_MISS_BYTES: 4892
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
NUM_VECTOR_BATCHES: 3
@@ -1307,7 +1307,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 1750
+ HDFS_BYTES_READ: 1759
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 4
HDFS_LARGE_READ_OPS: 0
@@ -1329,8 +1329,8 @@ Stage-1 HIVE COUNTERS:
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 262144
ALLOCATED_USED_BYTES: 2376
- CACHE_HIT_BYTES: 4920
- CACHE_MISS_BYTES: 1750
+ CACHE_HIT_BYTES: 4916
+ CACHE_MISS_BYTES: 1759
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 1
NUM_VECTOR_BATCHES: 1
@@ -1351,7 +1351,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 21443
+ HDFS_BYTES_READ: 21446
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1383,7 +1383,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 23321
+ HDFS_BYTES_READ: 23332
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1419,7 +1419,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 21443
+ HDFS_BYTES_READ: 21446
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1451,7 +1451,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 23321
+ HDFS_BYTES_READ: 23332
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1483,7 +1483,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 4322
+ HDFS_BYTES_READ: 4326
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 4
HDFS_LARGE_READ_OPS: 0
@@ -1504,9 +1504,9 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 1048576
- ALLOCATED_USED_BYTES: 11434
+ ALLOCATED_USED_BYTES: 11436
CACHE_HIT_BYTES: 24
- CACHE_MISS_BYTES: 4322
+ CACHE_MISS_BYTES: 4326
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
NUM_VECTOR_BATCHES: 3
@@ -1523,7 +1523,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 1589
+ HDFS_BYTES_READ: 1585
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 4
HDFS_LARGE_READ_OPS: 0
@@ -1545,8 +1545,8 @@ Stage-1 HIVE COUNTERS:
Stage-1 LLAP IO COUNTERS:
ALLOCATED_BYTES: 262144
ALLOCATED_USED_BYTES: 2376
- CACHE_HIT_BYTES: 4346
- CACHE_MISS_BYTES: 1589
+ CACHE_HIT_BYTES: 4350
+ CACHE_MISS_BYTES: 1585
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
NUM_VECTOR_BATCHES: 3
@@ -1567,7 +1567,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 20860
+ HDFS_BYTES_READ: 20864
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1599,7 +1599,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 22586
+ HDFS_BYTES_READ: 22592
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1635,7 +1635,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 20860
+ HDFS_BYTES_READ: 20864
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1667,7 +1667,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 22586
+ HDFS_BYTES_READ: 22592
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1703,7 +1703,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 20860
+ HDFS_BYTES_READ: 20864
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1735,7 +1735,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 22586
+ HDFS_BYTES_READ: 22592
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1791,7 +1791,7 @@ Stage-1 HIVE COUNTERS:
RECORDS_OUT_OPERATOR_SEL_2: 6
RECORDS_OUT_OPERATOR_TS_0: 2100
Stage-1 LLAP IO COUNTERS:
- CACHE_HIT_BYTES: 4346
+ CACHE_HIT_BYTES: 4350
CACHE_MISS_BYTES: 0
METADATA_CACHE_HIT: 2
NUM_DECODED_BATCHES: 3
@@ -1851,7 +1851,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 18628
+ HDFS_BYTES_READ: 18631
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1883,7 +1883,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 18628
+ HDFS_BYTES_READ: 18631
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1915,7 +1915,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 19952
+ HDFS_BYTES_READ: 19950
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
@@ -1947,7 +1947,7 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@orc_ppd_n3
PREHOOK: Output: hdfs://### HDFS PATH ###
Stage-1 FILE SYSTEM COUNTERS:
- HDFS_BYTES_READ: 19952
+ HDFS_BYTES_READ: 19950
HDFS_BYTES_WRITTEN: 101
HDFS_READ_OPS: 5
HDFS_LARGE_READ_OPS: 0
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/llap/order_null.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/order_null.q.out b/ql/src/test/results/clientpositive/llap/order_null.q.out
index 8c37d52..c380844 100644
--- a/ql/src/test/results/clientpositive/llap/order_null.q.out
+++ b/ql/src/test/results/clientpositive/llap/order_null.q.out
@@ -161,9 +161,9 @@ POSTHOOK: Input: default@src_null_n1
1 A
2 A
2 B
-NULL NULL
2 NULL
3 NULL
+NULL NULL
PREHOOK: query: SELECT x.* FROM src_null_n1 x ORDER BY b desc nulls last, a
PREHOOK: type: QUERY
PREHOOK: Input: default@src_null_n1
@@ -175,9 +175,9 @@ POSTHOOK: Input: default@src_null_n1
2 B
1 A
2 A
-NULL NULL
2 NULL
3 NULL
+NULL NULL
PREHOOK: query: SELECT x.* FROM src_null_n1 x ORDER BY a asc nulls last, b desc
PREHOOK: type: QUERY
PREHOOK: Input: default@src_null_n1
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/llap/ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ptf.q.out b/ql/src/test/results/clientpositive/llap/ptf.q.out
index 7a067f7..bf21798 100644
--- a/ql/src/test/results/clientpositive/llap/ptf.q.out
+++ b/ql/src/test/results/clientpositive/llap/ptf.q.out
@@ -60,7 +60,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -87,7 +87,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -272,7 +272,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -299,7 +299,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -426,7 +426,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -551,7 +551,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -578,7 +578,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -731,7 +731,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -758,7 +758,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -914,7 +914,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -950,7 +950,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col0
raw input shape:
window functions:
@@ -1115,7 +1115,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
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:
@@ -1292,7 +1292,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
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:
@@ -1398,7 +1398,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: p_name ASC NULLS FIRST, p_size DESC NULLS LAST
+ order by: p_name ASC NULLS LAST, p_size DESC NULLS LAST
output shape: p_name: string, p_mfgr: string, p_size: int
partition by: p_mfgr
raw input shape:
@@ -1428,7 +1428,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST
+ order by: _col1 ASC NULLS LAST, _col5 DESC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -1455,7 +1455,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST
+ order by: _col1 ASC NULLS LAST, _col5 DESC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -1572,7 +1572,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: p_name ASC NULLS FIRST
+ order by: p_name ASC NULLS LAST
output shape: p_name: string, p_mfgr: string, p_size: int, p_retailprice: double
partition by: p_mfgr
raw input shape:
@@ -1603,7 +1603,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1631,7 +1631,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -1780,7 +1780,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1807,7 +1807,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -1959,7 +1959,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1973,7 +1973,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1981,7 +1981,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -2009,7 +2009,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -2017,7 +2017,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2 DESC NULLS LAST, _col1 ASC NULLS FIRST
+ order by: _col2 DESC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -2044,7 +2044,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -2203,7 +2203,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -2230,7 +2230,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -2402,7 +2402,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col0: int, _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -2449,7 +2449,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -2613,7 +2613,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -2788,7 +2788,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col0 ASC NULLS FIRST
+ order by: _col0 ASC NULLS LAST
output shape: _col0: string, _col1: string, _col2: double
partition by: _col0
raw input shape:
@@ -2815,7 +2815,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col0
raw input shape:
window functions:
@@ -3006,7 +3006,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -3039,7 +3039,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -3120,7 +3120,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col5 ASC NULLS FIRST
+ order by: _col5 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -3157,7 +3157,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col3 ASC NULLS FIRST, _col2 ASC NULLS FIRST
+ order by: _col3 ASC NULLS LAST, _col2 ASC NULLS LAST
partition by: _col3
raw input shape:
window functions:
@@ -3464,14 +3464,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
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 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -3485,7 +3485,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3493,7 +3493,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3521,7 +3521,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3529,7 +3529,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3739,14 +3739,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
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 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -3773,7 +3773,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -3800,7 +3800,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -3827,7 +3827,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -4005,14 +4005,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
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 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4039,14 +4039,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
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 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4073,7 +4073,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -4252,14 +4252,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
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 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4286,7 +4286,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4300,7 +4300,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4329,7 +4329,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4537,7 +4537,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4551,7 +4551,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4559,7 +4559,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4587,7 +4587,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4595,7 +4595,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -4622,7 +4622,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
partition by: _col2, _col1
raw input shape:
window functions:
@@ -4796,14 +4796,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
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 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4817,7 +4817,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4846,7 +4846,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -4874,7 +4874,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out b/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out
index abb05ff..a1a3416 100644
--- a/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out
+++ b/ql/src/test/results/clientpositive/llap/ptf_matchpath.q.out
@@ -98,7 +98,7 @@ STAGE PLANS:
input alias: ptf_1
arguments: 'LATE.LATE+', 'LATE', (_col5 > 15.0), 'origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath'
name: matchpath
- order by: _col2 ASC NULLS FIRST, _col3 ASC NULLS FIRST, _col4 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col3 ASC NULLS LAST, _col4 ASC NULLS LAST
output shape: tpath: int
partition by: _col6
raw input shape:
@@ -226,7 +226,7 @@ STAGE PLANS:
input alias: ptf_1
arguments: 'LATE.LATE+', 'LATE', (_col5 > 15.0), 'origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath'
name: matchpath
- order by: _col6 ASC NULLS FIRST, _col2 ASC NULLS FIRST, _col3 ASC NULLS FIRST, _col4 ASC NULLS FIRST
+ order by: _col6 ASC NULLS LAST, _col2 ASC NULLS LAST, _col3 ASC NULLS LAST, _col4 ASC NULLS LAST
output shape: tpath: int
partition by: 0
raw input shape:
@@ -352,7 +352,7 @@ STAGE PLANS:
input alias: ptf_1
arguments: 'LATE.LATE+', 'LATE', (_col5 > 15.0), 'origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath'
name: matchpath
- order by: _col6 ASC NULLS FIRST, _col2 ASC NULLS FIRST, _col3 ASC NULLS FIRST, _col4 ASC NULLS FIRST
+ order by: _col6 ASC NULLS LAST, _col2 ASC NULLS LAST, _col3 ASC NULLS LAST, _col4 ASC NULLS LAST
output shape: tpath: int
partition by: 0
raw input shape:
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out b/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out
index d536945..8f5cf5e 100644
--- a/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out
+++ b/ql/src/test/results/clientpositive/llap/ptf_streaming.q.out
@@ -60,7 +60,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -87,7 +87,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -272,7 +272,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -299,7 +299,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -445,7 +445,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noopstreaming
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
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:
@@ -569,7 +569,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: p_name ASC NULLS FIRST, p_size DESC NULLS LAST
+ order by: p_name ASC NULLS LAST, p_size DESC NULLS LAST
output shape: p_name: string, p_mfgr: string, p_size: int
partition by: p_mfgr
raw input shape:
@@ -599,7 +599,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST
+ order by: _col1 ASC NULLS LAST, _col5 DESC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -626,7 +626,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST, _col5 DESC NULLS LAST
+ order by: _col1 ASC NULLS LAST, _col5 DESC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -743,7 +743,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: p_name ASC NULLS FIRST
+ order by: p_name ASC NULLS LAST
output shape: p_name: string, p_mfgr: string, p_size: int, p_retailprice: double
partition by: p_mfgr
raw input shape:
@@ -774,7 +774,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -802,7 +802,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -954,7 +954,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -968,7 +968,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -976,7 +976,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1004,7 +1004,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1012,7 +1012,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1039,7 +1039,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -1193,7 +1193,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1207,7 +1207,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1215,7 +1215,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1243,7 +1243,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1251,7 +1251,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1278,7 +1278,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -1432,7 +1432,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1446,7 +1446,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1454,7 +1454,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1482,7 +1482,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1490,7 +1490,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noop
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1517,7 +1517,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -1691,7 +1691,7 @@ STAGE PLANS:
Partition table definition
input alias: abc
name: noopstreaming
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
output shape: _col0: int, _col1: string, _col2: string, _col5: int, _col7: double
partition by: _col2
raw input shape:
@@ -1738,7 +1738,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -1925,14 +1925,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
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 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -1946,7 +1946,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -1954,7 +1954,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -1982,7 +1982,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmap
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -1990,7 +1990,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_2
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2200,14 +2200,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
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 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -2234,7 +2234,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2261,7 +2261,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noop
- order by: _col2 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2
raw input shape:
@@ -2288,7 +2288,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
@@ -2464,14 +2464,14 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
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 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2485,7 +2485,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2514,7 +2514,7 @@ STAGE PLANS:
Partition table definition
input alias: ptf_1
name: noopwithmapstreaming
- order by: _col2 ASC NULLS FIRST, _col1 ASC NULLS FIRST
+ order by: _col2 ASC NULLS LAST, _col1 ASC NULLS LAST
output shape: _col1: string, _col2: string, _col5: int
partition by: _col2, _col1
raw input shape:
@@ -2542,7 +2542,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: _col2
raw input shape:
window functions:
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/llap/sharedworkext.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/sharedworkext.q.out b/ql/src/test/results/clientpositive/llap/sharedworkext.q.out
index 531f073..5d8dcfc 100644
--- a/ql/src/test/results/clientpositive/llap/sharedworkext.q.out
+++ b/ql/src/test/results/clientpositive/llap/sharedworkext.q.out
@@ -648,7 +648,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: 0
raw input shape:
window functions:
@@ -706,7 +706,7 @@ STAGE PLANS:
Windowing table definition
input alias: ptf_1
name: windowingtablefunction
- order by: _col1 ASC NULLS FIRST
+ order by: _col1 ASC NULLS LAST
partition by: 0
raw input shape:
window functions:
http://git-wip-us.apache.org/repos/asf/hive/blob/499d01a3/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out b/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out
index cd20c3a..26e4355 100644
--- a/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out
+++ b/ql/src/test/results/clientpositive/llap/skewjoinopt15.q.out
@@ -258,14 +258,14 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1_n109
POSTHOOK: Input: default@t2_n66
#### A masked pattern was here ####
-NULL NULL 4 14
-NULL NULL 5 15
2 12 2 22
3 13 3 13
8 18 8 18
8 18 8 18
8 28 8 18
8 28 8 18
+NULL NULL 4 14
+NULL NULL 5 15
PREHOOK: query: EXPLAIN
SELECT count(1) FROM T1_n109 a JOIN T2_n66 b ON a.key = b.key
PREHOOK: type: QUERY