http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out b/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out index 7fc508b..6c06662 100644 --- a/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out +++ b/ql/src/test/results/clientpositive/llap/join_reordering_no_stats.q.out @@ -100,6 +100,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: lineitem_nostats + filterExpr: (l_partkey is not null and l_suppkey is not null) (type: boolean) Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (l_partkey is not null and l_suppkey is not null) (type: boolean) @@ -120,6 +121,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: part_nostats + filterExpr: p_partkey is not null (type: boolean) Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_partkey is not null (type: boolean) @@ -139,6 +141,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: supplier_nostats + filterExpr: s_suppkey is not null (type: boolean) Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: s_suppkey is not null (type: boolean) @@ -233,6 +236,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: lineitem_nostats + filterExpr: (l_partkey is not null and l_suppkey is not null) (type: boolean) Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (l_partkey is not null and l_suppkey is not null) (type: boolean) @@ -253,6 +257,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: part_nostats + filterExpr: p_partkey is not null (type: boolean) Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_partkey is not null (type: boolean) @@ -272,6 +277,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: supplier_nostats + filterExpr: s_suppkey is not null (type: boolean) Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: s_suppkey is not null (type: boolean) @@ -430,6 +436,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: lineitem_nostats + filterExpr: (l_partkey is not null and l_suppkey is not null) (type: boolean) Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (l_partkey is not null and l_suppkey is not null) (type: boolean) @@ -450,6 +457,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: supplier_nostats + filterExpr: s_suppkey is not null (type: boolean) Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: s_suppkey is not null (type: boolean) @@ -469,6 +477,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part_n1 + filterExpr: employeeid is not null (type: boolean) Statistics: Num rows: 8 Data size: 28 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: employeeid is not null (type: boolean) @@ -563,6 +572,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: lineitem_nostats + filterExpr: (l_partkey is not null and l_suppkey is not null) (type: boolean) Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (l_partkey is not null and l_suppkey is not null) (type: boolean) @@ -583,6 +593,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: supplier_nostats + filterExpr: s_suppkey is not null (type: boolean) Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: s_suppkey is not null (type: boolean) @@ -602,6 +613,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part_n1 + filterExpr: employeeid is not null (type: boolean) Statistics: Num rows: 8 Data size: 28 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: employeeid is not null (type: boolean)
http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/kryo.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/kryo.q.out b/ql/src/test/results/clientpositive/llap/kryo.q.out index 1463dfb..234bae8 100644 --- a/ql/src/test/results/clientpositive/llap/kryo.q.out +++ b/ql/src/test/results/clientpositive/llap/kryo.q.out @@ -44,6 +44,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: datetime_ + filterExpr: ((id = 1) or (id = 2) or (id = 3) or (id = 4) or (id = 5) or (id = 6)) (type: boolean) Statistics: Num rows: 1 Data size: 372 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((id = 1) or (id = 2) or (id = 3) or (id = 4) or (id = 5) or (id = 6)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out b/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out index 363f2de..d8de3e7 100644 --- a/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out +++ b/ql/src/test/results/clientpositive/llap/leftsemijoin.q.out @@ -108,7 +108,7 @@ POSTHOOK: query: drop table things_n1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@things_n1 POSTHOOK: Output: default@things_n1 -Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product +Warning: Shuffle Join MERGEJOIN[34][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product PREHOOK: query: explain select part.p_type from part join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name PREHOOK: type: QUERY POSTHOOK: query: explain select part.p_type from part join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name @@ -130,6 +130,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: part + filterExpr: 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 (type: boolean) @@ -150,6 +151,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: p1 + 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) @@ -226,7 +228,7 @@ STAGE PLANS: Processor Tree: ListSink -Warning: Shuffle Join MERGEJOIN[24][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product +Warning: Shuffle Join MERGEJOIN[34][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product PREHOOK: query: select part.p_type from part join (select p1.p_name from part p1, part p2 group by p1.p_name) pp ON pp.p_name = part.p_name PREHOOK: type: QUERY PREHOOK: Input: default@part http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out b/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out index 76a8bf6..ebaac18 100644 --- a/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out +++ b/ql/src/test/results/clientpositive/llap/limit_join_transpose.q.out @@ -242,6 +242,10 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 value expressions: _col0 (type: string), _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + @@ -356,6 +360,10 @@ STAGE PLANS: Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Limit Number of rows: 1 Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE @@ -364,6 +372,10 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 value expressions: _col0 (type: string), _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col1 (type: string) sort order: + @@ -506,6 +518,10 @@ STAGE PLANS: Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Limit Number of rows: 1 Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE @@ -514,6 +530,10 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 value expressions: _col0 (type: string), _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col1 (type: string) sort order: + @@ -673,6 +693,10 @@ STAGE PLANS: Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + @@ -1109,6 +1133,10 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 value expressions: _col0 (type: string), _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + @@ -1224,6 +1252,10 @@ STAGE PLANS: Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Limit Number of rows: 1 Offset of rows: 1 @@ -1233,6 +1265,10 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 value expressions: _col0 (type: string), _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col1 (type: string) sort order: + @@ -1376,6 +1412,10 @@ STAGE PLANS: Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Limit Number of rows: 1 Offset of rows: 1 @@ -1385,6 +1425,10 @@ STAGE PLANS: Statistics: Num rows: 1 Data size: 178 Basic stats: COMPLETE Column stats: COMPLETE TopN Hash Memory Usage: 0.1 value expressions: _col0 (type: string), _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col1 (type: string) sort order: + @@ -1547,6 +1591,10 @@ STAGE PLANS: Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col1 (type: string) + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator key expressions: _col0 (type: string) sort order: + http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out b/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out index b3b2dcc..b16b8d0 100644 --- a/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out +++ b/ql/src/test/results/clientpositive/llap/llap_vector_nohybridgrace.q.out @@ -35,6 +35,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c + filterExpr: (cint < 2000000000) (type: boolean) Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE TableScan Vectorization: native: true @@ -101,6 +102,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cd + filterExpr: (cint < 2000000000) (type: boolean) Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE TableScan Vectorization: native: true @@ -214,6 +216,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: c + filterExpr: (cint < 2000000000) (type: boolean) Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE TableScan Vectorization: native: true @@ -280,6 +283,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cd + filterExpr: (cint < 2000000000) (type: boolean) Statistics: Num rows: 12288 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE TableScan Vectorization: native: true http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/llapdecider.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/llapdecider.q.out b/ql/src/test/results/clientpositive/llap/llapdecider.q.out index 64ed44d..5785b70 100644 --- a/ql/src/test/results/clientpositive/llap/llapdecider.q.out +++ b/ql/src/test/results/clientpositive/llap/llapdecider.q.out @@ -339,6 +339,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_orc_n2 + filterExpr: 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 (type: boolean) @@ -359,6 +360,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: 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 (type: boolean) @@ -431,6 +433,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: 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 (type: boolean) @@ -451,6 +454,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s2 + filterExpr: 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 (type: boolean) @@ -525,6 +529,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_orc_n2 + filterExpr: 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 (type: boolean) @@ -545,6 +550,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: 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 (type: boolean) @@ -618,6 +624,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: 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 (type: boolean) @@ -637,6 +644,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s2 + filterExpr: 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 (type: boolean) @@ -709,6 +717,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: 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 (type: boolean) @@ -728,6 +737,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s2 + filterExpr: 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 (type: boolean) @@ -800,6 +810,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: 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 (type: boolean) @@ -820,6 +831,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s2 + filterExpr: 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 (type: boolean) @@ -893,6 +905,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: 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 (type: boolean) @@ -912,6 +925,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s2 + filterExpr: 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 (type: boolean) @@ -984,6 +998,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s1 + filterExpr: 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 (type: boolean) @@ -1004,6 +1019,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: s2 + filterExpr: 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 (type: boolean) @@ -1083,6 +1099,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_orc_n2 + filterExpr: (UDFToInteger(key) > 1) (type: boolean) Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (UDFToInteger(key) > 1) (type: boolean) @@ -1144,6 +1161,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_orc_n2 + filterExpr: (UDFToInteger(key) > 1) (type: boolean) Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (UDFToInteger(key) > 1) (type: boolean) @@ -1204,6 +1222,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_orc_n2 + filterExpr: (UDFToInteger(GenericUDFTestGetJavaString(key)) > 1) (type: boolean) Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (UDFToInteger(GenericUDFTestGetJavaString(key)) > 1) (type: boolean) @@ -1264,6 +1283,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_orc_n2 + filterExpr: (UDFToInteger(key) > 1) (type: boolean) Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (UDFToInteger(key) > 1) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out b/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out index d0293eb..9f54bbc 100644 --- a/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out +++ b/ql/src/test/results/clientpositive/llap/load_dyn_part2.q.out @@ -52,6 +52,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (ds is not null and hr is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 724000 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: key (type: string), value (type: string), hr (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out b/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out index c9823ce..f00343e 100644 --- a/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out +++ b/ql/src/test/results/clientpositive/llap/load_dyn_part3.q.out @@ -57,6 +57,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (ds is not null and hr is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 1092000 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: key (type: string), value (type: string), ds (type: string), hr (type: string) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out index 56aff94..7548400 100644 --- a/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out @@ -114,6 +114,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: expod1 + filterExpr: aid is not null (type: boolean) Statistics: Num rows: 3 Data size: 5772 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: aid is not null (type: boolean) @@ -199,6 +200,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: expod2 + filterExpr: bid is not null (type: boolean) Statistics: Num rows: 3 Data size: 5772 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: bid is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/mapjoin46.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mapjoin46.q.out b/ql/src/test/results/clientpositive/llap/mapjoin46.q.out index 60128da..204e775 100644 --- a/ql/src/test/results/clientpositive/llap/mapjoin46.q.out +++ b/ql/src/test/results/clientpositive/llap/mapjoin46.q.out @@ -197,6 +197,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: test2_n2 + filterExpr: key BETWEEN 100 AND 102 (type: boolean) Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key BETWEEN 100 AND 102 (type: boolean) @@ -304,6 +305,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: test2_n2 + filterExpr: key BETWEEN 100 AND 102 (type: boolean) Statistics: Num rows: 4 Data size: 380 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: key BETWEEN 100 AND 102 (type: boolean) @@ -1831,7 +1833,7 @@ NULL NULL None NULL NULL NULL 101 2 Car 102 2 Del 101 2 Car 103 2 Ema NULL NULL NULL 104 3 Fli -Warning: Shuffle Join MERGEJOIN[26][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product +Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product PREHOOK: query: EXPLAIN SELECT * FROM ( @@ -1901,6 +1903,10 @@ STAGE PLANS: Map-reduce partition columns: _col1 (type: int) Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col0 (type: int), _col2 (type: string) + Select Operator + expressions: key (type: int), value (type: int), col_1 (type: string) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 6 Data size: 572 Basic stats: COMPLETE Column stats: COMPLETE Map Join Operator condition map: Left Outer Join 0 to 1 @@ -1987,7 +1993,7 @@ STAGE PLANS: Processor Tree: ListSink -Warning: Shuffle Join MERGEJOIN[26][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product +Warning: Shuffle Join MERGEJOIN[36][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 2' is a cross product PREHOOK: query: SELECT * FROM ( SELECT test1_n4.key AS key1, test1_n4.value AS value1, test1_n4.col_1 AS col_1, http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out index 795ecfe..e7bafc9 100644 --- a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out +++ b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out @@ -95,6 +95,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t1_n95 + filterExpr: dec is not null (type: boolean) Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: dec is not null (type: boolean) @@ -124,6 +125,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: t2_n59 + filterExpr: dec is not null (type: boolean) Statistics: Num rows: 1049 Data size: 117488 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: dec is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out index 0ef6bbb..d289536 100644 --- a/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/llap/mapjoin_mapjoin.q.out @@ -18,6 +18,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (value is not null and key is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -284,6 +285,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -361,6 +363,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: value is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE GatherStats: false Filter Operator @@ -463,6 +466,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: ((value > 'val_450') and key is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value > 'val_450') and key is not null) (type: boolean) @@ -504,6 +508,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -523,6 +528,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: (value > 'val_450') (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value > 'val_450') (type: boolean) @@ -568,6 +574,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart + filterExpr: (value is not null and key is not null) (type: boolean) Statistics: Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key is not null and value is not null) (type: boolean) @@ -614,6 +621,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src1 + filterExpr: key is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) @@ -633,6 +641,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src + filterExpr: value is not null (type: boolean) Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out index b949618..c3cd893 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out @@ -176,6 +176,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n10 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 5 Data size: 580 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (a = 3) (type: boolean) @@ -194,6 +195,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n10 + filterExpr: ((d = 3) and (a = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) @@ -311,6 +313,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n10 + filterExpr: ((a = 3) and (d = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) @@ -425,6 +428,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n10 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 5 Data size: 580 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (a = 3) (type: boolean) @@ -443,6 +447,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n10 + filterExpr: ((d = 3) and (a = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out index d311f36..fdfdee5 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_2.q.out @@ -72,6 +72,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n9 + filterExpr: (c > 20) (type: boolean) Statistics: Num rows: 5 Data size: 1030 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c > 20) (type: boolean) @@ -162,6 +163,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n9 + filterExpr: (c > 20) (type: boolean) Statistics: Num rows: 5 Data size: 1030 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (c > 20) (type: boolean) @@ -252,6 +254,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.cmv_mat_view_3 + filterExpr: (c > 20) (type: boolean) Statistics: Num rows: 3 Data size: 1368 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c > 20) (type: boolean) @@ -474,6 +477,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_5 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -529,6 +533,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.cmv_mat_view_5 + filterExpr: (c > 10.1) (type: boolean) Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (c > 10.1) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out index 237ff00..6027804 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out @@ -107,6 +107,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -126,6 +127,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -253,6 +255,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -333,6 +336,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -352,6 +356,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) @@ -463,6 +468,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -482,6 +488,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2 + filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean) @@ -665,6 +672,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -730,6 +738,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -749,6 +758,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 46 Data size: 5336 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) @@ -863,6 +873,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -945,6 +956,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -1008,6 +1020,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -1027,6 +1040,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 46 Data size: 5336 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out index 8aa6c72..b3fd29a 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out @@ -107,6 +107,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n5 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -126,6 +127,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n2 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 2 Data size: 240 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -321,6 +323,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n5 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -340,6 +343,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n2 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 2 Data size: 240 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) @@ -548,6 +552,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n5 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -567,6 +572,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n2 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) @@ -683,6 +689,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.cmv_mat_view_n5 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 2 Data size: 248 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -703,6 +710,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n5 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -722,6 +730,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n2 + filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 360 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean) @@ -984,6 +993,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n5 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -1046,6 +1056,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n5 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -1065,6 +1076,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n2 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 61 Data size: 7320 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -1203,6 +1215,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n5 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -1265,6 +1278,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n5 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -1284,6 +1298,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n2 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 75 Data size: 9000 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -1422,6 +1437,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n5 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -1494,6 +1510,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.cmv_mat_view_n5 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 2 Data size: 248 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -1514,6 +1531,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n5 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -1533,6 +1551,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n2 + filterExpr: ((c > 10) and (ROW__ID.writeid > 4) and a is not null) (type: boolean) Statistics: Num rows: 91 Data size: 10920 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((ROW__ID.writeid > 4) and (c > 10) and a is not null) (type: boolean) @@ -1751,6 +1770,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n5 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out index 20146f8..9abdcbb 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out @@ -152,6 +152,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n6 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -171,6 +172,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n3 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) @@ -256,6 +258,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n6 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -275,6 +278,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n3 + filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean) @@ -442,6 +446,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n6 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -504,6 +509,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n6 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -523,6 +529,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n3 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 61 Data size: 7076 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -649,6 +656,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n6 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -712,6 +720,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n6 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -731,6 +740,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n3 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 75 Data size: 8700 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -857,6 +867,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n6 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -924,6 +935,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n6 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -943,6 +955,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n3 + filterExpr: ((c > 10) and (ROW__ID.writeid > 4) and a is not null) (type: boolean) Statistics: Num rows: 91 Data size: 10556 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((ROW__ID.writeid > 4) and (c > 10) and a is not null) (type: boolean) @@ -1069,6 +1082,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n6 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out index cff7f70..e2972f3 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_dummy.q.out @@ -176,6 +176,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n0 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 5 Data size: 580 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (a = 3) (type: boolean) @@ -194,6 +195,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n0 + filterExpr: ((d = 3) and (a = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) @@ -311,6 +313,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n0 + filterExpr: ((a = 3) and (d = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) @@ -425,6 +428,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n0 + filterExpr: (a = 3) (type: boolean) Statistics: Num rows: 5 Data size: 580 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (a = 3) (type: boolean) @@ -443,6 +447,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n0 + filterExpr: ((d = 3) and (a = 3)) (type: boolean) Statistics: Num rows: 5 Data size: 600 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((a = 3) and (d = 3)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out index 3b7fb57..210db2c 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out @@ -107,6 +107,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n1 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -126,6 +127,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n0 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -253,6 +255,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n1 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -333,6 +336,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n1 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -352,6 +356,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n0 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) @@ -463,6 +468,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n1 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -482,6 +488,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n0 + filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean) @@ -665,6 +672,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n1 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -730,6 +738,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n1 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -749,6 +758,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n0 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 46 Data size: 5336 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) @@ -863,6 +873,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n1 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -945,6 +956,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n1 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -1008,6 +1020,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n1 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -1027,6 +1040,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n0 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 46 Data size: 5336 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out index cfff416..44a866d 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out @@ -107,6 +107,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n3 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -126,6 +127,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n1 + filterExpr: ((c > 10) and a is not null) (type: boolean) Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10) and a is not null) (type: boolean) @@ -306,6 +308,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n3 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -325,6 +328,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n1 + filterExpr: ((c > 10.1) and a is not null) (type: boolean) Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((c > 10.1) and a is not null) (type: boolean) @@ -521,6 +525,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n3 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator @@ -577,6 +582,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_n3 + filterExpr: a is not null (type: boolean) Statistics: Num rows: 5 Data size: 20 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: a is not null (type: boolean) @@ -596,6 +602,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: cmv_basetable_2_n1 + filterExpr: ((c > 10) and (ROW__ID.writeid > 1) and a is not null) (type: boolean) Statistics: Num rows: 3 Data size: 348 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((ROW__ID.writeid > 1) and (c > 10) and a is not null) (type: boolean) @@ -824,6 +831,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.cmv_mat_view_n3 + filterExpr: (c > 10.1) (type: boolean) Filter Operator predicate: (c > 10.1) (type: boolean) Select Operator http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out index 16b199b..50f62d9 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out @@ -220,6 +220,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n2 + filterExpr: ((empid < 120) and deptno is not null) (type: boolean) Statistics: Num rows: 3 Data size: 315 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((empid < 120) and deptno is not null) (type: boolean) @@ -359,6 +360,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n2 + filterExpr: deptno is not null (type: boolean) Statistics: Num rows: 5 Data size: 510 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: deptno is not null (type: boolean) @@ -493,6 +495,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.mv1_n2 + filterExpr: (deptno = 1) (type: boolean) Filter Operator predicate: (deptno = 1) (type: boolean) Select Operator @@ -569,6 +572,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: emps_n3 + filterExpr: (empid > 120) (type: boolean) Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (empid > 120) (type: boolean) @@ -590,6 +594,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n2 + filterExpr: (empid < 150) (type: boolean) Statistics: Num rows: 4 Data size: 424 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (empid < 150) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out index 2d5764b..feef487 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_2.q.out @@ -220,6 +220,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.mv1_n0 + filterExpr: (deptno > 20) (type: boolean) Filter Operator predicate: (deptno > 20) (type: boolean) Select Operator @@ -299,6 +300,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.mv1_n0 + filterExpr: (deptno > 20) (type: boolean) Filter Operator predicate: (deptno > 20) (type: boolean) Select Operator @@ -378,6 +380,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.mv1_n0 + filterExpr: (deptno > 20) (type: boolean) Filter Operator predicate: (deptno > 20) (type: boolean) Select Operator @@ -457,6 +460,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.mv1_n0 + filterExpr: (empid > 15) (type: boolean) Filter Operator predicate: (empid > 15) (type: boolean) Select Operator @@ -547,6 +551,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n0 + filterExpr: (empid > 15) (type: boolean) Statistics: Num rows: 5 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (empid > 15) (type: boolean) @@ -680,6 +685,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n0 + filterExpr: ((name = name2) and (deptno = deptno2)) (type: boolean) Statistics: Num rows: 8 Data size: 1536 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: ((deptno = deptno2) and (name = name2)) (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out index 5965d31..27fdee4 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_3.q.out @@ -216,6 +216,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.mv1_n5 + filterExpr: (deptno = 1) (type: boolean) Filter Operator predicate: (deptno = 1) (type: boolean) Select Operator @@ -289,6 +290,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.mv1_n5 + filterExpr: (UDFToInteger(_c0) > 1) (type: boolean) Filter Operator predicate: (UDFToInteger(_c0) > 1) (type: boolean) Select Operator @@ -366,6 +368,7 @@ STAGE PLANS: Processor Tree: TableScan alias: default.mv1_n5 + filterExpr: (UDFToInteger(_c0) = 1) (type: boolean) Filter Operator predicate: (UDFToInteger(_c0) = 1) (type: boolean) Select Operator @@ -451,6 +454,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n5 + filterExpr: name is not null (type: boolean) Statistics: Num rows: 4 Data size: 352 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: name is not null (type: boolean) @@ -470,6 +474,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: dependents_n5 + filterExpr: name is not null (type: boolean) Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: name is not null (type: boolean) http://git-wip-us.apache.org/repos/asf/hive/blob/f2c4f319/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out index a0a22bf..7688d1a 100644 --- a/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out +++ b/ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out @@ -533,6 +533,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n3 + filterExpr: (deptno > 10) (type: boolean) Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (deptno > 10) (type: boolean) @@ -653,6 +654,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n3 + filterExpr: (deptno > 10) (type: boolean) Statistics: Num rows: 4 Data size: 48 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: (deptno > 10) (type: boolean) @@ -788,6 +790,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: default.mv1_n3 + filterExpr: name is not null (type: boolean) Statistics: Num rows: 2 Data size: 192 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: name is not null (type: boolean) @@ -808,6 +811,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: dependents_n3 + filterExpr: name is not null (type: boolean) Statistics: Num rows: 2 Data size: 188 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator predicate: name is not null (type: boolean)
