This is an automated email from the ASF dual-hosted git repository.
krisztiankasa pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push:
new cc8bf3c1aa9 HIVE-28732: Sorted dynamic partition optimization does not
apply hive.default.nulls.last (Krisztian Kasa, reviewed by Shohei Okumiya)
cc8bf3c1aa9 is described below
commit cc8bf3c1aa96dd4c8e9ac2f2cd04cc6f3f9a2a59
Author: Krisztian Kasa <[email protected]>
AuthorDate: Wed Feb 19 09:39:40 2025 +0100
HIVE-28732: Sorted dynamic partition optimization does not apply
hive.default.nulls.last (Krisztian Kasa, reviewed by Shohei Okumiya)
---
.../iceberg/mr/hive/HiveIcebergStorageHandler.java | 8 +++-
.../delete_iceberg_copy_on_write_partitioned.q.out | 12 +++---
.../positive/dynamic_partition_writes.q.out | 4 +-
.../positive/iceberg_insert_into_partition.q.out | 12 +++---
.../iceberg_insert_into_partition_transforms.q.out | 2 +-
.../iceberg_insert_overwrite_partition.q.out | 12 +++---
.../merge_iceberg_copy_on_write_partitioned.q.out | 8 ++--
.../positive/merge_iceberg_partitioned_orc.q.out | 4 +-
.../update_iceberg_copy_on_write_partitioned.q.out | 24 +++++------
.../positive/vectorized_iceberg_merge_mixed.q.out | 8 ++--
.../insert_into_dynamic_partitions.q.out | 2 +-
.../insert_overwrite_dynamic_partitions.q.out | 2 +-
.../ql/optimizer/SortedDynPartitionOptimizer.java | 39 ++++++------------
.../apache/hadoop/hive/ql/util/NullOrdering.java | 17 +++++++-
.../clientpositive/llap/autoColumnStats_6.q.out | 2 +-
.../llap/dynpart_sort_opt_bucketing.q.out | 6 +--
.../llap/dynpart_sort_opt_vectorization.q.out | 26 ++++++------
.../llap/dynpart_sort_optimization.q.out | 46 +++++++++++-----------
.../llap/dynpart_sort_optimization_acid.q.out | 10 ++---
.../llap/dynpart_sort_optimization_acid2.q.out | 2 +-
.../llap/expanding_multivaluecolvector.q.out | 4 +-
.../llap/infer_bucket_sort_num_buckets.q.out | 2 +-
.../llap/insert_overwrite_preemption.q.out | 2 +-
.../clientpositive/llap/load_data_using_job.q.out | 20 +++++-----
.../clientpositive/llap/load_dyn_part5.q.out | 2 +-
.../llap/load_static_ptn_into_bucketed_table.q.out | 4 +-
.../llap/materialized_view_partitioned.q.out | 8 ++--
.../llap/materialized_view_partitioned_3.q.out | 2 +-
.../llap/merge_dynamic_partition.q.out | 4 +-
.../llap/merge_dynamic_partition2.q.out | 2 +-
.../llap/merge_dynamic_partition3.q.out | 2 +-
.../test/results/clientpositive/llap/mm_dp.q.out | 2 +-
.../llap/murmur_hash_migration2.q.out | 2 +-
.../results/clientpositive/llap/orc_merge10.q.out | 6 +--
.../results/clientpositive/llap/orc_merge2.q.out | 2 +-
.../results/clientpositive/llap/orc_merge7.q.out | 4 +-
.../clientpositive/llap/orc_merge_diff_fs.q.out | 6 +--
.../clientpositive/llap/orc_merge_incompat2.q.out | 2 +-
.../clientpositive/llap/partition_ctas.q.out | 2 +-
.../llap/partition_explain_ddl.q.out | 46 +++++++++++-----------
.../llap/partitions_cols_dedup.q.out | 4 +-
.../clientpositive/llap/rcfile_merge2.q.out | 2 +-
.../llap/temp_table_merge_dynamic_partition.q.out | 4 +-
.../llap/temp_table_merge_dynamic_partition2.q.out | 2 +-
.../llap/temp_table_merge_dynamic_partition3.q.out | 2 +-
.../llap/temp_table_merge_dynamic_partition4.q.out | 2 +-
.../llap/temp_table_merge_dynamic_partition5.q.out | 2 +-
.../llap/temp_table_partition_ctas.q.out | 2 +-
.../clientpositive/llap/union_remove_17.q.out | 4 +-
49 files changed, 200 insertions(+), 194 deletions(-)
diff --git
a/iceberg/iceberg-handler/src/main/java/org/apache/iceberg/mr/hive/HiveIcebergStorageHandler.java
b/iceberg/iceberg-handler/src/main/java/org/apache/iceberg/mr/hive/HiveIcebergStorageHandler.java
index 879c109f73f..3ba53b2a657 100644
---
a/iceberg/iceberg-handler/src/main/java/org/apache/iceberg/mr/hive/HiveIcebergStorageHandler.java
+++
b/iceberg/iceberg-handler/src/main/java/org/apache/iceberg/mr/hive/HiveIcebergStorageHandler.java
@@ -124,6 +124,7 @@
import org.apache.hadoop.hive.ql.session.SessionStateUtil;
import org.apache.hadoop.hive.ql.stats.Partish;
import org.apache.hadoop.hive.ql.stats.StatsUtils;
+import org.apache.hadoop.hive.ql.util.NullOrdering;
import org.apache.hadoop.hive.serde2.AbstractSerDe;
import org.apache.hadoop.hive.serde2.DefaultFetchFormatter;
import org.apache.hadoop.hive.serde2.Deserializer;
@@ -848,7 +849,12 @@ public DynamicPartitionCtx createDPContext(
if (sortField.sourceId() == field.fieldId()) {
customSortPositions.add(pos);
customSortOrder.add(sortField.direction() == SortDirection.ASC ? 1
: 0);
- customSortNullOrder.add(sortField.nullOrder() ==
NullOrder.NULLS_FIRST ? 0 : 1);
+
+ NullOrdering nullOrdering = NullOrdering.NULLS_LAST;
+ if (sortField.nullOrder() == NullOrder.NULLS_FIRST) {
+ nullOrdering = NullOrdering.NULLS_FIRST;
+ }
+ customSortNullOrder.add(nullOrdering.getCode());
break;
}
pos++;
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/delete_iceberg_copy_on_write_partitioned.q.out
b/iceberg/iceberg-handler/src/test/results/positive/delete_iceberg_copy_on_write_partitioned.q.out
index 16e924f62f7..924a50bda37 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/delete_iceberg_copy_on_write_partitioned.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/delete_iceberg_copy_on_write_partitioned.q.out
@@ -458,7 +458,7 @@ STAGE PLANS:
Statistics: Num rows: 3 Data size: 1455 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 7 Data size: 3395 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -694,7 +694,7 @@ STAGE PLANS:
Statistics: Num rows: 4 Data size: 1940 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 7 Data size: 3395 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1065,7 +1065,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 485 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 2 Data size: 970 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1137,7 +1137,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 485 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 2 Data size: 970 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1517,7 +1517,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 485 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 2 Data size: 970 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1589,7 +1589,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 485 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 2 Data size: 970 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/dynamic_partition_writes.q.out
b/iceberg/iceberg-handler/src/test/results/positive/dynamic_partition_writes.q.out
index f1180d54e0a..b89e15109df 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/dynamic_partition_writes.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/dynamic_partition_writes.q.out
@@ -423,7 +423,6 @@ POSTHOOK: query: select * from
default.tbl_target_mixed.files
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tbl_target_mixed
POSTHOOK: Output: hdfs://### HDFS PATH ###
-0 hdfs://### HDFS PATH ### ORC 0
{"ccy":null,"c_bucket":null} 2 417 {1:7,2:5,3:5} {1:2,2:2,3:2}
{1:0,2:2,3:2} {} {1: ���} {1:n���} NULL [3] NULL
0
{"a":{"column_size":7,"value_count":2,"null_value_count":0,"nan_value_count":null,"lower_bound":12,"upper_bound":110},"c":{"column_size":5,"value_count":2,"null_value_count":2,"nan_value_count":null,"lower_bound":null,"upper_bound":null},"ccy":{"column_size":5,"value_count":2,"null_value_count":2,"nan_value_count":null,"lower_bound":null,"upper_bound":null}}
0 hdfs://### HDFS PATH ### ORC 0
{"ccy":"CZK","c_bucket":1} 1 449 {1:6,2:12,3:6} {1:1,2:1,3:1}
{1:0,2:0,3:0} {} {1:d���,2:CZK,3: �������} {1:d���,2:CZK,3:
�������} NULL [3] NULL 0
{"a":{"column_size":6,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":100,"upper_bound":100},"c":{"column_size":6,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":12,"upper_bound":12},"ccy":{"column_size":12,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":"CZK","upper_bound":"CZK"}}
0 hdfs://### HDFS PATH ### ORC 0
{"ccy":"CZK","c_bucket":2} 1 432 {1:6,2:12,3:6} {1:1,2:1,3:1}
{1:0,2:0,3:0} {} {1:
���,2:CZK,3:�������} {1:
@@ -443,6 +442,7 @@ POSTHOOK: Output: hdfs://### HDFS PATH ###
0 hdfs://### HDFS PATH ### ORC 0
{"ccy":"USD","c_bucket":2} 1 432 {1:6,2:12,3:6} {1:1,2:1,3:1}
{1:0,2:0,3:0} {} {1:���,2:USD,3:
�������} {1:���,2:USD,3:
�������} NULL [3] NULL 0
{"a":{"column_size":6,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":6,"upper_bound":6},"c":{"column_size":6,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":10,"upper_bound":10},"ccy":{"column_size":12,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":"USD","upper_bound":"USD"}}
+0 hdfs://### HDFS PATH ### ORC 0
{"ccy":null,"c_bucket":null} 2 417 {1:7,2:5,3:5} {1:2,2:2,3:2}
{1:0,2:2,3:2} {} {1: ���} {1:n���} NULL [3] NULL
0
{"a":{"column_size":7,"value_count":2,"null_value_count":0,"nan_value_count":null,"lower_bound":12,"upper_bound":110},"c":{"column_size":5,"value_count":2,"null_value_count":2,"nan_value_count":null,"lower_bound":null,"upper_bound":null},"ccy":{"column_size":5,"value_count":2,"null_value_count":2,"nan_value_count":null,"lower_bound":null,"upper_bound":null}}
PREHOOK: query: explain insert into table tbl_target_mixed select * from
tbl_src where b = 'EUR'
PREHOOK: type: QUERY
PREHOOK: Input: default@tbl_src
@@ -605,7 +605,6 @@ POSTHOOK: Output: hdfs://### HDFS PATH ###
0 hdfs://### HDFS PATH ### ORC 0
{"ccy":"EUR","c_bucket":2} 3 448 {1:8,2:17,3:5} {1:3,2:3,3:3}
{1:0,2:0,3:0} {} {1:���,2:EUR,3:
�������} {1:(���,2:EUR,3:
�������} NULL [3] NULL 0
{"a":{"column_size":8,"value_count":3,"null_value_count":0,"nan_value_count":null,"lower_bound":1,"upper_bound":40},"c":{"column_size":5,"value_count":3,"null_value_count":0,"nan_value_count":null,"lower_bound":10,"upper_bound":10},"ccy":{"column_size":17,"value_count":3,"null_value_count":0,"nan_value_count":null,"lower_bound":"EUR","upper_bound":"EUR"}}
-0 hdfs://### HDFS PATH ### ORC 0
{"ccy":null,"c_bucket":null} 2 417 {1:7,2:5,3:5} {1:2,2:2,3:2}
{1:0,2:2,3:2} {} {1: ���} {1:n���} NULL [3] NULL
0
{"a":{"column_size":7,"value_count":2,"null_value_count":0,"nan_value_count":null,"lower_bound":12,"upper_bound":110},"c":{"column_size":5,"value_count":2,"null_value_count":2,"nan_value_count":null,"lower_bound":null,"upper_bound":null},"ccy":{"column_size":5,"value_count":2,"null_value_count":2,"nan_value_count":null,"lower_bound":null,"upper_bound":null}}
0 hdfs://### HDFS PATH ### ORC 0
{"ccy":"CZK","c_bucket":1} 1 449 {1:6,2:12,3:6} {1:1,2:1,3:1}
{1:0,2:0,3:0} {} {1:d���,2:CZK,3: �������} {1:d���,2:CZK,3:
�������} NULL [3] NULL 0
{"a":{"column_size":6,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":100,"upper_bound":100},"c":{"column_size":6,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":12,"upper_bound":12},"ccy":{"column_size":12,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":"CZK","upper_bound":"CZK"}}
0 hdfs://### HDFS PATH ### ORC 0
{"ccy":"CZK","c_bucket":2} 1 432 {1:6,2:12,3:6} {1:1,2:1,3:1}
{1:0,2:0,3:0} {} {1:
���,2:CZK,3:�������} {1:
@@ -625,6 +624,7 @@ POSTHOOK: Output: hdfs://### HDFS PATH ###
0 hdfs://### HDFS PATH ### ORC 0
{"ccy":"USD","c_bucket":2} 1 432 {1:6,2:12,3:6} {1:1,2:1,3:1}
{1:0,2:0,3:0} {} {1:���,2:USD,3:
�������} {1:���,2:USD,3:
�������} NULL [3] NULL 0
{"a":{"column_size":6,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":6,"upper_bound":6},"c":{"column_size":6,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":10,"upper_bound":10},"ccy":{"column_size":12,"value_count":1,"null_value_count":0,"nan_value_count":null,"lower_bound":"USD","upper_bound":"USD"}}
+0 hdfs://### HDFS PATH ### ORC 0
{"ccy":null,"c_bucket":null} 2 417 {1:7,2:5,3:5} {1:2,2:2,3:2}
{1:0,2:2,3:2} {} {1: ���} {1:n���} NULL [3] NULL
0
{"a":{"column_size":7,"value_count":2,"null_value_count":0,"nan_value_count":null,"lower_bound":12,"upper_bound":110},"c":{"column_size":5,"value_count":2,"null_value_count":2,"nan_value_count":null,"lower_bound":null,"upper_bound":null},"ccy":{"column_size":5,"value_count":2,"null_value_count":2,"nan_value_count":null,"lower_bound":null,"upper_bound":null}}
PREHOOK: query: create external table tbl_bucket_date (id string,
date_time_date date, year_partition int)
partitioned by spec (year_partition, bucket(1, date_time_date))
stored by iceberg stored as parquet
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_into_partition.q.out
b/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_into_partition.q.out
index bde25730986..18af1c62fd5 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_into_partition.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_into_partition.q.out
@@ -923,7 +923,7 @@ STAGE PLANS:
Statistics: Num rows: 6 Data size: 1626 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 6 Data size: 1626 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1042,7 +1042,7 @@ STAGE PLANS:
Statistics: Num rows: 12 Data size: 3252 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 12 Data size: 3252 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1161,7 +1161,7 @@ STAGE PLANS:
Statistics: Num rows: 24 Data size: 6504 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 24 Data size: 6504 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1280,7 +1280,7 @@ STAGE PLANS:
Statistics: Num rows: 48 Data size: 13008 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 48 Data size: 13008 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1401,7 +1401,7 @@ STAGE PLANS:
Statistics: Num rows: 96 Data size: 26208 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 96 Data size: 26208 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1522,7 +1522,7 @@ STAGE PLANS:
Statistics: Num rows: 192 Data size: 52416 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 192 Data size: 52416 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_into_partition_transforms.q.out
b/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_into_partition_transforms.q.out
index 1fb6a3255c2..8ae4e17ccc2 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_into_partition_transforms.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_into_partition_transforms.q.out
@@ -2910,7 +2910,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 112 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col0, 16) (type:
int)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: iceberg_bucket(_col0,
16) (type: int)
Statistics: Num rows: 1 Data size: 112 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_overwrite_partition.q.out
b/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_overwrite_partition.q.out
index fdbc4cf4b08..5c5b2b51536 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_overwrite_partition.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/iceberg_insert_overwrite_partition.q.out
@@ -495,7 +495,7 @@ STAGE PLANS:
Statistics: Num rows: 4 Data size: 1084 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 4 Data size: 1084 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -614,7 +614,7 @@ STAGE PLANS:
Statistics: Num rows: 4 Data size: 1084 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 4 Data size: 1084 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -733,7 +733,7 @@ STAGE PLANS:
Statistics: Num rows: 4 Data size: 1084 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 4 Data size: 1084 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -852,7 +852,7 @@ STAGE PLANS:
Statistics: Num rows: 6 Data size: 1626 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 6 Data size: 1626 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -973,7 +973,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 2730 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 10 Data size: 2730 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1094,7 +1094,7 @@ STAGE PLANS:
Statistics: Num rows: 20 Data size: 5460 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 20 Data size: 5460 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/merge_iceberg_copy_on_write_partitioned.q.out
b/iceberg/iceberg-handler/src/test/results/positive/merge_iceberg_copy_on_write_partitioned.q.out
index b56658019c7..875b6e3ca30 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/merge_iceberg_copy_on_write_partitioned.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/merge_iceberg_copy_on_write_partitioned.q.out
@@ -231,7 +231,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 966 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 7 Data size: 3384 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -252,7 +252,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 486 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 7 Data size: 3384 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -308,7 +308,7 @@ STAGE PLANS:
Statistics: Num rows: 4 Data size: 1932 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 7 Data size: 3384 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -519,7 +519,7 @@ STAGE PLANS:
Statistics: Num rows: 9 Data size: 1452 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 9 Data size: 1452 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/merge_iceberg_partitioned_orc.q.out
b/iceberg/iceberg-handler/src/test/results/positive/merge_iceberg_partitioned_orc.q.out
index 499fd6ecbaa..6a4c0308868 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/merge_iceberg_partitioned_orc.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/merge_iceberg_partitioned_orc.q.out
@@ -165,7 +165,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 98 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col0, 16) (type:
int), iceberg_truncate(_col1, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col0,
16) (type: int), iceberg_truncate(_col1, 3) (type: string)
Statistics: Num rows: 1 Data size: 98 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -179,7 +179,7 @@ STAGE PLANS:
Statistics: Num rows: 6 Data size: 576 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col0, 16) (type:
int), iceberg_truncate(_col1, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col0,
16) (type: int), iceberg_truncate(_col1, 3) (type: string)
Statistics: Num rows: 6 Data size: 576 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/update_iceberg_copy_on_write_partitioned.q.out
b/iceberg/iceberg-handler/src/test/results/positive/update_iceberg_copy_on_write_partitioned.q.out
index 9d48964b7b2..3254ae32eaf 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/update_iceberg_copy_on_write_partitioned.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/update_iceberg_copy_on_write_partitioned.q.out
@@ -61,7 +61,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 487 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1443 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -145,7 +145,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 472 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1443 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -185,7 +185,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 484 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1443 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -529,7 +529,7 @@ STAGE PLANS:
Statistics: Num rows: 9 Data size: 4437 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 19 Data size: 9287 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -740,7 +740,7 @@ STAGE PLANS:
Statistics: Num rows: 4 Data size: 1940 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 19 Data size: 9287 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1021,7 +1021,7 @@ STAGE PLANS:
Statistics: Num rows: 6 Data size: 2910 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 19 Data size: 9287 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1445,7 +1445,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 485 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1465 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1481,7 +1481,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 495 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1465 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1538,7 +1538,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 485 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1465 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1867,7 +1867,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 485 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type:
int), iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5,
16) (type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1462 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1951,7 +1951,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 492 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1462 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -2049,7 +2049,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 485 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: iceberg_bucket(_col5, 16) (type: int),
iceberg_truncate(_col6, 3) (type: string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: iceberg_bucket(_col5, 16)
(type: int), iceberg_truncate(_col6, 3) (type: string)
Statistics: Num rows: 3 Data size: 1462 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/iceberg/iceberg-handler/src/test/results/positive/vectorized_iceberg_merge_mixed.q.out
b/iceberg/iceberg-handler/src/test/results/positive/vectorized_iceberg_merge_mixed.q.out
index 24b1f4f881c..feb7f1f4182 100644
---
a/iceberg/iceberg-handler/src/test/results/positive/vectorized_iceberg_merge_mixed.q.out
+++
b/iceberg/iceberg-handler/src/test/results/positive/vectorized_iceberg_merge_mixed.q.out
@@ -426,7 +426,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: #Masked# Basic
stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col3 (type: int),
iceberg_bucket(_col2, 3) (type: int)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col3 (type: int),
iceberg_bucket(_col2, 3) (type: int)
Reduce Sink Vectorization:
@@ -456,7 +456,7 @@ STAGE PLANS:
Statistics: Num rows: 3 Data size: #Masked# Basic
stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col3 (type: int),
iceberg_bucket(_col2, 3) (type: int)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col3 (type: int),
iceberg_bucket(_col2, 3) (type: int)
Reduce Sink Vectorization:
@@ -588,7 +588,7 @@ STAGE PLANS:
Reduce Vectorization:
enabled: true
enableConditionsMet: hive.vectorized.execution.reduce.enabled
IS true, hive.execution.engine tez IN [tez] IS true
- reduceColumnNullOrder: aa
+ reduceColumnNullOrder: zz
reduceColumnSortOrder: ++
allNative: false
usesVectorUDFAdaptor: false
@@ -623,7 +623,7 @@ STAGE PLANS:
Reduce Vectorization:
enabled: true
enableConditionsMet: hive.vectorized.execution.reduce.enabled
IS true, hive.execution.engine tez IN [tez] IS true
- reduceColumnNullOrder: aa
+ reduceColumnNullOrder: zz
reduceColumnSortOrder: ++
allNative: false
usesVectorUDFAdaptor: false
diff --git
a/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
index baa4d4a999c..3cb4b1dc7d0 100644
---
a/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
+++
b/itests/hive-blobstore/src/test/results/clientpositive/insert_into_dynamic_partitions.q.out
@@ -117,7 +117,7 @@ STAGE PLANS:
Reduce Output Operator
bucketingVersion: 2
key expressions: _col1 (type: string), _bucket_number
(type: string), _col0 (type: int)
- null sort order: aaa
+ null sort order: zzz
numBuckets: 2
sort order: +++
Map-reduce partition columns: _col1 (type: string)
diff --git
a/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
index 77f8d6fa840..c144f2dfaec 100644
---
a/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
+++
b/itests/hive-blobstore/src/test/results/clientpositive/insert_overwrite_dynamic_partitions.q.out
@@ -135,7 +135,7 @@ STAGE PLANS:
Reduce Output Operator
bucketingVersion: 2
key expressions: _col1 (type: string), _bucket_number
(type: string), _col0 (type: int)
- null sort order: aaa
+ null sort order: zzz
numBuckets: 2
sort order: +++
Map-reduce partition columns: _col1 (type: string)
diff --git
a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedDynPartitionOptimizer.java
b/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedDynPartitionOptimizer.java
index cebb937c120..60be9c9466d 100644
---
a/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedDynPartitionOptimizer.java
+++
b/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedDynPartitionOptimizer.java
@@ -31,6 +31,8 @@
import java.util.function.Function;
import java.util.stream.Collectors;
+
+import org.apache.commons.lang3.StringUtils;
import org.apache.hadoop.hive.conf.Constants;
import org.apache.hadoop.hive.conf.HiveConf;
import org.apache.hadoop.hive.metastore.api.FieldSchema;
@@ -78,6 +80,7 @@
import org.apache.hadoop.hive.ql.plan.SelectDesc;
import org.apache.hadoop.hive.ql.plan.Statistics;
import org.apache.hadoop.hive.ql.plan.TableDesc;
+import org.apache.hadoop.hive.ql.util.NullOrdering;
import org.apache.hadoop.hive.serde2.typeinfo.TypeInfo;
import org.apache.hadoop.hive.serde2.typeinfo.TypeInfoFactory;
import org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo;
@@ -283,9 +286,9 @@ public Object process(Node nd, Stack<Node> stack,
NodeProcessorCtx procCtx,
List<ColumnInfo> colInfos = fsParent.getSchema().getSignature();
bucketColumns = getPositionsToExprNodes(bucketPositions, colInfos);
}
- List<Integer> sortNullOrder = new ArrayList<Integer>();
+ List<Integer> sortNullOrder = new ArrayList<>();
for (int order : sortOrder) {
- sortNullOrder.add(order == 1 ? 0 : 1); // for asc, nulls first; for
desc, nulls last
+ sortNullOrder.add(NullOrdering.defaultNullOrder(order,
parseCtx.getConf()).getCode());
}
LOG.debug("Got sort order");
for (int i : sortPositions) {
@@ -635,34 +638,18 @@ public ReduceSinkOperator getReduceSinkOp(List<Integer>
partitionPositions, List
}
}
- // if partition and bucket columns are sorted in ascending order, by
default
- // nulls come first; otherwise nulls come last
- Integer nullOrder = order == 1 ? 0 : 1;
+ char nullOrder = NullOrdering.defaultNullOrder(order,
parseCtx.getConf()).getSign();
if (sortNullOrder != null && !sortNullOrder.isEmpty()) {
- if (sortNullOrder.get(0) == 0) {
- nullOrder = 0;
- } else {
- nullOrder = 1;
- }
- }
-
- for (Integer ignored : keyColsPosInVal) {
- newSortNullOrder.add(nullOrder);
+ nullOrder = NullOrdering.fromCode(sortNullOrder.get(0)).getSign();
}
+ StringBuilder nullOrderStr = new
StringBuilder(StringUtils.repeat(nullOrder, keyColsPosInVal.size()));
if (customSortExprPresent) {
for (int i = 0; i < customSortExprs.size() -
customSortNullOrder.size(); i++) {
- newSortNullOrder.add(nullOrder);
+ nullOrderStr.append(nullOrder);
}
- newSortNullOrder.addAll(customSortNullOrder);
- }
-
- String nullOrderStr = "";
- for (Integer i : newSortNullOrder) {
- if (i == 0) {
- nullOrderStr += "a";
- } else {
- nullOrderStr += "z";
+ for (int i = 0; i < customSortNullOrder.size(); ++i) {
+
nullOrderStr.append(NullOrdering.fromCode(customSortNullOrder.get(i)).getSign());
}
}
@@ -709,7 +696,7 @@ public ReduceSinkOperator getReduceSinkOp(List<Integer>
partitionPositions, List
if (parentRSOpOrder != null && !parentRSOpOrder.isEmpty() &&
sortPositions.isEmpty()) {
keyCols.addAll(parentRSOp.getConf().getKeyCols());
orderStr += parentRSOpOrder;
- nullOrderStr += parentRSOpNullOrder;
+ nullOrderStr.append(parentRSOpNullOrder);
}
}
@@ -739,7 +726,7 @@ public ReduceSinkOperator getReduceSinkOp(List<Integer>
partitionPositions, List
// from Key and Value TableDesc
List<FieldSchema> fields =
PlanUtils.getFieldSchemasFromColumnList(keyCols,
keyColNames, 0, "");
- TableDesc keyTable = PlanUtils.getReduceKeyTableDesc(fields, orderStr,
nullOrderStr);
+ TableDesc keyTable = PlanUtils.getReduceKeyTableDesc(fields, orderStr,
nullOrderStr.toString());
List<FieldSchema> valFields =
PlanUtils.getFieldSchemasFromColumnList(valCols,
valColNames, 0, "");
TableDesc valueTable = PlanUtils.getReduceValueTableDesc(valFields);
diff --git a/ql/src/java/org/apache/hadoop/hive/ql/util/NullOrdering.java
b/ql/src/java/org/apache/hadoop/hive/ql/util/NullOrdering.java
index aaba52be1b4..96b80487fb5 100644
--- a/ql/src/java/org/apache/hadoop/hive/ql/util/NullOrdering.java
+++ b/ql/src/java/org/apache/hadoop/hive/ql/util/NullOrdering.java
@@ -23,6 +23,8 @@
import org.apache.hadoop.hive.ql.parse.HiveParser;
import
org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.NullValueOption;
+import static org.apache.hadoop.hive.ql.util.DirectionUtils.ASCENDING_CODE;
+
/**
* Enum for converting different Null ordering description types.
*/
@@ -82,8 +84,19 @@ public static NullOrdering
fromDirection(RelFieldCollation.NullDirection nullDir
}
public static NullOrdering defaultNullOrder(Configuration hiveConf) {
- return HiveConf.getBoolVar(hiveConf,
HiveConf.ConfVars.HIVE_DEFAULT_NULLS_LAST) ?
- NullOrdering.NULLS_LAST : NullOrdering.NULLS_FIRST;
+ return defaultNullsLast(HiveConf.getBoolVar(hiveConf,
HiveConf.ConfVars.HIVE_DEFAULT_NULLS_LAST));
+ }
+
+ private static NullOrdering defaultNullsLast(boolean defaultNullsLast) {
+ return defaultNullsLast ? NullOrdering.NULLS_LAST :
NullOrdering.NULLS_FIRST;
+ }
+
+ public static NullOrdering defaultNullOrder(int order, Configuration
hiveConf) {
+ if (order == ASCENDING_CODE) {
+ return defaultNullOrder(hiveConf);
+ }
+
+ return defaultNullsLast(!HiveConf.getBoolVar(hiveConf,
HiveConf.ConfVars.HIVE_DEFAULT_NULLS_LAST));
}
public int getCode() {
diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_6.q.out
b/ql/src/test/results/clientpositive/llap/autoColumnStats_6.q.out
index fd69a9b1129..4a224561fea 100644
--- a/ql/src/test/results/clientpositive/llap/autoColumnStats_6.q.out
+++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_6.q.out
@@ -55,7 +55,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 231500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 500 Data size: 231500 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_bucketing.q.out
b/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_bucketing.q.out
index 54c276325db..0f7cbf2abf4 100644
--- a/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_bucketing.q.out
+++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_bucketing.q.out
@@ -305,7 +305,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 112 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col12 (type: string),
_bucket_number (type: string), _col8 (type: string)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 1 Data size: 112 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -427,7 +427,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 112 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col12 (type: string),
_bucket_number (type: string), _col8 (type: string)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col12 (type: string)
Statistics: Num rows: 1 Data size: 112 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -667,7 +667,7 @@ STAGE PLANS:
Statistics: Num rows: 51 Data size: 23008 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col4 (type: decimal(3,0)),
_bucket_number (type: string), _col0 (type: string), _col1 (type: decimal(6,0))
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col4 (type: decimal(3,0))
Statistics: Num rows: 51 Data size: 23008 Basic stats:
PARTIAL Column stats: PARTIAL
diff --git
a/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out
b/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out
index ef967a20ffe..cdccef6aa36 100644
---
a/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out
+++
b/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out
@@ -204,7 +204,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _col0 (type:
smallint)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -346,7 +346,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 240 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 10 Data size: 240 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -467,7 +467,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col0 (type: smallint)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -589,7 +589,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col3 (type: float)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -796,7 +796,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _col0 (type:
smallint)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -938,7 +938,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 240 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 10 Data size: 240 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1059,7 +1059,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col0 (type: smallint)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1181,7 +1181,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col3 (type: float)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1895,7 +1895,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats: COMPLETE
Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _col1 (type: int)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -2043,7 +2043,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -2293,7 +2293,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: tinyint), _col1 (type:
smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: float)
- null sort order: azzzz
+ null sort order: zzzzz
sort order: +++++
Map-reduce partition columns: _col0 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -2850,7 +2850,7 @@ STAGE PLANS:
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col3 (type: float)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 11 Data size: 264 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -3474,7 +3474,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 816 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _bucket_number
(type: string), _col1 (type: smallint)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 10 Data size: 816 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out
b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out
index 9e2fad62961..aaca4368d0f 100644
--- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out
+++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out
@@ -145,7 +145,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -289,7 +289,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE
Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -410,7 +410,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col0 (type: smallint)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -532,7 +532,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col3 (type: float)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -723,7 +723,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -867,7 +867,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE
Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -988,7 +988,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col0 (type: smallint)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -1110,7 +1110,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col3 (type: float)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -1824,7 +1824,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE
Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _col1 (type: int)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE
Column stats: NONE
@@ -1972,7 +1972,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -2222,7 +2222,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: tinyint), _col1 (type:
smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: float)
- null sort order: azzzz
+ null sort order: zzzzz
sort order: +++++
Map-reduce partition columns: _col0 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -2779,7 +2779,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col4 (type: tinyint), _bucket_number
(type: string), _col3 (type: float)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 1 Data size: 24 Basic stats:
COMPLETE Column stats: NONE
@@ -3197,7 +3197,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string), _col4 (type:
tinyint), _col5 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col3 (type: string),
_col4 (type: tinyint), _col5 (type: int)
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
@@ -3321,7 +3321,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string), _col4 (type:
tinyint), _col5 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col3 (type: string),
_col4 (type: tinyint), _col5 (type: int)
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
@@ -3445,7 +3445,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string), _col4 (type:
tinyint), _col5 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col3 (type: string),
_col4 (type: tinyint), _col5 (type: int)
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
@@ -3569,7 +3569,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string), _col4 (type:
tinyint), _col5 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col3 (type: string),
_col4 (type: tinyint), _col5 (type: int)
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
@@ -3693,7 +3693,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string), _col4 (type:
tinyint), _col5 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col3 (type: string),
_col4 (type: tinyint), _col5 (type: int)
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
@@ -3817,7 +3817,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string), _col4 (type:
tinyint), _col5 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col3 (type: string),
_col4 (type: tinyint), _col5 (type: int)
Statistics: Num rows: 1 Data size: 208 Basic stats:
COMPLETE Column stats: NONE
@@ -4459,7 +4459,7 @@ STAGE PLANS:
Statistics: Num rows: 804 Data size: 19288 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 804 Data size: 19288 Basic
stats: COMPLETE Column stats: COMPLETE
@@ -4603,7 +4603,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 240 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 10 Data size: 240 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -4852,7 +4852,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 240 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col4 (type: tinyint)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col4 (type: tinyint)
Statistics: Num rows: 10 Data size: 240 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -5019,7 +5019,7 @@ STAGE PLANS:
Statistics: Num rows: 524 Data size: 52924 Basic
stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 524 Data size: 52924 Basic
stats: COMPLETE Column stats: COMPLETE
@@ -5048,7 +5048,7 @@ STAGE PLANS:
Statistics: Num rows: 524 Data size: 52924 Basic
stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 524 Data size: 52924 Basic
stats: COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out
b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out
index fecb749735f..9fa3296ac6d 100644
---
a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out
+++
b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid.q.out
@@ -1694,7 +1694,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 800 Basic stats:
COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: '2008-04-08' (type: string), _col2
(type: int), _bucket_number (type: string), _col0 (type:
struct<writeid:bigint,bucketid:int,rowid:bigint>)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: '2008-04-08' (type:
string), _col2 (type: int)
Statistics: Num rows: 10 Data size: 1740 Basic stats:
COMPLETE Column stats: PARTIAL
@@ -1704,7 +1704,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 2720 Basic stats:
COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
int), _bucket_number (type: string), _col0 (type: string)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: int)
Statistics: Num rows: 10 Data size: 2720 Basic
stats: COMPLETE Column stats: PARTIAL
@@ -1889,7 +1889,7 @@ STAGE PLANS:
Statistics: Num rows: 14 Data size: 3696 Basic stats:
COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: _col1 (type: string), _col2 (type:
int), _bucket_number (type: string), _col0 (type:
struct<writeid:bigint,bucketid:int,rowid:bigint>)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col1 (type: string),
_col2 (type: int)
Statistics: Num rows: 14 Data size: 3696 Basic stats:
COMPLETE Column stats: PARTIAL
@@ -2266,7 +2266,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 800 Basic stats:
COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: '2008-04-08' (type: string), _col2
(type: int), _bucket_number (type: string), _col0 (type:
struct<writeid:bigint,bucketid:int,rowid:bigint>)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: '2008-04-08' (type:
string), _col2 (type: int)
Statistics: Num rows: 10 Data size: 1740 Basic stats:
COMPLETE Column stats: PARTIAL
@@ -2276,7 +2276,7 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 2720 Basic stats:
COMPLETE Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
int), _bucket_number (type: string), _col0 (type: string)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: int)
Statistics: Num rows: 10 Data size: 2720 Basic
stats: COMPLETE Column stats: PARTIAL
diff --git
a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out
b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out
index 2a8a7ce94de..7e21ae0d105 100644
---
a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out
+++
b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization_acid2.q.out
@@ -72,7 +72,7 @@ STAGE PLANS:
Statistics: Num rows: 2000 Data size: 732000 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type: int),
_bucket_number (type: string), _col1 (type: string)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col2 (type: string), _col3
(type: int)
Statistics: Num rows: 2000 Data size: 732000 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/expanding_multivaluecolvector.q.out
b/ql/src/test/results/clientpositive/llap/expanding_multivaluecolvector.q.out
index 2325119c76d..fdae05a85aa 100644
---
a/ql/src/test/results/clientpositive/llap/expanding_multivaluecolvector.q.out
+++
b/ql/src/test/results/clientpositive/llap/expanding_multivaluecolvector.q.out
@@ -217,7 +217,7 @@ STAGE PLANS:
Statistics: Num rows: 4534 Data size: 1526284 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Reduce Sink Vectorization:
@@ -251,7 +251,7 @@ STAGE PLANS:
Reduce Vectorization:
enabled: true
enableConditionsMet: hive.vectorized.execution.reduce.enabled
IS true, hive.execution.engine tez IN [tez] IS true
- reduceColumnNullOrder: a
+ reduceColumnNullOrder: z
reduceColumnSortOrder: +
allNative: false
usesVectorUDFAdaptor: false
diff --git
a/ql/src/test/results/clientpositive/llap/infer_bucket_sort_num_buckets.q.out
b/ql/src/test/results/clientpositive/llap/infer_bucket_sort_num_buckets.q.out
index f715d92f612..1f1c6791d34 100644
---
a/ql/src/test/results/clientpositive/llap/infer_bucket_sort_num_buckets.q.out
+++
b/ql/src/test/results/clientpositive/llap/infer_bucket_sort_num_buckets.q.out
@@ -159,7 +159,7 @@ STAGE PLANS:
Reduce Output Operator
bucketingVersion: 2
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
numBuckets: -1
sort order: +
Map-reduce partition columns: _col2 (type: string)
diff --git
a/ql/src/test/results/clientpositive/llap/insert_overwrite_preemption.q.out
b/ql/src/test/results/clientpositive/llap/insert_overwrite_preemption.q.out
index 3f60aad2b91..dc68ebe3b21 100644
--- a/ql/src/test/results/clientpositive/llap/insert_overwrite_preemption.q.out
+++ b/ql/src/test/results/clientpositive/llap/insert_overwrite_preemption.q.out
@@ -64,7 +64,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 368 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 1 Data size: 368 Basic stats:
COMPLETE Column stats: NONE
diff --git a/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out
b/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out
index 1fb21224663..cc442a7a331 100644
--- a/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out
+++ b/ql/src/test/results/clientpositive/llap/load_data_using_job.q.out
@@ -223,7 +223,7 @@ STAGE PLANS:
Statistics: Num rows: 67 Data size: 24180 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 67 Data size: 24180 Basic stats:
COMPLETE Column stats: NONE
@@ -455,7 +455,7 @@ STAGE PLANS:
Statistics: Num rows: 73 Data size: 26696 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type: int)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: int)
Statistics: Num rows: 73 Data size: 26696 Basic stats:
COMPLETE Column stats: NONE
@@ -693,7 +693,7 @@ STAGE PLANS:
Statistics: Num rows: 146 Data size: 52640 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type: int)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: int)
Statistics: Num rows: 146 Data size: 52640 Basic stats:
COMPLETE Column stats: NONE
@@ -1276,7 +1276,7 @@ STAGE PLANS:
Statistics: Num rows: 67 Data size: 24180 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _bucket_number
(type: string), _col0 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 67 Data size: 24180 Basic stats:
COMPLETE Column stats: NONE
@@ -1508,7 +1508,7 @@ STAGE PLANS:
Statistics: Num rows: 73 Data size: 26696 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
int), _bucket_number (type: string), _col0 (type: int)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: int)
Statistics: Num rows: 73 Data size: 26696 Basic stats:
COMPLETE Column stats: NONE
@@ -1746,7 +1746,7 @@ STAGE PLANS:
Statistics: Num rows: 146 Data size: 52640 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
int), _bucket_number (type: string), _col0 (type: int)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: int)
Statistics: Num rows: 146 Data size: 52640 Basic stats:
COMPLETE Column stats: NONE
@@ -2102,7 +2102,7 @@ STAGE PLANS:
Statistics: Num rows: 292 Data size: 104904 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
int), _bucket_number (type: string), _col0 (type: int)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: int)
Statistics: Num rows: 292 Data size: 104904 Basic stats:
COMPLETE Column stats: NONE
@@ -2694,7 +2694,7 @@ STAGE PLANS:
Statistics: Num rows: 73 Data size: 26696 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: int), _bucket_number
(type: string), _col0 (type: int), _col1 (type: string)
- null sort order: aaaa
+ null sort order: zzzz
sort order: ++++
Map-reduce partition columns: _col3 (type: int)
Statistics: Num rows: 73 Data size: 26696 Basic stats:
COMPLETE Column stats: NONE
@@ -2937,7 +2937,7 @@ STAGE PLANS:
Statistics: Num rows: 67 Data size: 24180 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 67 Data size: 24180 Basic stats:
COMPLETE Column stats: NONE
@@ -3173,7 +3173,7 @@ STAGE PLANS:
Statistics: Num rows: 24 Data size: 9024 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: int)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col3 (type: int)
Statistics: Num rows: 24 Data size: 9024 Basic stats:
COMPLETE Column stats: NONE
diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out
b/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out
index 57987cf72df..4bf74f0b9a1 100644
--- a/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out
+++ b/ql/src/test/results/clientpositive/llap/load_dyn_part5.q.out
@@ -56,7 +56,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 89000 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 500 Data size: 89000 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/load_static_ptn_into_bucketed_table.q.out
b/ql/src/test/results/clientpositive/llap/load_static_ptn_into_bucketed_table.q.out
index 5ab5ab1c272..d86dc56cce0 100644
---
a/ql/src/test/results/clientpositive/llap/load_static_ptn_into_bucketed_table.q.out
+++
b/ql/src/test/results/clientpositive/llap/load_static_ptn_into_bucketed_table.q.out
@@ -269,7 +269,7 @@ STAGE PLANS:
Statistics: Num rows: 34 Data size: 12648 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _bucket_number
(type: string), _col0 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 34 Data size: 12648 Basic stats:
COMPLETE Column stats: NONE
@@ -500,7 +500,7 @@ STAGE PLANS:
Statistics: Num rows: 67 Data size: 24180 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string), _bucket_number
(type: string), _col0 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 67 Data size: 24180 Basic stats:
COMPLETE Column stats: NONE
diff --git
a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out
b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out
index 11dde3c0bd2..cd46375d245 100644
---
a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out
+++
b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned.q.out
@@ -60,7 +60,7 @@ STAGE PLANS:
Statistics: Num rows: 55 Data size: 9790 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 55 Data size: 9790 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -660,7 +660,7 @@ STAGE PLANS:
Statistics: Num rows: 18 Data size: 3240 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 18 Data size: 3240 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1044,7 +1044,7 @@ STAGE PLANS:
Statistics: Num rows: 18 Data size: 3258 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 18 Data size: 3258 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -1154,11 +1154,11 @@ POSTHOOK: Input: default@partition_mv_3
POSTHOOK: Input: default@partition_mv_3@key=238
#### A masked pattern was here ####
val_238_n 238
-val_238_n 238
val_238 238
val_238 238
val_238 238
val_238 238
+val_238_n 238
val_238_n2 238
val_238_n2 238
PREHOOK: query: DROP MATERIALIZED VIEW partition_mv_1
diff --git
a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out
b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out
index 4125e622e8a..1882d25fb02 100644
---
a/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out
+++
b/ql/src/test/results/clientpositive/llap/materialized_view_partitioned_3.q.out
@@ -60,7 +60,7 @@ STAGE PLANS:
Statistics: Num rows: 55 Data size: 9790 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 55 Data size: 9790 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/merge_dynamic_partition.q.out
b/ql/src/test/results/clientpositive/llap/merge_dynamic_partition.q.out
index 65cc5b92ab6..552d084649c 100644
--- a/ql/src/test/results/clientpositive/llap/merge_dynamic_partition.q.out
+++ b/ql/src/test/results/clientpositive/llap/merge_dynamic_partition.q.out
@@ -85,7 +85,7 @@ STAGE PLANS:
Statistics: Num rows: 98 Data size: 49312 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 98 Data size: 49312 Basic stats:
PARTIAL Column stats: PARTIAL
@@ -1396,7 +1396,7 @@ STAGE PLANS:
Statistics: Num rows: 98 Data size: 49312 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 98 Data size: 49312 Basic stats:
PARTIAL Column stats: PARTIAL
diff --git
a/ql/src/test/results/clientpositive/llap/merge_dynamic_partition2.q.out
b/ql/src/test/results/clientpositive/llap/merge_dynamic_partition2.q.out
index 69d4cd60756..e4c0664a4a0 100644
--- a/ql/src/test/results/clientpositive/llap/merge_dynamic_partition2.q.out
+++ b/ql/src/test/results/clientpositive/llap/merge_dynamic_partition2.q.out
@@ -104,7 +104,7 @@ STAGE PLANS:
Statistics: Num rows: 295 Data size: 147384 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 295 Data size: 147384 Basic stats:
PARTIAL Column stats: PARTIAL
diff --git
a/ql/src/test/results/clientpositive/llap/merge_dynamic_partition3.q.out
b/ql/src/test/results/clientpositive/llap/merge_dynamic_partition3.q.out
index dc2eb0b86cb..497ff02e9f4 100644
--- a/ql/src/test/results/clientpositive/llap/merge_dynamic_partition3.q.out
+++ b/ql/src/test/results/clientpositive/llap/merge_dynamic_partition3.q.out
@@ -169,7 +169,7 @@ STAGE PLANS:
Statistics: Num rows: 590 Data size: 402592 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 590 Data size: 402592 Basic stats:
PARTIAL Column stats: PARTIAL
diff --git a/ql/src/test/results/clientpositive/llap/mm_dp.q.out
b/ql/src/test/results/clientpositive/llap/mm_dp.q.out
index 303d751d99c..da859827233 100644
--- a/ql/src/test/results/clientpositive/llap/mm_dp.q.out
+++ b/ql/src/test/results/clientpositive/llap/mm_dp.q.out
@@ -153,7 +153,7 @@ STAGE PLANS:
Statistics: Num rows: 2605 Data size: 268315 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col3 (type: string), _bucket_number
(type: string), _col2 (type: int)
- null sort order: aaa
+ null sort order: zzz
sort order: +++
Map-reduce partition columns: _col3 (type: string)
Statistics: Num rows: 2605 Data size: 268315 Basic
stats: COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/murmur_hash_migration2.q.out
b/ql/src/test/results/clientpositive/llap/murmur_hash_migration2.q.out
index 4ae92ba8b8c..93699916ded 100644
--- a/ql/src/test/results/clientpositive/llap/murmur_hash_migration2.q.out
+++ b/ql/src/test/results/clientpositive/llap/murmur_hash_migration2.q.out
@@ -55,7 +55,7 @@ STAGE PLANS:
Reduce Output Operator
bucketingVersion: 1
key expressions: _col2 (type: string),
_bucket_number (type: string), _col0 (type: int)
- null sort order: aaa
+ null sort order: zzz
numBuckets: 2
sort order: +++
Map-reduce partition columns: _col2 (type: string)
diff --git a/ql/src/test/results/clientpositive/llap/orc_merge10.q.out
b/ql/src/test/results/clientpositive/llap/orc_merge10.q.out
index 97550a14424..be327966b7e 100644
--- a/ql/src/test/results/clientpositive/llap/orc_merge10.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_merge10.q.out
@@ -85,7 +85,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -233,7 +233,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -426,7 +426,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git a/ql/src/test/results/clientpositive/llap/orc_merge2.q.out
b/ql/src/test/results/clientpositive/llap/orc_merge2.q.out
index b64688bafd6..a4c700ed715 100644
--- a/ql/src/test/results/clientpositive/llap/orc_merge2.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_merge2.q.out
@@ -55,7 +55,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 231500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 500 Data size: 231500 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git a/ql/src/test/results/clientpositive/llap/orc_merge7.q.out
b/ql/src/test/results/clientpositive/llap/orc_merge7.q.out
index eafa65c8ef7..ac67b6f557d 100644
--- a/ql/src/test/results/clientpositive/llap/orc_merge7.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_merge7.q.out
@@ -56,7 +56,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 352 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col5 (type: double)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col5 (type: double)
Statistics: Num rows: 1 Data size: 352 Basic stats:
COMPLETE Column stats: NONE
@@ -296,7 +296,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 352 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col5 (type: double)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col5 (type: double)
Statistics: Num rows: 1 Data size: 352 Basic stats:
COMPLETE Column stats: NONE
diff --git a/ql/src/test/results/clientpositive/llap/orc_merge_diff_fs.q.out
b/ql/src/test/results/clientpositive/llap/orc_merge_diff_fs.q.out
index d88a143f25e..6a4d047aabb 100644
--- a/ql/src/test/results/clientpositive/llap/orc_merge_diff_fs.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_merge_diff_fs.q.out
@@ -85,7 +85,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -233,7 +233,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
@@ -426,7 +426,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 500 Data size: 139500 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git a/ql/src/test/results/clientpositive/llap/orc_merge_incompat2.q.out
b/ql/src/test/results/clientpositive/llap/orc_merge_incompat2.q.out
index daf54c2eb7c..641ee5c1484 100644
--- a/ql/src/test/results/clientpositive/llap/orc_merge_incompat2.q.out
+++ b/ql/src/test/results/clientpositive/llap/orc_merge_incompat2.q.out
@@ -56,7 +56,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 352 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col5 (type: double)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col5 (type: double)
Statistics: Num rows: 1 Data size: 352 Basic stats:
COMPLETE Column stats: NONE
diff --git a/ql/src/test/results/clientpositive/llap/partition_ctas.q.out
b/ql/src/test/results/clientpositive/llap/partition_ctas.q.out
index b5eaac6b86c..00d758c22e9 100644
--- a/ql/src/test/results/clientpositive/llap/partition_ctas.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_ctas.q.out
@@ -45,7 +45,7 @@ STAGE PLANS:
Statistics: Num rows: 55 Data size: 9790 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 55 Data size: 9790 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
b/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
index a10fd5fa040..2319466ef98 100644
--- a/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
@@ -901,55 +901,55 @@ ALTER TABLE `db_bdpbase`.`default_partition_test`
PARTITION (`sports`='Tennis')
-- ALTER TABLE `db_bdpbase`.`default_partition_test` ADD IF NOT EXISTS
PARTITION (`sports`='__HIVE_DEFAULT_PARTITION__');
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS
SET('numRows'='6','rawDataSize'='247' );
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='7.961538461538462','maxColLen'='15','numNulls'='0','numDVs'='26'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoagcnkoQHDmv3pA/6E55gChOm3qP//////AbzE6Yj7/////wH/jeLHAYC7qMgEgO/pvP//////AYDl7q35/////wHAnoCTBsDeqIT+/////wGArM7x//////8BwdCEL//10sL+/////wGB/Yxrv/G7V8HV1cT7/////wGA/62HA4C7sfsBwJT/rPr/////AYCFgrIBgbbW6P//////Ab707dv//////wGEkeKsBYLSvzy6mZuX+v////8B
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoagcnkoQHDmv3pA/6E55gChOm3qP//////AbzE6Yj7/////wH/jeLHAYC7qMgEgO/pvP//////AYDl7q35/////wHAnoCTBsDeqIT+/////wGArM7x//////8BwdCEL//10sL+/////wGBxJ6H/f////8BgLnu4wO/8btXwdSDzP7/////AYC7sfsBwJT/rPr/////AYCFgrIBgbbW6P//////Ab707dv//////wGEkeKsBYLSvzy6mZuX+v////8B
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='10.038461538461538','maxColLen'='44','numNulls'='0','numDVs'='26'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoahbLBzAP85PKJ/f////8BwLe62gLD4vSXAYGN3q0B/6Xhi/r/////Ab2osqUFwqq+oQH+tdPa+v////8BgPenYoCwhkKAndeXA4Sn15/+/////wH+le6UAr/epnP/7bOp+v////8BgKHJV4DwkcACg4u68wGB85+S/f////8B/JyLowOAs7kWgYmk8fr/////Af/OrLoDgO721P//////AYGQ3sD7/////wE=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoahbLBzAO8nK3k//////8BwMjFpf3/////AYOar/IDgY3erQH/peGL+v////8B/9Lwxga+1cHe/v////8BwNe53vz/////AYCJ2J3//////wGAp66kAYCd15cDhKfXn/7/////Af6V7pQCv96mc//ts6n6/////wGAkduXA4OLuvMB/YS0zPv/////AYTu68UB/JyLowOAs7kWgYmk8fr/////Af/OrLoDgf7Ulfv/////Af/vob8E
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.615384615384615','maxColLen'='8','numNulls'='0','numDVs'='25'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBkZyJCAxAK5lvTQBMDlqKP5/////wHAl7CAA8CbmRzA8faZ/f////8Bgf/q/f//////Ab/LlfIGgNTwqvz/////AcDcuH6Ay4aWAoDC4QXA6L+q/f////8BwPv+XoDLzxPAzvF9waDs/Pz/////AcCQvbL+/////wHAuJKC//////8Bv8CUgAXAzNZPw+WL8vz/////AYD4gCH9tourAcPksWU=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBkZyJCAxAK5lvTQBMDlqKP5/////wHAl7CAA4CNkLb9/////wHAjonmAsHw4Zf9/////wG/y5XyBoDU8Kr8/////wHA3Lh+gMuGlgKAwuEFwOi/qv3/////AcD7/l6Ay88TwM7xfcGg7Pz8/////wGAyc+0/f////8BwMftff/4poIEwMzWT8PdjJP9/////wGAiP/e//////8B/a6MzAHD5LFl
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1004','highValue'='1094','numNulls'='0','numDVs'='26' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBoahd3Cdf32590G/6SLj/3/////AYCykT7Av92e/f////8BwYfGqwP/9oKWAYD4z638/////wGBwrxzv+i89wHA0Niv/f////8BgLL2rgGAstnL+/////8BguuQrAH+1vPaBMG99/D5/////wH//4P6BcDSr2WAnKXH/P////8BgKfB3P3/////AYCTgJEEgqb8+Pv/////AcCCvmq+0O7IAoDBhvb+/////wHA0dlC
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBoahd3Cdf32590G/6SLj/3/////AYCykT7Av92e/f////8BwYfGqwP/9oKWAYD4z638/////wGBwrxzv+i89wHA0Niv/f////8BgLL2rgGA9N3SAYKpjKX7/////wH+lO/T/v////8Bwf/79///////Af//g/oFwNKvZYCcpcf8/////wGAp8Hc/f////8BgJOAkQTCqLrj/P////8BwP3Blf//////Af7SrLMDwJLguP//////AcCupr3//////wE=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.269230769230769','maxColLen'='9','numNulls'='0','numDVs'='26'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoaw5bxWsDKgKgE/pbs5vz/////AYDw18AEguubl/3/////AcHBj579/////wH9pu6ABYKuotL+/////wH+x+S0//////8BgMj+2QLAjorG+f////8BwJm1pwLBgbeMBL/BgaD8/////wHAuJDKA4CXh93//////wHBuPXl+v////8B//SC/wWAweCB//////8BwMTBhv7/////AYC+l/cBwI3g1fr/////AYTay4cBvtbOsAL//sj+A8Hd+ZH4/////wE=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Badminton' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBoaw5bxWsDKgKgE/pbs5vz/////AYDw18AEguubl/3/////AcHBj579/////wH9pu6ABYKuotL+/////wH+x+S0//////8BwNaIoPz/////AcDx9bkGgKi/7fv/////AcGBt4wEv8GBoPz/////AcC4kMoDgJeH3f//////AcG49eX6/////wH/9IL/BYDB4IH//////wHAxMGG/v////8BgL6X9wHAjeDV+v////8BhNrLhwG+1s6wAv/+yP4Dwd35kfj/////AQ==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='9.733333333333333','maxColLen'='26','numNulls'='0','numDVs'='15'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgZjVoAbAiv9ng+yLbv3bzYP8/////wGFitRK/MrIowP/zYSG+/////8BwvzCl/7/////Af+jp8UBv+6Ctf//////AYGf/9wDv6/ZgQLCvb65+f////8BvsGr/QKAtqUo
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgZjVoAbAiv9ng+yLbv3bzYP8/////wGB1ZzuA4S1t9z8/////wH7mM2p/v////8BwvzCl/7/////Ab+xqdcEwPL97fz/////Ab/ugrX//////wHAztjeBcK9vrn5/////wG+wav9AoC2pSg=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='8.666666666666666','maxColLen'='16','numNulls'='0','numDVs'='14'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OhdzCtAL8jYW5A8Ce5MX6/////wHAicoqgNKYqAGA+cYigKy/jwGB3qTH/f////8BgNG/hwLDkchH/YOnjf//////Af/knsj9/////wHA+9/oBICtjo7//////wE=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OgerH7QWE8vrG/P////8BvKzp/v3/////AcCJyiqA0pioAYClhrIBgNTA8P7/////AYGK5Nb+/////wGA0b+HAsORyEf9g6eN//////8B/+SeyP3/////AcD73+gEgK2Ojv//////AQ==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='6.466666666666667','maxColLen'='9','numNulls'='0','numDVs'='15'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET.
THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgbilpAeC7+ssvtnsxfj/////AcCW6PAFwLLw9f7/////AcHwo4v9/////wH/nYz3AoGH1J/9/////wH/7Jv7/f////8BxNrM2wK85uvN/v////8BgJnvHMCdv9b//////wGAw7/oBcLAloD5/////wE=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET.
THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgbilpAeC7+ssvtnsxfj/////AYDJ2OYEwM2PigGAwaD4/v////8BgeLziP3/////AYCl4Bb/7Jv7/f////8BxNrM2wK85uvN/v////8BwLau8///////AcDiwCnA4P6+BcLAloD5/////wE=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1001','highValue'='1097','numNulls'='0','numDVs'='15' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgYCNxQOA2pic/f////8BxuPc2AP8m7G4A7+Ix+z7/////wG/xNKo/f////8BgLCJswSAxK+U/f////8BgPmo2gHE6pNr/pSPjQK+4MTY+v////8BgIiW4ASEgZT0+/////8B/OCGvQE=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgYCNxQOA2pic/f////8BxuPc2AP8m7G4A7+Ix+z7/////wG/xNKo/f////8BgLCJswSAxK+U/f////8BgPmo2gHE6pNr/pSPjQK+6Nq4//////8BgPjpn/v/////AYDqsJEChJ/5wv7/////AQ==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.2','maxColLen'='8','numNulls'='0','numDVs'='15' );
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Basketball' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA8PgZ/tvgSA18jgAoGZwtb+/////wH/zaeIAcDWpIP//////wGC/43R+/////8B/5/ogwGDhYerAfz89K4DgL6l8v7/////AYDwwZj//////wHAlpaV/f////8BgLqSK8GJg9D9/////wHCiZiWAw==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='9.5','maxColLen'='18','numNulls'='0','numDVs'='14' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA4Owv2KsweAxJ3Y+f////8Bv7aO5QaAo7XI+v////8BwM6p9/3/////AcCGkuoBwYfi6f//////Ab/3+6ICxPu9zwP90YX2//////8BgpXXv/j/////Af3c9qcEgZnkk/z/////Af/BmTE=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA4Owv2KsweAxJ3Y+f////8Bv7aO5QaAo7XI+v////8BwM6p9/3/////AcCF8PYDgIGi8/3/////AcGH4un//////wGD87nyBf3Rhfb//////wGClde/+P////8B/dz2pwSBmeST/P////8B/8GZMQ==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.714285714285714','maxColLen'='18','numNulls'='0','numDVs'='14'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OwanPogfEsvOR+/////8B/M6b8AKCibP3/f////8Bvprl2gLB+fLA//////8B/7zUlv7/////AcXwxLz+/////wG7+JuG/v////8BgPWXlAHB1KGNAv/45vkDwvKSh/n/////AYSysbYC
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OhdzCtAK8zYzuBMCBj4L+/////wHAo5hSwuWapf3/////Af+T2JsC/7zUlv7/////AcXwxLz+/////wG77bOa//////8BgIvo6/7/////AcHJuaED//jm+QPC8pKH+f////8BhLKxtgI=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.285714285714286','maxColLen'='9','numNulls'='0','numDVs'='14'
);
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OwbS80wOB6fyi/f////8B/4eU6QKB+P2a/f////8Bw7z4qQT8+8KdAsKaipb9/////wH/pLfZ//////8Bg/367/3/////Af72zOj//////wG+8a95gvbxuf3/////Ab7LzcwFwNTv8Pz/////AQ==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1002','highValue'='1099','numNulls'='0','numDVs'='14' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA4Owp+5vgXAgIGC+/////8B/6frowTArIixAcCvrknA3Jmv//////8BgIHmBoGA38n6/////wHAhO5lgs76yAG+9dT6Ar+cjO36/////wGAx7GYBML+3Mj8/////wE=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoA4OgqC6QMD//v0Ev6jspf//////AcCsiLEBwK+uScDcma///////wGAgeYGgYDfyfr/////AcLS6K4C/rGFt/7/////AcDDz8MEv5yM7fr/////AcLFjmG+gaO3Aw==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.642857142857143','maxColLen'='10','numNulls'='0','numDVs'='14'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4Oh/eB3gH6kIqEBoDm49H7/////wGBzfvyAcDCzlTC2eaU/P////8B/q3H8v3/////Af+bxdoFgJL6jPv/////AYG84W//1I1igqC6pwH+kKX+/v////8Bwr362gQ=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Cricket' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoA4OgYiM4geG7/X7+f////8B+8PpyAP/soSN/v////8Bg+mw3P7/////Ab6mmesDwIeuh/r/////Af+bxdoFgJL6jPv/////AYG84W//1I1igqC6pwH+kKX+/v////8Bwr362gQ=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='8.782608695652174','maxColLen'='20','numNulls'='0','numDVs'='23'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXw7/xvgW/vaexAoD6oqj6/////wHBqdfw//////8BvuPJ1P7/////AYCN2LgDwaXjsv3/////Af+IxJcGwbyujvv/////Af+ttFnBqYmkA7+Yrqb7/////wHAgr+LBIGHpJP9/////wH/iY3oAYDAj7/8/////wGAie6wAYD20A3Cw5oi/ozl0QKAl+LVAcHRpASBoNS9//////8B
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXw7/xvgW/vaexAoD6oqj6/////wHBqdfw//////8BvuPJ1P7/////AYCN2LgDwaXjsv3/////Af+IxJcGwbyujvv/////Af+ttFnBqYmkA7+Yrqb7/////wHAgr+LBIDRwLr7/////wGAwPDAA4H28pf+/////wH/0orY//////8BgPbQDcLDmiL+jOXRAoCX4tUBwdGkBIGg1L3//////wE=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='10.826086956521738','maxColLen'='33','numNulls'='0','numDVs'='22'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBYWw66T/gX/gadGwYr4n/3/////AYG57zXAkP/9+/////8BvbWmigfB/KHo+v////8BwYzq0gS/zsX3/f////8B//i05Pz/////AcG9m/4D//vz0fz/////AcCqpx3AxKqpAcCF+PACgIGGwPv/////AYSQlM0B/fqH6v//////Af+1/M38/////wGCp8si/pO8vQKC4MSEAQ==
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBYWw66T/gX/gadGwYr4n/3/////AYG57zX9xaWIA8PK2fX4/////wH+scjyAcGM6tIEvsf62/r/////AYGHy5sDwLbQYv/789H8/////wHAqqcdwMSqqQHAhfjwAoCBhsD7/////wGEkJTNAf36h+r//////wH/tfzN/P////8BgqfLIv6TvL0CguDEhAE=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.782608695652174','maxColLen'='9','numNulls'='0','numDVs'='23'
);
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXwbS80wPA08+OBMDEmZT6/////wHA7fi1BMLU84kBvs2zyfr/////AcDRiGfCgsLrA4DDgsb9/////wG+ipqK/v////8BwMjJowWC5Jyw//////8Bv5j19Pn/////AYDBosL//////wHA9t7fAb/QhPkDgJCxk/v/////AYKK0Qb+ra2ZAoOA5Pj//////wH9vuKJAcH15av8/////wGA1v/hAg==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1006','highValue'='1100','numNulls'='0','numDVs'='23' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBcXgaCXhwXA1P+S/f////8Bg93J8wG91quf/P////8Bg8OW9gG9v/KA//////8Bhbns+AW7mZtJwM2xGcCm2JD7/////wHAzv2WAsDMyob9/////wHCpeL4/v////8Bv4iY4wW/56Sb+f////8BgLbX1QHB2tTlBP+Sqp36/////wGA9fLJAcGhkpcBgIXC0QPBxYbz//////8B/uGZ+vv/////AQ==
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBcXgaCXhwXA1P+S/f////8Bg93J8wG91quf/P////8BwIKJd8PAjX/C+N75BLuZm0nAzbEZwKbYkPv/////AcDO/ZYCwMzKhv3/////AYGu+tsEwffnnPr/////Af7vvP7+/////wGAttfVAcHa1OUE/5Kqnfr/////AYD18skBwaGSlwGAhcLRA8HFhvP//////wH+4Zn6+/////8B
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Football') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='5.6521739130434785','maxColLen'='8','numNulls'='0','numDVs'='23'
);
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXgqW6lwS/7cK2AsGpjOz7/////wGCm5fW//////8BvbT96wTA5rbf/P////8Bgoq+hwO/6qXp/P////8B/8GzqP7/////AcCqq+L//////wGA5PWu/v////8Bwa37xwa/u+SQ/P////8Bwcrsrf3/////Ab+2k+ADgNahiAHAyNff/v////8BwNftnP7/////AYDDkyfB/tKCA4DswM8Bgoeop/3/////Af3g8/oB
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Football' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBcXgqW6lwS/7cK2AsGpjOz7/////wGCm5fW//////8B/6Ty0gS+j4sZwOa23/z/////AcH04/D//////wH/wbOo/v////8BwI6hkf7/////AYCcitEBwZHx9gS/u+SQ/P////8Bwcrsrf3/////Ab+2k+ADgNahiAHAyNff/v////8BwNftnP7/////AYDDkyfB/tKCA4DswM8Bgoeop/3/////Af3g8/oB
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='9.5625','maxColLen'='18','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBAQgfSH0gPAg7CJAoCl9ljC0YLK//////8B/picz/7/////AcDlwtP7/////wHAl84twIbP+v//////AYCoomaApeWJBoG1lab6/////wH/sNr5AoDjqJr8/////wHBz+68BcCH7fb9/////wH/+7xK
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `city` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBAQgfSH0gPAg7CJAsL2+CK+rv01wOqemf7/////AcDlwtP7/////wHAl84twIbP+v//////AYCoomaApeWJBoG1lab6/////wH/sNr5AsGyl9cBv7CRw/r/////AYHX27MD//u8Sg==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.5625','maxColLen'='27','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQweClxwTAto6P/P////8Bg5qv8gO9nZOuAYWnjJT8/////wH7y9SkAoD13gGBtJOV/v////8BgqrYtf7/////Af3z25EEgbjb3wK/2Jud//////8BgZbmgvr/////Af+XtN4Dga/pvP//////AcH6mY8B
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `country` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQweClxwTAto6P/P////8Bg5qv8gO9nZOuAYWnjJT8/////wH7y9SkAoD13gGBtJOV/v////8Bv66rxATBp+RigtTIjvn/////Af3z25EEwabd//v/////AYDHnZsD/9CWQ8Kpg0w=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `firstname`
SET('avgColLen'='5.875','maxColLen'='10','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQgp+Lswf/6/Gw+/////8BgM2YkAPB0+LF/f////8B/8ulC8DngZ0CgJ+o9v//////AcDR9AWBwp7N+v////8BwZT4/QH/qIfj//////8BgP+t//3/////Ab+a5YgDxoiV3QK8+K/t/v////8Bgdruk/7/////AQ==
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQgYv94wKBlI7PBP+4isH+/////wHB0+LF/f////8B/8ulC8DngZ0CwPCc/P//////AcCui/r//////wHBk5PT+v////8BwZT4/QH/qIfj//////8BgP+t//3/////AYWj+uUFuvfqov3/////AYKBxcoBgdruk/7/////AQ==
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1007','highValue'='1086','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBAQgsirL7+NuZgFgJSyrf7/////AcDw1/3//////wGAw9/iAoGurff//////wH//tG+/v////8BhMDytf//////Abya/vb+/////wHCpbPM//////8B/v+D1v7/////AcD2p9r//////wGApJdwwLKYgQTByo7U//////8BwdS26vv/////AQ==
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64
VALUE FOR THE BITVECTOR IS
SExMoBAQgsirL7+NuZgFgJSyrf7/////AcDw1/3//////wGB8YzaAv/R0giArf+1/v////8BhMDytf//////Abya/vb+/////wHCpbPM//////8B/v+D1v7/////AcD2p9r//////wGApJdwwLKYgQSCn8W++/////8Bv6vJlQQ=
ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.625','maxColLen'='10','numNulls'='0','numDVs'='16' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQw9jy4wbApZ6a/v////8B/sPU3fv/////AcCHp9kGgN/fv/r/////AYLFxPn+/////wGBkrK3Av2Ry8cCgc676Pv/////Ab/A89YBxOTiEvzixO/+/////wHD55ygA77R9+T6/////wHFq+mVB7vOpY39/////wE=
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='Tennis' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE
BASE64 VALUE FOR THE BITVECTOR IS
SExMoBAQw9jy4wbApZ6a/v////8Bvsv7tgLA+Nim+f////8BwOaGmQGCxcT5/v////8BgZKytwL+34aw/v////8B/7HElwTAjq+//f////8BxOTiEvzixO/+/////wHD55ygA77R9+T6/////wHFq+mVB7vOpY39/////wE=
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `city`
SET('avgColLen'='10.5','maxColLen'='17','numNulls'='0','numDVs'='6' );
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `city` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGwaGlyQKAyt+3AYCs6oQBwt6jv/7/////Af/P9r4C//fig/v/////AQ==
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `country`
SET('avgColLen'='9.333333333333334','maxColLen'='15','numNulls'='0','numDVs'='6'
);
@@ -957,7 +957,7 @@ ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='Tennis')
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN
`firstname` SET('avgColLen'='7.0','maxColLen'='9','numNulls'='0','numDVs'='6' );
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `firstname` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGwe3GFsGq05QBv6XU8P7/////AYHCq/AGwJ7v2Pr/////AcG15yw=
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `id`
SET('lowValue'='1005','highValue'='1098','numNulls'='0','numDVs'='6' );
--- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `id` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGgeXMkgKAqeDgAYDOgWfAjve+/P////8Bga6jv///////Af/B69cD
+-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `id` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGgeXMkgKAqeDgAYDOgWfAjve+/P////8BgPCOlwOBvpSo/P////8B
-- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION
(`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `lastname`
SET('avgColLen'='6.333333333333333','maxColLen'='8','numNulls'='0','numDVs'='6'
);
-- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION
`sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `lastname` BUT THEY ARE NOT
SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS
SExMoAYGgbePuQfB9sjg+P////8Bw93qogW83dm9/P////8BwYbtqQK/yYTa/v////8B
diff --git
a/ql/src/test/results/clientpositive/llap/partitions_cols_dedup.q.out
b/ql/src/test/results/clientpositive/llap/partitions_cols_dedup.q.out
index 92f7e2476eb..5791f3f732c 100644
--- a/ql/src/test/results/clientpositive/llap/partitions_cols_dedup.q.out
+++ b/ql/src/test/results/clientpositive/llap/partitions_cols_dedup.q.out
@@ -107,10 +107,10 @@ POSTHOOK: query: select * from ctas_table_1
POSTHOOK: type: QUERY
POSTHOOK: Input: partition_cols_dedup@ctas_table_1
#### A masked pattern was here ####
-2 2 2 2222 222 22
3 3 3 3333 333 33
-4 4 4 4444 444 44
1 1 1 1111 111 11
+2 2 2 2222 222 22
+4 4 4 4444 444 44
5 5 5 5555 555 55
PREHOOK: query: create table insert_overwrite_table (c1 int, c2 int)
partitioned by (p1 int, p2 int)
PREHOOK: type: CREATETABLE
diff --git a/ql/src/test/results/clientpositive/llap/rcfile_merge2.q.out
b/ql/src/test/results/clientpositive/llap/rcfile_merge2.q.out
index bec36b0c90e..d01c50ffa79 100644
--- a/ql/src/test/results/clientpositive/llap/rcfile_merge2.q.out
+++ b/ql/src/test/results/clientpositive/llap/rcfile_merge2.q.out
@@ -55,7 +55,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 231500 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 500 Data size: 231500 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition.q.out
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition.q.out
index 329f9097ec2..702edf4b5d6 100644
---
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition.q.out
+++
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition.q.out
@@ -84,7 +84,7 @@ STAGE PLANS:
Statistics: Num rows: 98 Data size: 49312 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 98 Data size: 49312 Basic stats:
PARTIAL Column stats: PARTIAL
@@ -1352,7 +1352,7 @@ STAGE PLANS:
Statistics: Num rows: 98 Data size: 49312 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 98 Data size: 49312 Basic stats:
PARTIAL Column stats: PARTIAL
diff --git
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition2.q.out
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition2.q.out
index ca1b875328c..19dc837378c 100644
---
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition2.q.out
+++
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition2.q.out
@@ -103,7 +103,7 @@ STAGE PLANS:
Statistics: Num rows: 295 Data size: 147384 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 295 Data size: 147384 Basic stats:
PARTIAL Column stats: PARTIAL
diff --git
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition3.q.out
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition3.q.out
index e68ed3e99dd..4f6a2b5f44f 100644
---
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition3.q.out
+++
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition3.q.out
@@ -168,7 +168,7 @@ STAGE PLANS:
Statistics: Num rows: 590 Data size: 402592 Basic stats:
PARTIAL Column stats: PARTIAL
Reduce Output Operator
key expressions: _col2 (type: string), _col3 (type:
string)
- null sort order: aa
+ null sort order: zz
sort order: ++
Map-reduce partition columns: _col2 (type: string),
_col3 (type: string)
Statistics: Num rows: 590 Data size: 402592 Basic stats:
PARTIAL Column stats: PARTIAL
diff --git
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition4.q.out
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition4.q.out
index 940b0651425..f28af261b25 100644
---
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition4.q.out
+++
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition4.q.out
@@ -164,7 +164,7 @@ STAGE PLANS:
Statistics: Num rows: 1000 Data size: 349968 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 1000 Data size: 349968 Basic
stats: COMPLETE Column stats: NONE
diff --git
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition5.q.out
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition5.q.out
index 3718eef72ef..d2179f22a53 100644
---
a/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition5.q.out
+++
b/ql/src/test/results/clientpositive/llap/temp_table_merge_dynamic_partition5.q.out
@@ -140,7 +140,7 @@ STAGE PLANS:
Statistics: Num rows: 618 Data size: 216752 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 618 Data size: 216752 Basic stats:
COMPLETE Column stats: NONE
diff --git
a/ql/src/test/results/clientpositive/llap/temp_table_partition_ctas.q.out
b/ql/src/test/results/clientpositive/llap/temp_table_partition_ctas.q.out
index cd284520d48..1e9ae008a50 100644
--- a/ql/src/test/results/clientpositive/llap/temp_table_partition_ctas.q.out
+++ b/ql/src/test/results/clientpositive/llap/temp_table_partition_ctas.q.out
@@ -44,7 +44,7 @@ STAGE PLANS:
Statistics: Num rows: 55 Data size: 9790 Basic stats:
COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 55 Data size: 9790 Basic stats:
COMPLETE Column stats: COMPLETE
diff --git a/ql/src/test/results/clientpositive/llap/union_remove_17.q.out
b/ql/src/test/results/clientpositive/llap/union_remove_17.q.out
index 96394568881..a60b014e444 100644
--- a/ql/src/test/results/clientpositive/llap/union_remove_17.q.out
+++ b/ql/src/test/results/clientpositive/llap/union_remove_17.q.out
@@ -74,7 +74,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 368 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 2 Data size: 368 Basic stats:
COMPLETE Column stats: NONE
@@ -96,7 +96,7 @@ STAGE PLANS:
Statistics: Num rows: 2 Data size: 368 Basic stats:
COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col2 (type: string)
- null sort order: a
+ null sort order: z
sort order: +
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 2 Data size: 368 Basic stats:
COMPLETE Column stats: NONE
