You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2018/06/26 04:16:50 UTC
[31/58] [abbrv] [partial] hive git commit: HIVE-12342 : Set default
value of hive.optimize.index.filter to true (Igor Kryvenko via Ashutosh
Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/subquery_multi.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_multi.q.out b/ql/src/test/results/clientpositive/llap/subquery_multi.q.out
index 5252684..fb9cfd2 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_multi.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_multi.q.out
@@ -101,6 +101,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: (p_size is not null and p_brand is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (p_brand is not null and p_size is not null) (type: boolean)
@@ -121,6 +122,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_size is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -141,6 +143,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_brand is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_brand is not null (type: boolean)
@@ -251,7 +254,7 @@ POSTHOOK: Input: default@part_null
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[56][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from part_null where p_name IN (select p_name from part_null) AND p_brand NOT IN (select p_name from part_null)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null where p_name IN (select p_name from part_null) AND p_brand NOT IN (select p_name from part_null)
@@ -277,6 +280,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -297,6 +301,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -443,7 +448,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[56][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from part_null where p_name IN (select p_name from part_null) AND p_brand NOT IN (select p_name from part_null)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_null
@@ -452,7 +457,7 @@ POSTHOOK: query: select * from part_null where p_name IN (select p_name from par
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part_null
#### A masked pattern was here ####
-Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[56][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from part_null where p_name IN (select p_name from part_null) AND p_brand NOT IN (select p_type from part_null)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null where p_name IN (select p_name from part_null) AND p_brand NOT IN (select p_type from part_null)
@@ -478,6 +483,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -498,6 +504,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -651,7 +658,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[56][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from part_null where p_name IN (select p_name from part_null) AND p_brand NOT IN (select p_type from part_null)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_null
@@ -686,7 +693,7 @@ POSTHOOK: Input: default@part_null
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[42][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[57][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from part_null where p_brand IN (select p_brand from part_null) AND p_brand NOT IN (select p_name from part_null)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null where p_brand IN (select p_brand from part_null) AND p_brand NOT IN (select p_name from part_null)
@@ -712,6 +719,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_brand is not null (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_brand is not null (type: boolean)
@@ -732,6 +740,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_brand is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_brand is not null (type: boolean)
@@ -888,7 +897,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[42][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[57][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from part_null where p_brand IN (select p_brand from part_null) AND p_brand NOT IN (select p_name from part_null)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_null
@@ -897,7 +906,7 @@ POSTHOOK: query: select * from part_null where p_brand IN (select p_brand from p
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part_null
#### A masked pattern was here ####
-Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[56][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from part_null where p_name NOT IN (select c from tempty) AND p_brand IN (select p_brand from part_null)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null where p_name NOT IN (select c from tempty) AND p_brand IN (select p_brand from part_null)
@@ -922,6 +931,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_brand is not null (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_brand is not null (type: boolean)
@@ -970,6 +980,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_brand is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_brand is not null (type: boolean)
@@ -1086,7 +1097,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[56][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select * from part_null where p_name NOT IN (select c from tempty) AND p_brand IN (select p_brand from part_null)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_null
@@ -1124,7 +1135,7 @@ POSTHOOK: Input: default@tempty
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[40][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from part_null where p_name IN (select p_name from part_null) AND EXISTS (select c from tnull)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null where p_name IN (select p_name from part_null) AND EXISTS (select c from tnull)
@@ -1148,6 +1159,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -1168,6 +1180,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -1269,7 +1282,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[40][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from part_null where p_name IN (select p_name from part_null) AND EXISTS (select c from tnull)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_null
@@ -1306,7 +1319,7 @@ POSTHOOK: Input: default@tnull
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[40][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from part_null where p_size IN (select p_size from part_null) AND EXISTS (select c from tempty)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null where p_size IN (select p_size from part_null) AND EXISTS (select c from tempty)
@@ -1330,6 +1343,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_size is not null (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -1350,6 +1364,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_size is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -1451,7 +1466,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[40][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from part_null where p_size IN (select p_size from part_null) AND EXISTS (select c from tempty)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_null
@@ -1462,7 +1477,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@part_null
POSTHOOK: Input: default@tempty
#### A masked pattern was here ####
-Warning: Shuffle Join MERGEJOIN[31][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from part_null where p_name IN (select p_name from part_null) AND NOT EXISTS (select c from tempty)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null where p_name IN (select p_name from part_null) AND NOT EXISTS (select c from tempty)
@@ -1486,6 +1501,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -1506,6 +1522,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -1613,7 +1630,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[31][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from part_null where p_name IN (select p_name from part_null) AND NOT EXISTS (select c from tempty)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_null
@@ -1680,6 +1697,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: (p_type is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (p_name is not null and p_type is not null) (type: boolean)
@@ -1700,6 +1718,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: (p_type is not null and p_brand is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 5096 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_brand is not null and p_type is not null) (type: boolean)
@@ -1729,6 +1748,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_type is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 5850 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_name is not null and p_type is not null) (type: boolean)
@@ -1753,6 +1773,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: ((p_type is not null and p_brand is not null) or (p_type is not null and p_brand is not null and p_container is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 7488 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_brand is not null and p_type is not null) (type: boolean)
@@ -1987,6 +2008,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: (p_name is not null and p_type is not null and p_brand is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (p_brand is not null and p_name is not null and p_type is not null) (type: boolean)
@@ -2007,6 +2029,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3146 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -2027,6 +2050,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_type is not null and p_brand is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 5096 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_brand is not null and p_type is not null) (type: boolean)
@@ -2164,6 +2188,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: (p_type is not null and p_container is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (p_container is not null and p_name is not null and p_type is not null) (type: boolean)
@@ -2184,6 +2209,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: (p_type is not null and p_brand is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 5096 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_brand is not null and p_type is not null) (type: boolean)
@@ -2213,6 +2239,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_type is not null and p_container is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 8242 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_container is not null and p_name is not null and p_type is not null) (type: boolean)
@@ -2237,6 +2264,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: ((p_type is not null and p_brand is not null) or (p_type is not null and p_brand is not null and p_container is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 7488 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_brand is not null and p_type is not null) (type: boolean)
@@ -2469,6 +2497,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: (p_type is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (p_name is not null and p_type is not null) (type: boolean)
@@ -2489,6 +2518,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_type is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 5850 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_name is not null and p_type is not null) (type: boolean)
@@ -2513,6 +2543,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_size is not null or (p_size is not null and p_type is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -2700,6 +2731,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null
+ filterExpr: (p_type is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (p_name is not null and p_type is not null) (type: boolean)
@@ -2720,6 +2752,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_type is not null and p_brand is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 8242 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_brand is not null and p_name is not null and p_type is not null) (type: boolean)
@@ -2740,6 +2773,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: (p_type is not null and p_brand is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 5096 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_brand is not null and p_type is not null) (type: boolean)
@@ -2846,7 +2880,7 @@ POSTHOOK: Input: default@part_null
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[62][tables = [$hdt$_2, $hdt$_3]] in Stage 'Reducer 7' is a cross product
+Warning: Shuffle Join MERGEJOIN[82][tables = [$hdt$_2, $hdt$_3]] in Stage 'Reducer 7' is a cross product
PREHOOK: query: explain select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
@@ -2878,6 +2912,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem
+ filterExpr: l_partkey is not null (type: boolean)
Statistics: Num rows: 100 Data size: 400 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: l_partkey is not null (type: boolean)
@@ -2898,6 +2933,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: li
+ filterExpr: ((l_linenumber = 1) and l_partkey is not null and l_orderkey is not null) (type: boolean)
Statistics: Num rows: 100 Data size: 1600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((l_linenumber = 1) and l_orderkey is not null and l_partkey is not null) (type: boolean)
@@ -2918,6 +2954,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem
+ filterExpr: ((l_shipmode = 'AIR') and (l_linenumber = 1) and l_orderkey is not null) (type: boolean)
Statistics: Num rows: 100 Data size: 10400 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((l_linenumber = 1) and (l_shipmode = 'AIR') and l_orderkey is not null) (type: boolean)
@@ -3087,7 +3124,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[62][tables = [$hdt$_2, $hdt$_3]] in Stage 'Reducer 7' is a cross product
+Warning: Shuffle Join MERGEJOIN[82][tables = [$hdt$_2, $hdt$_3]] in Stage 'Reducer 7' is a cross product
PREHOOK: query: select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
@@ -3138,6 +3175,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: ((value is not null and key is not null) or ((key > '9') and value is not null)) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -3170,6 +3208,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: (value is not null and key is not null) (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key is not null and value is not null) (type: boolean)
@@ -3194,6 +3233,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
+ filterExpr: value is not null (type: boolean)
Statistics: Num rows: 500 Data size: 45500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: value is not null (type: boolean)
@@ -3648,7 +3688,7 @@ POSTHOOK: Input: default@src
96 val_96 1
97 val_97 2
98 val_98 2
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[50][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select * from part where p_name IN (select p_name from part p where part.p_type <> '1')
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part where p_name IN (select p_name from part p where part.p_type <> '1')
@@ -3671,6 +3711,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: ((p_type <> '1') and p_name is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((p_type <> '1') and p_name is not null) (type: boolean)
@@ -3691,6 +3732,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3146 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -3709,6 +3751,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_type <> '1') (type: boolean)
Statistics: Num rows: 26 Data size: 2704 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_type <> '1') (type: boolean)
@@ -3783,7 +3826,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[50][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select * from part where p_name IN (select p_name from part p where part.p_type <> '1')
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -3828,7 +3871,7 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@tnull
POSTHOOK: Lineage: tnull.c SCRIPT []
POSTHOOK: Lineage: tnull.i SCRIPT []
-Warning: Shuffle Join MERGEJOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from part where p_partkey = 3 OR p_size NOT IN (select i from tnull)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part where p_partkey = 3 OR p_size NOT IN (select i from tnull)
@@ -3972,7 +4015,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select * from part where p_partkey = 3 OR p_size NOT IN (select i from tnull)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -3983,8 +4026,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
POSTHOOK: Input: default@tnull
#### A masked pattern was here ####
-Warning: Shuffle Join MERGEJOIN[42][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
-Warning: Shuffle Join MERGEJOIN[44][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[47][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[49][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select count(*) from src
where src.key in (select key from src s1 where s1.key > '9')
or src.value is not null
@@ -4032,6 +4075,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: ((key > '9') or (key > '9')) (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key > '9') (type: boolean)
@@ -4047,6 +4091,9 @@ STAGE PLANS:
sort order:
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
+ Filter Operator
+ predicate: (key > '9') (type: boolean)
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
keys: key (type: string)
mode: hash
@@ -4199,8 +4246,8 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[42][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
-Warning: Shuffle Join MERGEJOIN[44][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[47][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[49][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select count(*) from src
where src.key in (select key from src s1 where s1.key > '9')
or src.value is not null
@@ -4244,6 +4291,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: ws1
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -4264,6 +4312,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: ws2
+ filterExpr: (p_type is not null and p_retailprice is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2912 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_retailprice is not null and p_type is not null) (type: boolean)
@@ -4289,6 +4338,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: wr1
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/subquery_notin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_notin.q.out b/ql/src/test/results/clientpositive/llap/subquery_notin.q.out
index 8a5ccf5..c16b143 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_notin.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_notin.q.out
@@ -1,4 +1,4 @@
-Warning: Shuffle Join MERGEJOIN[28][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[33][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain
select *
from src
@@ -49,6 +49,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: ((key > '2') or (key > '2')) (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key > '2') (type: boolean)
@@ -62,6 +63,9 @@ STAGE PLANS:
sort order:
Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint), _col1 (type: bigint)
+ Filter Operator
+ predicate: (key > '2') (type: boolean)
+ Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
keys: key (type: string)
mode: hash
@@ -153,7 +157,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[35][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select *
from src
where src.key not in ( select key from src s1 where s1.key > '2')
@@ -905,6 +909,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_mfgr is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2652 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_mfgr is not null (type: boolean)
@@ -1216,7 +1221,7 @@ Manufacturer#5 almond antique medium spring khaki 6
Manufacturer#5 almond azure blanched chiffon midnight 23
Manufacturer#5 almond antique blue firebrick mint 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46
-Warning: Shuffle Join MERGEJOIN[34][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[39][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select li.l_partkey, count(*)
from lineitem li
where li.l_linenumber = 1 and
@@ -1249,7 +1254,7 @@ POSTHOOK: Input: default@lineitem
175839 1
59694 1
85951 1
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[35][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select *
from src
where not src.key in ( select key from src s1 where s1.key > '2')
@@ -1439,6 +1444,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((key < '11') or ((key < '11') and CASE WHEN ((key > '104')) THEN (null) ELSE ((key < '11')) END)) (type: boolean)
properties:
insideView TRUE
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
@@ -1602,6 +1608,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: ((p_brand <> 'Brand#14') and (p_size <> 340)) (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((p_brand <> 'Brand#14') and (p_size <> 340)) (type: boolean)
@@ -1622,6 +1629,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: (p_type is not null or (((p_size * p_size) <> 340) and p_type is not null and p_size is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -2229,6 +2237,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_name is not null or (p_name is not null and p_partkey is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 3250 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -2264,6 +2273,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: e
+ filterExpr: p_size is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -2640,6 +2650,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: ((p_size is not null and p_partkey is not null) or (p_size is not null and p_partkey is not null and p_name is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 3354 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_partkey is not null and p_size is not null) (type: boolean)
@@ -2673,6 +2684,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_size is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -2905,6 +2917,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: ((p_size is not null and p_partkey is not null) or (p_size is not null and p_partkey is not null and p_name is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 3354 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_partkey is not null and p_size is not null) (type: boolean)
@@ -3066,6 +3079,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_brand is not null or (p_brand is not null and p_type is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 5096 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_brand is not null (type: boolean)
@@ -3238,6 +3252,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_size is not null or (p_size is not null and p_type is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -3271,6 +3286,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_size is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -3469,7 +3485,7 @@ almond azure aquamarine papaya violet
almond antique medium spring khaki
almond aquamarine sandy cyan gainsboro
almond antique olive coral navajo
-Warning: Shuffle Join MERGEJOIN[53][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[58][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select key, count(*) from src where value NOT IN (select key from src) group by key having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
PREHOOK: type: QUERY
POSTHOOK: query: explain select key, count(*) from src where value NOT IN (select key from src) group by key having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
@@ -3704,7 +3720,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[53][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[58][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select key, count(*) from src where value NOT IN (select key from src) group by key having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -3823,6 +3839,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: (key = '90') (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key = '90') (type: boolean)
@@ -4443,7 +4460,7 @@ POSTHOOK: Input: default@part
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
110592 almond antique salmon chartreuse burlywood Manufacturer#1 Brand#15 PROMO BURNISHED NICKEL 6 JUMBO PKG 1602.59 to the furiously
105685 almond antique violet chocolate turquoise Manufacturer#2 Brand#22 MEDIUM ANODIZED COPPER 14 MED CAN 1690.68 ly pending requ
-Warning: Shuffle Join MERGEJOIN[37][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[43][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from src where key NOT IN (select p_name from part UNION ALL select p_brand from part)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from src where key NOT IN (select p_name from part UNION ALL select p_brand from part)
@@ -4647,7 +4664,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[37][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[43][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select * from src where key NOT IN (select p_name from part UNION ALL select p_brand from part)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -5201,6 +5218,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_brand is not null or (p_brand is not null and p_type is not null)) (type: boolean)
Statistics: Num rows: 26 Data size: 5096 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_brand is not null (type: boolean)
@@ -5236,6 +5254,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: e
+ filterExpr: p_size is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -5424,7 +5443,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t2_n0
POSTHOOK: Lineage: t2_n0.c1 SCRIPT []
-Warning: Shuffle Join MERGEJOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain SELECT c1 FROM t1_n0 WHERE c1 NOT IN (SELECT c1 FROM t2_n0)
PREHOOK: type: QUERY
POSTHOOK: query: explain SELECT c1 FROM t1_n0 WHERE c1 NOT IN (SELECT c1 FROM t2_n0)
@@ -5568,7 +5587,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: SELECT c1 FROM t1_n0 WHERE c1 NOT IN (SELECT c1 FROM t2_n0)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1_n0
@@ -5621,6 +5640,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2_n0
+ filterExpr: c1 is not null (type: boolean)
Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: c1 is not null (type: boolean)
@@ -5641,6 +5661,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t1_n0
+ filterExpr: c2 is not null (type: boolean)
Statistics: Num rows: 4 Data size: 352 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: c2 is not null (type: boolean)
@@ -5892,6 +5913,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t2_n0
+ filterExpr: (b is not null or (b is not null and a is not null)) (type: boolean)
Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: b is not null (type: boolean)
@@ -6106,6 +6128,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t7
+ filterExpr: (j is not null or (j is not null and i is not null)) (type: boolean)
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: j is not null (type: boolean)
@@ -6141,6 +6164,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: fixob
+ filterExpr: j is not null (type: boolean)
Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: j is not null (type: boolean)
@@ -6350,6 +6374,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t_n0
+ filterExpr: j is not null (type: boolean)
Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: j is not null (type: boolean)
@@ -6613,7 +6638,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n0
#### A masked pattern was here ####
7
-Warning: Shuffle Join MERGEJOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select t_n0.i from t_n0 where t_n0.j NOT IN (select t1_n0.i from t_n0 t1_n0 )
PREHOOK: type: QUERY
POSTHOOK: query: explain select t_n0.i from t_n0 where t_n0.j NOT IN (select t1_n0.i from t_n0 t1_n0 )
@@ -6757,7 +6782,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select t_n0.i from t_n0 where t_n0.j NOT IN (select t1_n0.i from t_n0 t1_n0 )
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n0
@@ -6768,7 +6793,7 @@ POSTHOOK: Input: default@t_n0
#### A masked pattern was here ####
1
4
-Warning: Shuffle Join MERGEJOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select t_n0.i from t_n0 where t_n0.i NOT IN (select t1_n0.i from t_n0 t1_n0 )
PREHOOK: type: QUERY
POSTHOOK: query: explain select t_n0.i from t_n0 where t_n0.i NOT IN (select t1_n0.i from t_n0 t1_n0 )
@@ -6905,7 +6930,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[25][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select t_n0.i from t_n0 where t_n0.i NOT IN (select t1_n0.i from t_n0 t1_n0 )
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n0
@@ -6918,7 +6943,7 @@ PREHOOK: query: drop table t1_n0
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table t1_n0
POSTHOOK: type: DROPTABLE
-Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[51][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select *
from src b
where b.key not in
@@ -7133,7 +7158,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[51][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select *
from src b
where b.key not in
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out b/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out
index ed3c96f..dc54611 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_scalar.q.out
@@ -347,6 +347,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_name = null) (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_name = null) (type: boolean)
@@ -365,6 +366,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null_n0
+ filterExpr: p_name is null (type: boolean)
Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_name is null (type: boolean)
@@ -1325,6 +1327,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: e
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3250 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -1345,6 +1348,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3250 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -1458,6 +1462,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: e
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3146 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -1477,6 +1482,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_name is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3250 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_name is not null (type: boolean)
@@ -1587,6 +1593,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1607,6 +1614,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null_n0
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1685,7 +1693,7 @@ POSTHOOK: Input: default@part
POSTHOOK: Input: default@part_null_n0
#### A masked pattern was here ####
192697 almond antique blue firebrick mint Manufacturer#5 Brand#52 MEDIUM BURNISHED TIN 31 LG DRUM 1789.69 ickly ir
-Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from part where p_size BETWEEN (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND (select max(p_size) from part_null_n0)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part where p_size BETWEEN (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND (select max(p_size) from part_null_n0)
@@ -1726,6 +1734,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null_n0
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1842,7 +1851,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from part where p_size BETWEEN (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND (select max(p_size) from part_null_n0)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -1879,7 +1888,7 @@ POSTHOOK: Input: default@part_null_n0
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[40][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from part where p_size >= (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND p_retailprice <= (select max(p_retailprice) from part_null_n0)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part where p_size >= (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND p_retailprice <= (select max(p_retailprice) from part_null_n0)
@@ -1903,6 +1912,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -1923,6 +1933,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null_n0
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 1 Data size: 188 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -2042,7 +2053,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[40][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from part where p_size >= (select min(p_size) from part_null_n0 where part_null_n0.p_type = part.p_type) AND p_retailprice <= (select max(p_retailprice) from part_null_n0)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -2079,7 +2090,7 @@ POSTHOOK: Input: default@part_null_n0
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[47][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from part where p_brand <> (select min(p_brand) from part ) AND p_size IN (select (p_size) from part p where p.p_type = part.p_type ) AND p_size <> 340
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part where p_brand <> (select min(p_brand) from part ) AND p_size IN (select (p_size) from part p where p.p_type = part.p_type ) AND p_size <> 340
@@ -2102,6 +2113,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: ((p_size <> 340) and p_type is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((p_size <> 340) and p_type is not null) (type: boolean)
@@ -2140,6 +2152,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: ((p_size <> 340) and p_type is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((p_size <> 340) and p_type is not null) (type: boolean)
@@ -2215,7 +2228,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[47][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select * from part where p_brand <> (select min(p_brand) from part ) AND p_size IN (select (p_size) from part p where p.p_type = part.p_type ) AND p_size <> 340
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -2285,6 +2298,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: (p_size is not null and p_partkey is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 3354 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_partkey is not null and p_size is not null) (type: boolean)
@@ -2448,6 +2462,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
+ filterExpr: (key = '90') (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key = '90') (type: boolean)
@@ -3123,6 +3138,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_size is not null (type: boolean)
Statistics: Num rows: 26 Data size: 3354 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_size is not null (type: boolean)
@@ -3143,6 +3159,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 5850 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -3163,6 +3180,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: (p_size is not null and p_type is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_size is not null and p_type is not null) (type: boolean)
@@ -3279,7 +3297,7 @@ POSTHOOK: Input: default@part
85768
86428
90681
-Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[37][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from part_null_n0 where p_name NOT LIKE (select min(p_name) from part_null_n0) AND p_brand NOT IN (select p_name from part)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null_n0 where p_name NOT LIKE (select min(p_name) from part_null_n0) AND p_brand NOT IN (select p_name from part)
@@ -3459,7 +3477,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[37][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select * from part_null_n0 where p_name NOT LIKE (select min(p_name) from part_null_n0) AND p_brand NOT IN (select p_name from part)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -3495,7 +3513,7 @@ POSTHOOK: Input: default@part_null_n0
85768 almond antique chartreuse lavender yellow Manufacturer#1 Brand#12 LARGE BRUSHED STEEL 34 SM BAG 1753.76 refull
86428 almond aquamarine burnished black steel Manufacturer#1 Brand#12 STANDARD ANODIZED STEEL 28 WRAP BAG 1414.42 arefully
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[43][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[58][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from part_null_n0 where p_brand NOT IN (select p_name from part) AND p_name NOT LIKE (select min(p_name) from part_null_n0 pp where part_null_n0.p_type = pp.p_type)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from part_null_n0 where p_brand NOT IN (select p_name from part) AND p_name NOT LIKE (select min(p_name) from part_null_n0 pp where part_null_n0.p_type = pp.p_type)
@@ -3521,6 +3539,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null_n0
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -3569,6 +3588,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 1 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -3707,7 +3727,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[43][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[58][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select * from part_null_n0 where p_brand NOT IN (select p_name from part) AND p_name NOT LIKE (select min(p_name) from part_null_n0 pp where part_null_n0.p_type = pp.p_type)
PREHOOK: type: QUERY
PREHOOK: Input: default@part
@@ -3719,7 +3739,7 @@ POSTHOOK: Input: default@part
POSTHOOK: Input: default@part_null_n0
#### A masked pattern was here ####
90681 almond antique chartreuse khaki white Manufacturer#3 Brand#31 MEDIUM BURNISHED TIN 17 SM CASE 1671.68 are slyly after the sl
-Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[42][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
@@ -3749,6 +3769,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem
+ filterExpr: l_partkey is not null (type: boolean)
Statistics: Num rows: 100 Data size: 400 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: l_partkey is not null (type: boolean)
@@ -3769,6 +3790,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: li
+ filterExpr: ((l_linenumber = 1) and l_partkey is not null) (type: boolean)
Statistics: Num rows: 100 Data size: 1600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((l_linenumber = 1) and l_partkey is not null) (type: boolean)
@@ -3789,6 +3811,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem
+ filterExpr: ((l_shipmode = 'AIR') and (l_linenumber = 1)) (type: boolean)
Statistics: Num rows: 100 Data size: 9600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((l_linenumber = 1) and (l_shipmode = 'AIR')) (type: boolean)
@@ -3886,7 +3909,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[42][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
@@ -3926,7 +3949,7 @@ POSTHOOK: Input: default@lineitem
85951 5952
88035 5560
88362 871
-Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[42][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
@@ -3956,6 +3979,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem
+ filterExpr: l_partkey is not null (type: boolean)
Statistics: Num rows: 100 Data size: 400 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: l_partkey is not null (type: boolean)
@@ -3976,6 +4000,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: li
+ filterExpr: ((l_linenumber = 1) and l_partkey is not null) (type: boolean)
Statistics: Num rows: 100 Data size: 1600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((l_linenumber = 1) and l_partkey is not null) (type: boolean)
@@ -3996,6 +4021,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem
+ filterExpr: ((l_shipmode = 'AIR') and (l_linenumber = 1)) (type: boolean)
Statistics: Num rows: 100 Data size: 9600 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((l_linenumber = 1) and (l_shipmode = 'AIR')) (type: boolean)
@@ -4093,7 +4119,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[42][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
@@ -4155,6 +4181,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem
+ filterExpr: l_partkey is not null (type: boolean)
Statistics: Num rows: 100 Data size: 2000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: l_partkey is not null (type: boolean)
@@ -4175,6 +4202,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_partkey is not null (type: boolean)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_partkey is not null (type: boolean)
@@ -4194,6 +4222,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: lineitem
+ filterExpr: l_partkey is not null (type: boolean)
Statistics: Num rows: 100 Data size: 1200 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: l_partkey is not null (type: boolean)
@@ -4313,6 +4342,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_null_n0
+ filterExpr: (p_type is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 1 Data size: 1120 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (p_name is not null and p_type is not null) (type: boolean)
@@ -4333,6 +4363,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: (p_type is not null and p_name is not null) (type: boolean)
Statistics: Num rows: 26 Data size: 8242 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (p_name is not null and p_type is not null) (type: boolean)
@@ -4353,6 +4384,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: pp
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 5096 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -4650,6 +4682,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts_n3
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 3 Data size: 291 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -4755,6 +4788,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps_n4
+ filterExpr: deptno is not null (type: boolean)
Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: deptno is not null (type: boolean)
@@ -4775,6 +4809,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts_n3
+ filterExpr: deptno is not null (type: boolean)
Statistics: Num rows: 3 Data size: 291 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: deptno is not null (type: boolean)
@@ -4893,6 +4928,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts_n3
+ filterExpr: (name is not null or deptno is not null) (type: boolean)
Statistics: Num rows: 3 Data size: 291 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -5035,7 +5071,7 @@ POSTHOOK: Input: default@emps_n4
110 John 40 M Vancouver 2 NULL false true 2002-05-03
120 Wilma 20 F NULL 1 5 NULL true 2005-09-07
130 Alice 40 F Vancouver 2 NULL false true 2007-01-01
-Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[40][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from emps_n4 where deptno <> (select sum(deptno) from depts_n3 where depts_n3.name = emps_n4.name) and empno > (select count(name) from depts_n3)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from emps_n4 where deptno <> (select sum(deptno) from depts_n3 where depts_n3.name = emps_n4.name) and empno > (select count(name) from depts_n3)
@@ -5059,6 +5095,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: emps_n4
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 5 Data size: 3160 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: name is not null (type: boolean)
@@ -5079,6 +5116,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: depts_n3
+ filterExpr: name is not null (type: boolean)
Statistics: Num rows: 3 Data size: 291 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: name is not null (type: boolean)
@@ -5198,7 +5236,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[28][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[33][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from emps_n4 where deptno <> (select count(deptno) from depts_n3 where depts_n3.name = emps_n4.name) and empno > (select count(name) from depts_n3)
PREHOOK: type: QUERY
PREHOOK: Input: default@depts_n3
@@ -5374,7 +5412,7 @@ POSTHOOK: Input: default@src
468 4
469 5
489 4
-Warning: Shuffle Join MERGEJOIN[34][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[44][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain
select key, value, count(*)
from src b
@@ -5408,6 +5446,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: b
+ filterExpr: (key > '8') (type: boolean)
Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key > '8') (type: boolean)
@@ -5428,6 +5467,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src
+ filterExpr: ((key > '8') or (key > '9')) (type: boolean)
Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (key > '8') (type: boolean)
@@ -5540,7 +5580,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[34][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[44][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select key, value, count(*)
from src b
where b.key in (select key from src where src.key > '8')
@@ -5742,6 +5782,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 16094 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -5762,6 +5803,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2704 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -5782,6 +5824,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: p
+ filterExpr: p_type is not null (type: boolean)
Statistics: Num rows: 26 Data size: 2808 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: p_type is not null (type: boolean)
@@ -5877,7 +5920,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select * from part where p_size <>
(select count(p_size) from part pp where part.p_type <> pp.p_type)
PREHOOK: type: QUERY
@@ -6039,7 +6082,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select * from part where p_size <>
(select count(p_size) from part pp where part.p_type <> pp.p_type)
PREHOOK: type: QUERY
@@ -6093,7 +6136,7 @@ POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n11
POSTHOOK: Lineage: t_n11.i SCRIPT []
POSTHOOK: Lineage: t_n11.j SCRIPT []
-Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select * from t_n11 where 0 = (select count(*) from t_n11 tt_n11 where tt_n11.j <> t_n11.i)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t_n11 where 0 = (select count(*) from t_n11 tt_n11 where tt_n11.j <> t_n11.i)
@@ -6253,7 +6296,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[27][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[32][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: select * from t_n11 where 0 = (select count(*) from t_n11 tt_n11 where tt_n11.j <> t_n11.i)
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n11
@@ -6263,7 +6306,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n11
#### A masked pattern was here ####
1 1
-Warning: Shuffle Join MERGEJOIN[31][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from t_n11 where 0 = (select avg(tt_n11.i) from t_n11 tt_n11 where tt_n11.j <> t_n11.i)
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t_n11 where 0 = (select avg(tt_n11.i) from t_n11 tt_n11 where tt_n11.j <> t_n11.i)
@@ -6287,6 +6330,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t_n11
+ filterExpr: i is not null (type: boolean)
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: i is not null (type: boolean)
@@ -6315,6 +6359,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t_n11
+ filterExpr: i is not null (type: boolean)
Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: i is not null (type: boolean)
@@ -6417,7 +6462,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[31][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[41][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: select * from t_n11 where 0 = (select avg(tt_n11.i) from t_n11 tt_n11 where tt_n11.j <> t_n11.i)
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n11
@@ -6472,6 +6517,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tt_n11
+ filterExpr: i is not null (type: boolean)
Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: i is not null (type: boolean)
@@ -6574,6 +6620,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: t_n11
+ filterExpr: i is not null (type: boolean)
Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: i is not null (type: boolean)
@@ -6594,6 +6641,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tt_n11
+ filterExpr: i is not null (type: boolean)
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: i is not null (type: boolean)