You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2017/09/20 19:38:32 UTC
[10/16] hive git commit: HIVE-17510: Make comparison of filter
predicates in q files deterministic (Jesus Camacho Rodriguez,
reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out b/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out
index 83cb6ca..c6c7d09 100644
--- a/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out
+++ b/ql/src/test/results/clientpositive/masking_disablecbo_3.q.out
@@ -603,7 +603,7 @@ STAGE PLANS:
alias: masking_test_subq
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
+ predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: UDFToDouble(key) (type: double), UDFToDouble(key) (type: double)
@@ -1177,7 +1177,7 @@ STAGE PLANS:
alias: masking_test_subq
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
+ predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: UDFToDouble(key) (type: double), UDFToDouble(key) (type: double)
@@ -1751,7 +1751,7 @@ STAGE PLANS:
alias: masking_test_subq
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
+ predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: UDFToDouble(key) (type: double), UDFToDouble(key) (type: double)
@@ -6571,7 +6571,7 @@ STAGE PLANS:
alias: masking_test_subq
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
+ predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: UDFToDouble(key) (type: double), UDFToDouble(key) (type: double)
@@ -7145,7 +7145,7 @@ STAGE PLANS:
alias: masking_test_subq
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (UDFToDouble(key) is not null and (key > 0)) (type: boolean)
+ predicate: ((key > 0) and UDFToDouble(key) is not null) (type: boolean)
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: UDFToDouble(key) (type: double), UDFToDouble(key) (type: double)
@@ -7719,7 +7719,7 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((key > 0) and (key < 10) and ((key % 2) = 0)) (type: boolean)
+ predicate: (((key % 2) = 0) and (key < 10) and (key > 0)) (type: boolean)
Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), upper(value) (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/materialized_view_create_rewrite.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/materialized_view_create_rewrite.q.out b/ql/src/test/results/clientpositive/materialized_view_create_rewrite.q.out
index 35e9a5d..f6b161b 100644
--- a/ql/src/test/results/clientpositive/materialized_view_create_rewrite.q.out
+++ b/ql/src/test/results/clientpositive/materialized_view_create_rewrite.q.out
@@ -157,7 +157,7 @@ STAGE PLANS:
alias: cmv_basetable
Statistics: Num rows: 5 Data size: 81 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((d = 3) and (3 = a)) (type: boolean)
+ predicate: ((3 = a) and (d = 3)) (type: boolean)
Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: c (type: decimal(10,2))
@@ -264,7 +264,7 @@ STAGE PLANS:
alias: cmv_basetable
Statistics: Num rows: 5 Data size: 81 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((d = 3) and (3 = a)) (type: boolean)
+ predicate: ((3 = a) and (d = 3)) (type: boolean)
Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: c (type: decimal(10,2))
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/multi_insert_gby.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_insert_gby.q.out b/ql/src/test/results/clientpositive/multi_insert_gby.q.out
index cb97e58..0ed05dd 100644
--- a/ql/src/test/results/clientpositive/multi_insert_gby.q.out
+++ b/ql/src/test/results/clientpositive/multi_insert_gby.q.out
@@ -41,7 +41,7 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((key > 500) or (key > 450)) (type: boolean)
+ predicate: ((key > 450) or (key > 500)) (type: boolean)
Statistics: Num rows: 332 Data size: 3527 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/multi_insert_gby4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_insert_gby4.q.out b/ql/src/test/results/clientpositive/multi_insert_gby4.q.out
index dd01b74..2f59665 100644
--- a/ql/src/test/results/clientpositive/multi_insert_gby4.q.out
+++ b/ql/src/test/results/clientpositive/multi_insert_gby4.q.out
@@ -61,7 +61,7 @@ STAGE PLANS:
outputColumnNames: _col0
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col0 > 490) or ((_col0 > 500) or (_col0 > 450))) (type: boolean)
+ predicate: (((_col0 > 500) or (_col0 > 450)) or (_col0 > 490)) (type: boolean)
Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out b/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
index af0ef54..3a8ec94 100644
--- a/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
+++ b/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
@@ -55,7 +55,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((key > 10) and (key < 20)) (type: boolean)
+ predicate: ((key < 20) and (key > 10)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -203,7 +203,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((key > 10) and (key < 20)) (type: boolean)
+ predicate: ((key < 20) and (key > 10)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -419,7 +419,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((key > 10) and (key < 20)) (type: boolean)
+ predicate: ((key < 20) and (key > 10)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -567,7 +567,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((key > 10) and (key < 20)) (type: boolean)
+ predicate: ((key < 20) and (key > 10)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -795,7 +795,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -949,7 +949,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -1171,7 +1171,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -1325,7 +1325,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -1537,7 +1537,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((_col0 > 10) and (_col0 < 20)) (type: boolean)
+ predicate: ((_col0 < 20) and (_col0 > 10)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1568,7 +1568,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((_col0 > 10) and (_col0 < 20)) (type: boolean)
+ predicate: ((_col0 < 20) and (_col0 > 10)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1733,7 +1733,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((_col0 > 10) and (_col0 < 20)) (type: boolean)
+ predicate: ((_col0 < 20) and (_col0 > 10)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1764,7 +1764,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((_col0 > 10) and (_col0 < 20)) (type: boolean)
+ predicate: ((_col0 < 20) and (_col0 > 10)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -1997,7 +1997,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((_col0 > 10) and (_col0 < 20)) (type: boolean)
+ predicate: ((_col0 < 20) and (_col0 > 10)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -2028,7 +2028,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((_col0 > 10) and (_col0 < 20)) (type: boolean)
+ predicate: ((_col0 < 20) and (_col0 > 10)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -2193,7 +2193,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((_col0 > 10) and (_col0 < 20)) (type: boolean)
+ predicate: ((_col0 < 20) and (_col0 > 10)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -2224,7 +2224,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((_col0 > 10) and (_col0 < 20)) (type: boolean)
+ predicate: ((_col0 < 20) and (_col0 > 10)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -2856,7 +2856,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -2969,7 +2969,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -3082,7 +3082,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -3195,7 +3195,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -3305,7 +3305,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((key > 10) and (key < 20)) (type: boolean)
+ predicate: ((key < 20) and (key > 10)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -3346,7 +3346,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -3529,7 +3529,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((key > 10) and (key < 20)) (type: boolean)
+ predicate: ((key < 20) and (key > 10)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -3570,7 +3570,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -3763,7 +3763,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((key > 10) and (key < 20)) (type: boolean)
+ predicate: ((key < 20) and (key > 10)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -3804,7 +3804,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
@@ -4075,7 +4075,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.src_multi1
Filter Operator
- predicate: ((key > 10) and (key < 20)) (type: boolean)
+ predicate: ((key < 20) and (key > 10)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -4116,7 +4116,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Filter Operator
- predicate: ((KEY._col0 > 10) and (KEY._col0 < 20)) (type: boolean)
+ predicate: ((KEY._col0 < 20) and (KEY._col0 > 10)) (type: boolean)
Statistics: Num rows: 24 Data size: 254 Basic stats: COMPLETE Column stats: NONE
Group By Operator
keys: KEY._col0 (type: string), KEY._col1 (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out b/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out
index 225f2c3..0231318 100644
--- a/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out
+++ b/ql/src/test/results/clientpositive/multi_insert_with_join2.q.out
@@ -172,7 +172,7 @@ STAGE PLANS:
alias: b
Statistics: Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((val = 'val_104') and (id = 'Id_2')) (type: boolean)
+ predicate: ((id = 'Id_2') and (val = 'val_104')) (type: boolean)
Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
Select Operator
Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
@@ -271,7 +271,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col6 = 'val_104') and (_col5 = 'Id_2') and (_col1 <> _col6)) (type: boolean)
+ predicate: ((_col1 <> _col6) and (_col5 = 'Id_2') and (_col6 = 'val_104')) (type: boolean)
Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), 'Id_2' (type: string), 'val_104' (type: string)
@@ -399,7 +399,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.join_result_1
Filter Operator
- predicate: ((_col6 = 'val_104') and (_col5 = 'Id_2')) (type: boolean)
+ predicate: ((_col5 = 'Id_2') and (_col6 = 'val_104')) (type: boolean)
Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), 'Id_2' (type: string), 'val_104' (type: string)
@@ -518,7 +518,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.join_result_1
Filter Operator
- predicate: ((_col6 = 'val_104') and (_col5 = 'Id_2')) (type: boolean)
+ predicate: ((_col5 = 'Id_2') and (_col6 = 'val_104')) (type: boolean)
Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), 'Id_2' (type: string), 'val_104' (type: string)
@@ -637,7 +637,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.join_result_1
Filter Operator
- predicate: ((_col6 = 'val_104') and (_col5 = 'Id_2')) (type: boolean)
+ predicate: ((_col5 = 'Id_2') and (_col6 = 'val_104')) (type: boolean)
Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), 'Id_2' (type: string), 'val_104' (type: string)
@@ -753,7 +753,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col3 = 'Id_1') and (_col2 = 'val_103')) (type: boolean)
+ predicate: ((_col2 = 'val_103') and (_col3 = 'Id_1')) (type: boolean)
Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col3 (type: string), _col2 (type: string)
@@ -884,7 +884,7 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 3 Data size: 39 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col3 = 'Id_1') and (_col2 = 'val_103')) (type: boolean)
+ predicate: ((_col2 = 'val_103') and (_col3 = 'Id_1')) (type: boolean)
Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col0 (type: string), _col3 (type: string), _col2 (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/nested_column_pruning.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/nested_column_pruning.q.out b/ql/src/test/results/clientpositive/nested_column_pruning.q.out
index bc27c40..5fe83ba 100644
--- a/ql/src/test/results/clientpositive/nested_column_pruning.q.out
+++ b/ql/src/test/results/clientpositive/nested_column_pruning.q.out
@@ -1041,7 +1041,7 @@ STAGE PLANS:
alias: t2
Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (s2.f8.f9 and s1.f6 is not null) (type: boolean)
+ predicate: (s1.f6 is not null and s2.f8.f9) (type: boolean)
Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: s1 (type: struct<f1:boolean,f2:string,f3:struct<f4:int,f5:double>,f6:int>), s2 (type: struct<f7:string,f8:struct<f9:boolean,f10:array<int>,f11:map<string,boolean>>>)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/nonmr_fetch.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/nonmr_fetch.q.out b/ql/src/test/results/clientpositive/nonmr_fetch.q.out
index 5607089..d2144b1 100644
--- a/ql/src/test/results/clientpositive/nonmr_fetch.q.out
+++ b/ql/src/test/results/clientpositive/nonmr_fetch.q.out
@@ -769,7 +769,7 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((UDFToDouble(key) > 200.0) and (UDFToDouble(key) < 250.0)) (type: boolean)
+ predicate: ((UDFToDouble(key) < 250.0) and (UDFToDouble(key) > 200.0)) (type: boolean)
Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: value (type: string), key (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/outer_join_ppr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/outer_join_ppr.q.out b/ql/src/test/results/clientpositive/outer_join_ppr.q.out
index abfc8e6..0faacd2 100644
--- a/ql/src/test/results/clientpositive/outer_join_ppr.q.out
+++ b/ql/src/test/results/clientpositive/outer_join_ppr.q.out
@@ -51,7 +51,7 @@ STAGE PLANS:
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate: ((UDFToDouble(key) > 15.0) and (UDFToDouble(key) < 20.0)) (type: boolean)
+ predicate: ((UDFToDouble(key) < 20.0) and (UDFToDouble(key) > 15.0)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
@@ -345,7 +345,7 @@ STAGE PLANS:
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate: ((UDFToDouble(key) > 15.0) and (UDFToDouble(key) < 20.0)) (type: boolean)
+ predicate: ((UDFToDouble(key) < 20.0) and (UDFToDouble(key) > 15.0)) (type: boolean)
Statistics: Num rows: 111 Data size: 1179 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out b/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out
index de239ca..03fcc62 100644
--- a/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out
+++ b/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out
@@ -68,7 +68,7 @@ STAGE PLANS:
alias: partition_test_partitioned
Statistics: Num rows: 75 Data size: 548 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((UDFToDouble(dt) >= 100.0) and (UDFToDouble(dt) <= 102.0)) (type: boolean)
+ predicate: ((UDFToDouble(dt) <= 102.0) and (UDFToDouble(dt) >= 100.0)) (type: boolean)
Statistics: Num rows: 8 Data size: 58 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), dt (type: string), BLOCK__OFFSET__INSIDE__FILE (type: bigint)
@@ -181,7 +181,7 @@ STAGE PLANS:
alias: partition_test_partitioned
Statistics: Num rows: 75 Data size: 548 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((UDFToDouble(dt) >= 100.0) and (UDFToDouble(dt) <= 102.0)) (type: boolean)
+ predicate: ((UDFToDouble(dt) <= 102.0) and (UDFToDouble(dt) >= 100.0)) (type: boolean)
Statistics: Num rows: 8 Data size: 58 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string), dt (type: string), BLOCK__OFFSET__INSIDE__FILE (type: bigint)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/pcr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/pcr.q.out b/ql/src/test/results/clientpositive/pcr.q.out
index 5d0d170..691048c 100644
--- a/ql/src/test/results/clientpositive/pcr.q.out
+++ b/ql/src/test/results/clientpositive/pcr.q.out
@@ -3184,7 +3184,7 @@ STAGE PLANS:
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate: ((ds > '2000-04-08') or ((ds <= '2000-04-09') and (key = 2))) (type: boolean)
+ predicate: (((ds <= '2000-04-09') and (key = 2)) or (ds > '2000-04-08')) (type: boolean)
Statistics: Num rows: 30 Data size: 240 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string), ds (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/pcs.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/pcs.q.out b/ql/src/test/results/clientpositive/pcs.q.out
index af5d11a..cc6ba5a 100644
--- a/ql/src/test/results/clientpositive/pcs.q.out
+++ b/ql/src/test/results/clientpositive/pcs.q.out
@@ -1067,7 +1067,7 @@ STAGE PLANS:
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate: ((struct(ds,key)) IN (const struct('2000-04-08',1), const struct('2000-04-09',2)) and (struct(ds)) IN (const struct('2000-04-08'), const struct('2000-04-09')) and (ds = '2008-04-08')) (type: boolean)
+ predicate: ((ds = '2008-04-08') and (struct(ds)) IN (const struct('2000-04-08'), const struct('2000-04-09')) and (struct(ds,key)) IN (const struct('2000-04-08',1), const struct('2000-04-09',2))) (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
@@ -1092,7 +1092,7 @@ STAGE PLANS:
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate: ((struct(ds,key)) IN (const struct('2000-04-08',1), const struct('2000-04-09',2)) and (struct(ds)) IN (const struct('2000-04-08'), const struct('2000-04-09')) and (ds = '2008-04-08')) (type: boolean)
+ predicate: ((ds = '2008-04-08') and (struct(ds)) IN (const struct('2000-04-08'), const struct('2000-04-09')) and (struct(ds,key)) IN (const struct('2000-04-08',1), const struct('2000-04-09',2))) (type: boolean)
Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
Select Operator
expressions: key (type: int), value (type: string)
@@ -1657,7 +1657,7 @@ STAGE PLANS:
GatherStats: false
Filter Operator
isSamplingPred: false
- predicate: ((key = 3) or ((struct(((ds = '2000-04-08') or (key = 2)),key)) IN (const struct(true,2), const struct(false,3)) and ((key + 5) > 0))) (type: boolean)
+ predicate: (((struct(((ds = '2000-04-08') or (key = 2)),key)) IN (const struct(true,2), const struct(false,3)) and ((key + 5) > 0)) or (key = 3)) (type: boolean)
Statistics: Num rows: 40 Data size: 320 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: ds (type: string)
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query1.q.out b/ql/src/test/results/clientpositive/perf/query1.q.out
index 46a3812..ad350c1 100644
--- a/ql/src/test/results/clientpositive/perf/query1.q.out
+++ b/ql/src/test/results/clientpositive/perf/query1.q.out
@@ -124,7 +124,7 @@ Stage-0
Select Operator [SEL_2] (rows=57591150 width=77)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_71] (rows=57591150 width=77)
- predicate:(sr_returned_date_sk is not null and sr_store_sk is not null and sr_customer_sk is not null)
+ predicate:(sr_customer_sk is not null and sr_returned_date_sk is not null and sr_store_sk is not null)
TableScan [TS_0] (rows=57591150 width=77)
default@store_returns,store_returns,Tbl:COMPLETE,Col:NONE,Output:["sr_returned_date_sk","sr_customer_sk","sr_store_sk","sr_fee"]
<-Map 10 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query10.q.out b/ql/src/test/results/clientpositive/perf/query10.q.out
index e300561..cf3651b 100644
--- a/ql/src/test/results/clientpositive/perf/query10.q.out
+++ b/ql/src/test/results/clientpositive/perf/query10.q.out
@@ -177,7 +177,7 @@ Stage-0
Select Operator [SEL_28] (rows=4058 width=1119)
Output:["_col0"]
Filter Operator [FIL_103] (rows=4058 width=1119)
- predicate:((d_year = 2002) and d_moy BETWEEN 4 AND 7 and d_date_sk is not null)
+ predicate:((d_year = 2002) and d_date_sk is not null and d_moy BETWEEN 4 AND 7)
TableScan [TS_26] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
<-Map 19 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query11.q.out b/ql/src/test/results/clientpositive/perf/query11.q.out
index 182aa74..69ced26 100644
--- a/ql/src/test/results/clientpositive/perf/query11.q.out
+++ b/ql/src/test/results/clientpositive/perf/query11.q.out
@@ -204,7 +204,7 @@ Stage-0
Select Operator [SEL_73] (rows=80000000 width=860)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
Filter Operator [FIL_164] (rows=80000000 width=860)
- predicate:(c_customer_sk is not null and c_customer_id is not null)
+ predicate:(c_customer_id is not null and c_customer_sk is not null)
TableScan [TS_71] (rows=80000000 width=860)
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_customer_id","c_first_name","c_last_name","c_preferred_cust_flag","c_birth_country","c_login","c_email_address"]
<-Reducer 11 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query13.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query13.q.out b/ql/src/test/results/clientpositive/perf/query13.q.out
index ac9d3cb..7cb5449 100644
--- a/ql/src/test/results/clientpositive/perf/query13.q.out
+++ b/ql/src/test/results/clientpositive/perf/query13.q.out
@@ -123,7 +123,7 @@ Stage-0
Select Operator [SEL_35] (rows=715776 width=88)
Output:["_col6","_col8","_col9"]
Filter Operator [FIL_34] (rows=715776 width=88)
- predicate:(((_col19 = 'M') and (_col20 = '4 yr Degree') and _col7 BETWEEN 100 AND 150 and (_col14 = 3)) or ((_col19 = 'D') and (_col20 = 'Primary') and _col7 BETWEEN 50 AND 100 and (_col14 = 1)) or ((_col19 = 'U') and (_col20 = 'Advanced Degree') and _col7 BETWEEN 150 AND 200 and (_col14 = 1)))
+ predicate:(((_col19 = 'D') and (_col20 = 'Primary') and _col7 BETWEEN 50 AND 100 and (_col14 = 1)) or ((_col19 = 'M') and (_col20 = '4 yr Degree') and _col7 BETWEEN 100 AND 150 and (_col14 = 3)) or ((_col19 = 'U') and (_col20 = 'Advanced Degree') and _col7 BETWEEN 150 AND 200 and (_col14 = 1)))
Merge Join Operator [MERGEJOIN_71] (rows=17178642 width=88)
Conds:RS_31._col2=RS_32._col0(Inner),Output:["_col6","_col7","_col8","_col9","_col14","_col19","_col20"]
<-Map 12 [SIMPLE_EDGE]
@@ -132,7 +132,7 @@ Stage-0
Select Operator [SEL_17] (rows=1861800 width=385)
Output:["_col0","_col1","_col2"]
Filter Operator [FIL_66] (rows=1861800 width=385)
- predicate:(((cd_marital_status = 'M') or (cd_marital_status = 'D') or (cd_marital_status = 'U')) and ((cd_education_status = '4 yr Degree') or (cd_education_status = 'Primary') or (cd_education_status = 'Advanced Degree')) and cd_demo_sk is not null)
+ predicate:(((cd_education_status = '4 yr Degree') or (cd_education_status = 'Primary') or (cd_education_status = 'Advanced Degree')) and ((cd_marital_status = 'M') or (cd_marital_status = 'D') or (cd_marital_status = 'U')) and cd_demo_sk is not null)
TableScan [TS_15] (rows=1861800 width=385)
default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_marital_status","cd_education_status"]
<-Reducer 5 [SIMPLE_EDGE]
@@ -148,7 +148,7 @@ Stage-0
Select Operator [SEL_14] (rows=10000000 width=1014)
Output:["_col0","_col1"]
Filter Operator [FIL_65] (rows=10000000 width=1014)
- predicate:((ca_state) IN ('KY', 'GA', 'NM', 'MT', 'OR', 'IN', 'WI', 'MO', 'WV') and (ca_country = 'United States') and ca_address_sk is not null)
+ predicate:((ca_country = 'United States') and (ca_state) IN ('KY', 'GA', 'NM', 'MT', 'OR', 'IN', 'WI', 'MO', 'WV') and ca_address_sk is not null)
TableScan [TS_12] (rows=40000000 width=1014)
default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_address_sk","ca_state","ca_country"]
<-Reducer 4 [SIMPLE_EDGE]
@@ -199,7 +199,7 @@ Stage-0
Select Operator [SEL_5] (rows=63999513 width=88)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"]
Filter Operator [FIL_62] (rows=63999513 width=88)
- predicate:((ss_sales_price BETWEEN 100 AND 150 or ss_sales_price BETWEEN 50 AND 100 or ss_sales_price BETWEEN 150 AND 200) and (ss_net_profit BETWEEN 100 AND 200 or ss_net_profit BETWEEN 150 AND 300 or ss_net_profit BETWEEN 50 AND 250) and ss_store_sk is not null and ss_cdemo_sk is not null and ss_hdemo_sk is not null and ss_addr_sk is not null and ss_sold_date_sk is not null)
+ predicate:((ss_net_profit BETWEEN 100 AND 200 or ss_net_profit BETWEEN 150 AND 300 or ss_net_profit BETWEEN 50 AND 250) and (ss_sales_price BETWEEN 100 AND 150 or ss_sales_price BETWEEN 50 AND 100 or ss_sales_price BETWEEN 150 AND 200) and ss_addr_sk is not null and ss_cdemo_sk is not null and ss_hdemo_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null)
TableScan [TS_3] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_cdemo_sk","ss_hdemo_sk","ss_addr_sk","ss_store_sk","ss_quantity","ss_sales_price","ss_ext_sales_price","ss_ext_wholesale_cost","ss_net_profit"]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query14.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query14.q.out b/ql/src/test/results/clientpositive/perf/query14.q.out
index 2d3bf35..dac6e0f 100644
--- a/ql/src/test/results/clientpositive/perf/query14.q.out
+++ b/ql/src/test/results/clientpositive/perf/query14.q.out
@@ -1,6 +1,6 @@
-Warning: Shuffle Join MERGEJOIN[891][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product
-Warning: Shuffle Join MERGEJOIN[890][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
Warning: Shuffle Join MERGEJOIN[892][tables = [$hdt$_2, $hdt$_3, $hdt$_1]] in Stage 'Reducer 16' is a cross product
+Warning: Shuffle Join MERGEJOIN[890][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 5' is a cross product
+Warning: Shuffle Join MERGEJOIN[891][tables = [$hdt$_1, $hdt$_2, $hdt$_0]] in Stage 'Reducer 12' is a cross product
PREHOOK: query: explain
with cross_items as
(select i_item_sk ss_item_sk
@@ -340,7 +340,7 @@ Stage-0
Select Operator [SEL_15] (rows=8116 width=1119)
Output:["_col0"]
Filter Operator [FIL_773] (rows=8116 width=1119)
- predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
+ predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000)
TableScan [TS_13] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 17 [SIMPLE_EDGE]
@@ -368,7 +368,7 @@ Stage-0
Select Operator [SEL_26] (rows=8116 width=1119)
Output:["_col0"]
Filter Operator [FIL_775] (rows=8116 width=1119)
- predicate:(d_year BETWEEN 1998 AND 2000 and d_date_sk is not null)
+ predicate:(d_date_sk is not null and d_year BETWEEN 1998 AND 2000)
TableScan [TS_24] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 31 [SIMPLE_EDGE]
@@ -396,7 +396,7 @@ Stage-0
Select Operator [SEL_98] (rows=8116 width=1119)
Output:["_col0"]
Filter Operator [FIL_787] (rows=8116 width=1119)
- predicate:(d_year BETWEEN 1999 AND 2001 and d_date_sk is not null)
+ predicate:(d_date_sk is not null and d_year BETWEEN 1999 AND 2001)
TableScan [TS_96] (rows=73049 width=1119)
default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year"]
<-Map 1 [SIMPLE_EDGE]
@@ -515,7 +515,7 @@ Stage-0
Select Operator [SEL_86] (rows=18262 width=1119)
Output:["_col0"]
Filter Operator [FIL_783] (rows=18262 width=1119)
- predicate:((d_year = 2000) and (d_moy = 11) and d_date_sk is not null)
+ predicate:((d_moy = 11) and (d_year = 2000) and d_date_sk is not null)
TableScan [TS_84] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
<-Map 100 [SIMPLE_EDGE]
@@ -545,7 +545,7 @@ Stage-0
Select Operator [SEL_280] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_810] (rows=462000 width=1436)
- predicate:(i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_item_sk is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 72 [ONE_TO_ONE_EDGE]
FORWARD [RS_350]
@@ -577,7 +577,7 @@ Stage-0
Select Operator [SEL_289] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_813] (rows=462000 width=1436)
- predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 89 [SIMPLE_EDGE]
SHUFFLE [RS_293]
@@ -617,7 +617,7 @@ Stage-0
Select Operator [SEL_309] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_816] (rows=462000 width=1436)
- predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 94 [SIMPLE_EDGE]
SHUFFLE [RS_313]
@@ -657,7 +657,7 @@ Stage-0
Select Operator [SEL_330] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_819] (rows=462000 width=1436)
- predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 95 [SIMPLE_EDGE]
SHUFFLE [RS_334]
@@ -869,7 +869,7 @@ Stage-0
Select Operator [SEL_469] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_835] (rows=462000 width=1436)
- predicate:(i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_item_sk is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 82 [ONE_TO_ONE_EDGE]
FORWARD [RS_539]
@@ -901,7 +901,7 @@ Stage-0
Select Operator [SEL_478] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_838] (rows=462000 width=1436)
- predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 90 [SIMPLE_EDGE]
SHUFFLE [RS_482]
@@ -936,7 +936,7 @@ Stage-0
Select Operator [SEL_498] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_841] (rows=462000 width=1436)
- predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 96 [SIMPLE_EDGE]
SHUFFLE [RS_502]
@@ -971,7 +971,7 @@ Stage-0
Select Operator [SEL_519] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_844] (rows=462000 width=1436)
- predicate:(i_item_sk is not null and i_brand_id is not null and i_class_id is not null and i_category_id is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 97 [SIMPLE_EDGE]
SHUFFLE [RS_523]
@@ -1178,7 +1178,7 @@ Stage-0
Select Operator [SEL_92] (rows=462000 width=1436)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_785] (rows=462000 width=1436)
- predicate:(i_brand_id is not null and i_class_id is not null and i_category_id is not null and i_item_sk is not null)
+ predicate:(i_brand_id is not null and i_category_id is not null and i_class_id is not null and i_item_sk is not null)
Please refer to the previous TableScan [TS_90]
<-Reducer 62 [ONE_TO_ONE_EDGE]
FORWARD [RS_162]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query15.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query15.q.out b/ql/src/test/results/clientpositive/perf/query15.q.out
index a2d95f6..cf6cf16 100644
--- a/ql/src/test/results/clientpositive/perf/query15.q.out
+++ b/ql/src/test/results/clientpositive/perf/query15.q.out
@@ -67,7 +67,7 @@ Stage-0
Select Operator [SEL_23] (rows=348467716 width=135)
Output:["_col4","_col7"]
Filter Operator [FIL_22] (rows=348467716 width=135)
- predicate:((substr(_col4, 1, 5)) IN ('85669', '86197', '88274', '83405', '86475', '85392', '85460', '80348', '81792') or (_col3) IN ('CA', 'WA', 'GA') or (_col7 > 500))
+ predicate:((_col3) IN ('CA', 'WA', 'GA') or (_col7 > 500) or (substr(_col4, 1, 5)) IN ('85669', '86197', '88274', '83405', '86475', '85392', '85460', '80348', '81792'))
Merge Join Operator [MERGEJOIN_46] (rows=348467716 width=135)
Conds:RS_19._col0=RS_20._col1(Inner),Output:["_col3","_col4","_col7"]
<-Reducer 2 [SIMPLE_EDGE]
@@ -81,7 +81,7 @@ Stage-0
Select Operator [SEL_2] (rows=80000000 width=860)
Output:["_col0","_col1"]
Filter Operator [FIL_40] (rows=80000000 width=860)
- predicate:(c_customer_sk is not null and c_current_addr_sk is not null)
+ predicate:(c_current_addr_sk is not null and c_customer_sk is not null)
TableScan [TS_0] (rows=80000000 width=860)
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_current_addr_sk"]
<-Map 6 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query16.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query16.q.out b/ql/src/test/results/clientpositive/perf/query16.q.out
index 5ae7680..b2b990e 100644
--- a/ql/src/test/results/clientpositive/perf/query16.q.out
+++ b/ql/src/test/results/clientpositive/perf/query16.q.out
@@ -177,7 +177,7 @@ Stage-0
Select Operator [SEL_2] (rows=287989836 width=135)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
Filter Operator [FIL_67] (rows=287989836 width=135)
- predicate:(cs_ship_date_sk is not null and cs_ship_addr_sk is not null and cs_call_center_sk is not null)
+ predicate:(cs_call_center_sk is not null and cs_ship_addr_sk is not null and cs_ship_date_sk is not null)
TableScan [TS_0] (rows=287989836 width=135)
default@catalog_sales,cs1,Tbl:COMPLETE,Col:NONE,Output:["cs_ship_date_sk","cs_ship_addr_sk","cs_call_center_sk","cs_warehouse_sk","cs_order_number","cs_ext_ship_cost","cs_net_profit"]
<-Map 9 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query17.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query17.q.out b/ql/src/test/results/clientpositive/perf/query17.q.out
index c5e69d5..7c195c2 100644
--- a/ql/src/test/results/clientpositive/perf/query17.q.out
+++ b/ql/src/test/results/clientpositive/perf/query17.q.out
@@ -161,7 +161,7 @@ Stage-0
Select Operator [SEL_17] (rows=57591150 width=77)
Output:["_col0","_col1","_col2","_col3","_col4"]
Filter Operator [FIL_89] (rows=57591150 width=77)
- predicate:(sr_customer_sk is not null and sr_item_sk is not null and sr_ticket_number is not null and sr_returned_date_sk is not null)
+ predicate:(sr_customer_sk is not null and sr_item_sk is not null and sr_returned_date_sk is not null and sr_ticket_number is not null)
TableScan [TS_15] (rows=57591150 width=77)
default@store_returns,store_returns,Tbl:COMPLETE,Col:NONE,Output:["sr_returned_date_sk","sr_item_sk","sr_customer_sk","sr_ticket_number","sr_return_quantity"]
<-Reducer 9 [SIMPLE_EDGE]
@@ -219,7 +219,7 @@ Stage-0
Select Operator [SEL_2] (rows=575995635 width=88)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
Filter Operator [FIL_84] (rows=575995635 width=88)
- predicate:(ss_customer_sk is not null and ss_item_sk is not null and ss_ticket_number is not null and ss_sold_date_sk is not null and ss_store_sk is not null)
+ predicate:(ss_customer_sk is not null and ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null and ss_ticket_number is not null)
TableScan [TS_0] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk","ss_store_sk","ss_ticket_number","ss_quantity"]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query18.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query18.q.out b/ql/src/test/results/clientpositive/perf/query18.q.out
index 2ac6d4b..1f0ec90 100644
--- a/ql/src/test/results/clientpositive/perf/query18.q.out
+++ b/ql/src/test/results/clientpositive/perf/query18.q.out
@@ -128,7 +128,7 @@ Stage-0
Select Operator [SEL_17] (rows=465450 width=385)
Output:["_col0","_col3"]
Filter Operator [FIL_76] (rows=465450 width=385)
- predicate:((cd_gender = 'M') and (cd_education_status = 'College') and cd_demo_sk is not null)
+ predicate:((cd_education_status = 'College') and (cd_gender = 'M') and cd_demo_sk is not null)
TableScan [TS_15] (rows=1861800 width=385)
default@customer_demographics,cd1,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_gender","cd_education_status","cd_dep_count"]
<-Reducer 10 [SIMPLE_EDGE]
@@ -151,7 +151,7 @@ Stage-0
Select Operator [SEL_11] (rows=287989836 width=135)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
Filter Operator [FIL_74] (rows=287989836 width=135)
- predicate:(cs_bill_cdemo_sk is not null and cs_bill_customer_sk is not null and cs_sold_date_sk is not null and cs_item_sk is not null)
+ predicate:(cs_bill_cdemo_sk is not null and cs_bill_customer_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null)
TableScan [TS_9] (rows=287989836 width=135)
default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_bill_cdemo_sk","cs_item_sk","cs_quantity","cs_list_price","cs_sales_price","cs_coupon_amt","cs_net_profit"]
<-Reducer 3 [SIMPLE_EDGE]
@@ -179,7 +179,7 @@ Stage-0
Select Operator [SEL_2] (rows=40000000 width=860)
Output:["_col0","_col1","_col2","_col4"]
Filter Operator [FIL_71] (rows=40000000 width=860)
- predicate:((c_birth_month) IN (9, 5, 12, 4, 1, 10) and c_customer_sk is not null and c_current_cdemo_sk is not null and c_current_addr_sk is not null)
+ predicate:((c_birth_month) IN (9, 5, 12, 4, 1, 10) and c_current_addr_sk is not null and c_current_cdemo_sk is not null and c_customer_sk is not null)
TableScan [TS_0] (rows=80000000 width=860)
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_current_cdemo_sk","c_current_addr_sk","c_birth_month","c_birth_year"]
<-Map 7 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query19.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query19.q.out b/ql/src/test/results/clientpositive/perf/query19.q.out
index fccc0c3..363425f 100644
--- a/ql/src/test/results/clientpositive/perf/query19.q.out
+++ b/ql/src/test/results/clientpositive/perf/query19.q.out
@@ -132,7 +132,7 @@ Stage-0
Select Operator [SEL_8] (rows=575995635 width=88)
Output:["_col0","_col1","_col2","_col3","_col4"]
Filter Operator [FIL_65] (rows=575995635 width=88)
- predicate:(ss_sold_date_sk is not null and ss_item_sk is not null and ss_customer_sk is not null and ss_store_sk is not null)
+ predicate:(ss_customer_sk is not null and ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null)
TableScan [TS_6] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk","ss_store_sk","ss_ext_sales_price"]
<-Reducer 2 [SIMPLE_EDGE]
@@ -146,7 +146,7 @@ Stage-0
Select Operator [SEL_2] (rows=80000000 width=860)
Output:["_col0","_col1"]
Filter Operator [FIL_63] (rows=80000000 width=860)
- predicate:(c_customer_sk is not null and c_current_addr_sk is not null)
+ predicate:(c_current_addr_sk is not null and c_customer_sk is not null)
TableScan [TS_0] (rows=80000000 width=860)
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_current_addr_sk"]
<-Map 7 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query21.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query21.q.out b/ql/src/test/results/clientpositive/perf/query21.q.out
index 292fc4f..876e3c8 100644
--- a/ql/src/test/results/clientpositive/perf/query21.q.out
+++ b/ql/src/test/results/clientpositive/perf/query21.q.out
@@ -124,7 +124,7 @@ Stage-0
Select Operator [SEL_2] (rows=37584000 width=15)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_41] (rows=37584000 width=15)
- predicate:(inv_warehouse_sk is not null and inv_item_sk is not null and inv_date_sk is not null)
+ predicate:(inv_date_sk is not null and inv_item_sk is not null and inv_warehouse_sk is not null)
TableScan [TS_0] (rows=37584000 width=15)
default@inventory,inventory,Tbl:COMPLETE,Col:NONE,Output:["inv_date_sk","inv_item_sk","inv_warehouse_sk","inv_quantity_on_hand"]
<-Map 7 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query22.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query22.q.out b/ql/src/test/results/clientpositive/perf/query22.q.out
index a597ef0..995f61d 100644
--- a/ql/src/test/results/clientpositive/perf/query22.q.out
+++ b/ql/src/test/results/clientpositive/perf/query22.q.out
@@ -115,7 +115,7 @@ Stage-0
Select Operator [SEL_5] (rows=8116 width=1119)
Output:["_col0"]
Filter Operator [FIL_41] (rows=8116 width=1119)
- predicate:(d_month_seq BETWEEN 1212 AND 1223 and d_date_sk is not null)
+ predicate:(d_date_sk is not null and d_month_seq BETWEEN 1212 AND 1223)
TableScan [TS_3] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_month_seq"]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query23.q.out b/ql/src/test/results/clientpositive/perf/query23.q.out
index 5925869..3507278 100644
--- a/ql/src/test/results/clientpositive/perf/query23.q.out
+++ b/ql/src/test/results/clientpositive/perf/query23.q.out
@@ -340,7 +340,7 @@ Stage-0
Select Operator [SEL_8] (rows=575995635 width=88)
Output:["_col0","_col1"]
Filter Operator [FIL_323] (rows=575995635 width=88)
- predicate:(ss_sold_date_sk is not null and ss_item_sk is not null)
+ predicate:(ss_item_sk is not null and ss_sold_date_sk is not null)
TableScan [TS_6] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk"]
<-Map 18 [SIMPLE_EDGE]
@@ -363,7 +363,7 @@ Stage-0
Select Operator [SEL_5] (rows=18262 width=1119)
Output:["_col0"]
Filter Operator [FIL_322] (rows=18262 width=1119)
- predicate:((d_year = 1999) and (d_moy = 1) and d_date_sk is not null)
+ predicate:((d_moy = 1) and (d_year = 1999) and d_date_sk is not null)
TableScan [TS_3] (rows=73049 width=1119)
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
<-Map 47 [SIMPLE_EDGE]
@@ -372,7 +372,7 @@ Stage-0
Select Operator [SEL_121] (rows=144002668 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
Filter Operator [FIL_334] (rows=144002668 width=135)
- predicate:(ws_item_sk is not null and ws_bill_customer_sk is not null and ws_sold_date_sk is not null)
+ predicate:(ws_bill_customer_sk is not null and ws_item_sk is not null and ws_sold_date_sk is not null)
TableScan [TS_119] (rows=144002668 width=135)
default@web_sales,web_sales,Tbl:COMPLETE,Col:NONE,Output:["ws_sold_date_sk","ws_item_sk","ws_bill_customer_sk","ws_quantity","ws_list_price"]
<-Reducer 4 [CONTAINS]
@@ -550,7 +550,7 @@ Stage-0
Select Operator [SEL_2] (rows=287989836 width=135)
Output:["_col0","_col1","_col2","_col3","_col4"]
Filter Operator [FIL_321] (rows=287989836 width=135)
- predicate:(cs_item_sk is not null and cs_bill_customer_sk is not null and cs_sold_date_sk is not null)
+ predicate:(cs_bill_customer_sk is not null and cs_item_sk is not null and cs_sold_date_sk is not null)
TableScan [TS_0] (rows=287989836 width=135)
default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_bill_customer_sk","cs_item_sk","cs_quantity","cs_list_price"]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query24.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query24.q.out b/ql/src/test/results/clientpositive/perf/query24.q.out
index 9a1b4f6..5cbbea3 100644
--- a/ql/src/test/results/clientpositive/perf/query24.q.out
+++ b/ql/src/test/results/clientpositive/perf/query24.q.out
@@ -154,7 +154,7 @@ Stage-0
Select Operator [SEL_17] (rows=40000000 width=1014)
Output:["_col0","_col1","_col2"]
Filter Operator [FIL_137] (rows=40000000 width=1014)
- predicate:(upper(ca_country) is not null and ca_zip is not null)
+ predicate:(ca_zip is not null and upper(ca_country) is not null)
TableScan [TS_15] (rows=40000000 width=1014)
default@customer_address,customer_address,Tbl:COMPLETE,Col:NONE,Output:["ca_state","ca_zip","ca_country"]
<-Reducer 12 [SIMPLE_EDGE]
@@ -168,7 +168,7 @@ Stage-0
Select Operator [SEL_14] (rows=57591150 width=77)
Output:["_col0","_col1"]
Filter Operator [FIL_136] (rows=57591150 width=77)
- predicate:(sr_ticket_number is not null and sr_item_sk is not null)
+ predicate:(sr_item_sk is not null and sr_ticket_number is not null)
TableScan [TS_12] (rows=57591150 width=77)
default@store_returns,store_returns,Tbl:COMPLETE,Col:NONE,Output:["sr_item_sk","sr_ticket_number"]
<-Reducer 11 [SIMPLE_EDGE]
@@ -196,7 +196,7 @@ Stage-0
Select Operator [SEL_11] (rows=80000000 width=860)
Output:["_col0","_col1","_col2","_col3"]
Filter Operator [FIL_135] (rows=80000000 width=860)
- predicate:(c_customer_sk is not null and c_birth_country is not null)
+ predicate:(c_birth_country is not null and c_customer_sk is not null)
TableScan [TS_9] (rows=80000000 width=860)
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_first_name","c_last_name","c_birth_country"]
<-Reducer 9 [SIMPLE_EDGE]
@@ -210,7 +210,7 @@ Stage-0
Select Operator [SEL_2] (rows=575995635 width=88)
Output:["_col0","_col1","_col2","_col3","_col4"]
Filter Operator [FIL_132] (rows=575995635 width=88)
- predicate:(ss_ticket_number is not null and ss_item_sk is not null and ss_store_sk is not null and ss_customer_sk is not null)
+ predicate:(ss_customer_sk is not null and ss_item_sk is not null and ss_store_sk is not null and ss_ticket_number is not null)
TableScan [TS_0] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_item_sk","ss_customer_sk","ss_store_sk","ss_ticket_number","ss_sales_price"]
<-Map 17 [SIMPLE_EDGE]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query25.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query25.q.out b/ql/src/test/results/clientpositive/perf/query25.q.out
index 654ba2d..f6d342e 100644
--- a/ql/src/test/results/clientpositive/perf/query25.q.out
+++ b/ql/src/test/results/clientpositive/perf/query25.q.out
@@ -170,7 +170,7 @@ Stage-0
Select Operator [SEL_17] (rows=4058 width=1119)
Output:["_col0"]
Filter Operator [FIL_92] (rows=4058 width=1119)
- predicate:(d_moy BETWEEN 4 AND 10 and (d_year = 2000) and d_date_sk is not null)
+ predicate:((d_year = 2000) and d_date_sk is not null and d_moy BETWEEN 4 AND 10)
TableScan [TS_3] (rows=73049 width=1119)
default@date_dim,d1,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_year","d_moy"]
<-Map 13 [SIMPLE_EDGE]
@@ -179,7 +179,7 @@ Stage-0
Select Operator [SEL_14] (rows=57591150 width=77)
Output:["_col0","_col1","_col2","_col3","_col4"]
Filter Operator [FIL_91] (rows=57591150 width=77)
- predicate:(sr_customer_sk is not null and sr_item_sk is not null and sr_ticket_number is not null and sr_returned_date_sk is not null)
+ predicate:(sr_customer_sk is not null and sr_item_sk is not null and sr_returned_date_sk is not null and sr_ticket_number is not null)
TableScan [TS_12] (rows=57591150 width=77)
default@store_returns,store_returns,Tbl:COMPLETE,Col:NONE,Output:["sr_returned_date_sk","sr_item_sk","sr_customer_sk","sr_ticket_number","sr_net_loss"]
<-Reducer 9 [SIMPLE_EDGE]
@@ -193,7 +193,7 @@ Stage-0
Select Operator [SEL_11] (rows=4058 width=1119)
Output:["_col0"]
Filter Operator [FIL_90] (rows=4058 width=1119)
- predicate:(d_moy BETWEEN 4 AND 10 and (d_year = 2000) and d_date_sk is not null)
+ predicate:((d_year = 2000) and d_date_sk is not null and d_moy BETWEEN 4 AND 10)
Please refer to the previous TableScan [TS_3]
<-Map 12 [SIMPLE_EDGE]
SHUFFLE [RS_22]
@@ -223,7 +223,7 @@ Stage-0
Select Operator [SEL_2] (rows=575995635 width=88)
Output:["_col0","_col1","_col2","_col3","_col4","_col5"]
Filter Operator [FIL_87] (rows=575995635 width=88)
- predicate:(ss_customer_sk is not null and ss_item_sk is not null and ss_ticket_number is not null and ss_sold_date_sk is not null and ss_store_sk is not null)
+ predicate:(ss_customer_sk is not null and ss_item_sk is not null and ss_sold_date_sk is not null and ss_store_sk is not null and ss_ticket_number is not null)
TableScan [TS_0] (rows=575995635 width=88)
default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_item_sk","ss_customer_sk","ss_store_sk","ss_ticket_number","ss_net_profit"]
http://git-wip-us.apache.org/repos/asf/hive/blob/c5b3ccc4/ql/src/test/results/clientpositive/perf/query26.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query26.q.out b/ql/src/test/results/clientpositive/perf/query26.q.out
index 125dc77..8990298 100644
--- a/ql/src/test/results/clientpositive/perf/query26.q.out
+++ b/ql/src/test/results/clientpositive/perf/query26.q.out
@@ -117,7 +117,7 @@ Stage-0
Select Operator [SEL_2] (rows=287989836 width=135)
Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
Filter Operator [FIL_50] (rows=287989836 width=135)
- predicate:(cs_bill_cdemo_sk is not null and cs_sold_date_sk is not null and cs_item_sk is not null and cs_promo_sk is not null)
+ predicate:(cs_bill_cdemo_sk is not null and cs_item_sk is not null and cs_promo_sk is not null and cs_sold_date_sk is not null)
TableScan [TS_0] (rows=287989836 width=135)
default@catalog_sales,catalog_sales,Tbl:COMPLETE,Col:NONE,Output:["cs_sold_date_sk","cs_bill_cdemo_sk","cs_item_sk","cs_promo_sk","cs_quantity","cs_list_price","cs_sales_price","cs_coupon_amt"]
<-Map 8 [SIMPLE_EDGE]
@@ -126,7 +126,7 @@ Stage-0
Select Operator [SEL_5] (rows=232725 width=385)
Output:["_col0"]
Filter Operator [FIL_51] (rows=232725 width=385)
- predicate:((cd_gender = 'F') and (cd_marital_status = 'W') and (cd_education_status = 'Primary') and cd_demo_sk is not null)
+ predicate:((cd_education_status = 'Primary') and (cd_gender = 'F') and (cd_marital_status = 'W') and cd_demo_sk is not null)
TableScan [TS_3] (rows=1861800 width=385)
default@customer_demographics,customer_demographics,Tbl:COMPLETE,Col:NONE,Output:["cd_demo_sk","cd_gender","cd_marital_status","cd_education_status"]