Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id EB350200C54 for ; Wed, 29 Mar 2017 00:31:41 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id E9811160B89; Tue, 28 Mar 2017 22:31:41 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 17719160BA2 for ; Wed, 29 Mar 2017 00:31:39 +0200 (CEST) Received: (qmail 78981 invoked by uid 500); 28 Mar 2017 22:31:34 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 74368 invoked by uid 99); 28 Mar 2017 22:31:30 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Mar 2017 22:31:30 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 33A64E001D; Tue, 28 Mar 2017 22:31:30 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: omalley@apache.org To: commits@hive.apache.org Date: Tue, 28 Mar 2017 22:31:57 -0000 Message-Id: In-Reply-To: <7aaeb7d8d04244f9906f80b366f5bfb8@git.apache.org> References: <7aaeb7d8d04244f9906f80b366f5bfb8@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [29/50] [abbrv] hive git commit: HIVE-15084: Flaky test: TestMiniTezCliDriver:explainanalyze_1, 2, 3, 4, 5 (Pengcheng Xiong) archived-at: Tue, 28 Mar 2017 22:31:42 -0000 http://git-wip-us.apache.org/repos/asf/hive/blob/9f5bea3b/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out b/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out index 92042d2..7756426 100644 --- a/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out +++ b/ql/src/test/results/clientpositive/llap/tez_union_multiinsert.q.out @@ -103,12 +103,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Execution mode: llap LLAP IO: no inputs Map 7 @@ -136,12 +136,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Execution mode: llap LLAP IO: no inputs Reducer 2 @@ -155,7 +155,7 @@ STAGE PLANS: Select Operator expressions: 'tst1' (type: string), UDFToString(_col0) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count(DISTINCT substr(_col1, 5)) keys: _col0 (type: string), substr(_col1, 5) (type: string) @@ -172,12 +172,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reducer 4 Execution mode: llap Reduce Operator Tree: @@ -203,10 +203,10 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 180 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 180 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -984,12 +984,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Execution mode: llap LLAP IO: no inputs Map 5 @@ -1035,12 +1035,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Execution mode: llap LLAP IO: no inputs Reducer 3 @@ -1068,10 +1068,10 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 180 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 180 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -1088,7 +1088,7 @@ STAGE PLANS: Select Operator expressions: 'tst1' (type: string), UDFToString(_col0) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count(DISTINCT substr(_col1, 5)) keys: _col0 (type: string), substr(_col1, 5) (type: string) @@ -1105,12 +1105,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Union 2 Vertex: Union 2 @@ -1879,12 +1879,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Execution mode: llap LLAP IO: no inputs Map 5 @@ -1930,12 +1930,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Execution mode: llap LLAP IO: no inputs Reducer 3 @@ -1963,10 +1963,10 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 180 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 180 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -1983,7 +1983,7 @@ STAGE PLANS: Select Operator expressions: 'tst1' (type: string), UDFToString(_col0) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count(DISTINCT substr(_col1, 5)) keys: _col0 (type: string), substr(_col1, 5) (type: string) @@ -2000,12 +2000,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Union 2 Vertex: Union 2 @@ -2783,12 +2783,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Execution mode: llap LLAP IO: no inputs Reducer 2 @@ -2802,7 +2802,7 @@ STAGE PLANS: Select Operator expressions: 'tst1' (type: string), UDFToString(_col0) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: count(DISTINCT substr(_col1, 5)) keys: _col0 (type: string), substr(_col1, 5) (type: string) @@ -2819,12 +2819,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Reducer 4 Execution mode: llap Reduce Operator Tree: @@ -2850,10 +2850,10 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 180 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 180 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -3618,12 +3618,12 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: PARTIAL Execution mode: llap LLAP IO: no inputs Reducer 2 @@ -3637,17 +3637,17 @@ STAGE PLANS: Select Operator expressions: 'tst1' (type: string), UDFToString(_col0) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator keys: _col0 (type: string), _col1 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: PARTIAL Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string), substr(_col1, 5) (type: string) sort order: +++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: PARTIAL Reducer 4 Execution mode: llap Reduce Operator Tree: @@ -3655,7 +3655,7 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: PARTIAL Group By Operator aggregations: count(DISTINCT substr(_col1, 5)) keys: _col0 (type: string), substr(_col1, 5) (type: string) @@ -3672,14 +3672,14 @@ STAGE PLANS: keys: _col0 (type: string), _col1 (type: string) mode: complete outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 364 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 464 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 356 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 456 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 356 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 1 Data size: 456 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat http://git-wip-us.apache.org/repos/asf/hive/blob/9f5bea3b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out index 229640c..62a6779 100644 --- a/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction.q.out @@ -225,10 +225,10 @@ STAGE PLANS: aggregations: min(_col0), max(_col0), bloom_filter(_col0, expectedEntries=57) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: binary) Execution mode: vectorized, llap LLAP IO: all inputs @@ -273,10 +273,10 @@ STAGE PLANS: aggregations: min(VALUE._col0), max(VALUE._col1), bloom_filter(VALUE._col2, expectedEntries=57) mode: final outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: binary) Stage: Stage-0 @@ -361,10 +361,10 @@ STAGE PLANS: aggregations: min(_col0), max(_col0), bloom_filter(_col0, expectedEntries=57) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: binary) Execution mode: vectorized, llap LLAP IO: all inputs @@ -409,10 +409,10 @@ STAGE PLANS: aggregations: min(VALUE._col0), max(VALUE._col1), bloom_filter(VALUE._col2, expectedEntries=57) mode: final outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: binary) Stage: Stage-0 @@ -682,10 +682,10 @@ STAGE PLANS: aggregations: min(_col0), max(_col0), bloom_filter(_col0, expectedEntries=57) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: binary) Select Operator expressions: _col1 (type: int) @@ -743,10 +743,10 @@ STAGE PLANS: aggregations: min(VALUE._col0), max(VALUE._col1), bloom_filter(VALUE._col2, expectedEntries=57) mode: final outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: binary) Reducer 6 Execution mode: vectorized, llap http://git-wip-us.apache.org/repos/asf/hive/blob/9f5bea3b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out index 3051a45..d53ca00 100644 --- a/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out +++ b/ql/src/test/results/clientpositive/llap/vectorized_dynamic_semijoin_reduction2.q.out @@ -831,10 +831,10 @@ STAGE PLANS: aggregations: min(_col0), max(_col0), bloom_filter(_col0, expectedEntries=20) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: binary) Execution mode: vectorized, llap LLAP IO: all inputs @@ -879,10 +879,10 @@ STAGE PLANS: aggregations: min(VALUE._col0), max(VALUE._col1), bloom_filter(VALUE._col2, expectedEntries=20) mode: final outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 552 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: binary) Stage: Stage-0 @@ -967,10 +967,10 @@ STAGE PLANS: aggregations: min(_col0), max(_col0), bloom_filter(_col0, expectedEntries=20) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 282 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 282 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: char(10)), _col1 (type: char(10)), _col2 (type: binary) Execution mode: vectorized, llap LLAP IO: all inputs @@ -1015,10 +1015,10 @@ STAGE PLANS: aggregations: min(VALUE._col0), max(VALUE._col1), bloom_filter(VALUE._col2, expectedEntries=20) mode: final outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 282 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 282 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: char(10)), _col1 (type: char(10)), _col2 (type: binary) Stage: Stage-0 @@ -1103,10 +1103,10 @@ STAGE PLANS: aggregations: min(_col0), max(_col0), bloom_filter(_col0, expectedEntries=20) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 282 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 282 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: varchar(10)), _col1 (type: varchar(10)), _col2 (type: binary) Execution mode: vectorized, llap LLAP IO: all inputs @@ -1151,10 +1151,10 @@ STAGE PLANS: aggregations: min(VALUE._col0), max(VALUE._col1), bloom_filter(VALUE._col2, expectedEntries=20) mode: final outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 282 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 1 Data size: 252 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 282 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: varchar(10)), _col1 (type: varchar(10)), _col2 (type: binary) Stage: Stage-0 http://git-wip-us.apache.org/repos/asf/hive/blob/9f5bea3b/ql/src/test/results/clientpositive/load_dyn_part14.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/load_dyn_part14.q.out b/ql/src/test/results/clientpositive/load_dyn_part14.q.out index 6c949ba..a6a5c63 100644 --- a/ql/src/test/results/clientpositive/load_dyn_part14.q.out +++ b/ql/src/test/results/clientpositive/load_dyn_part14.q.out @@ -79,7 +79,7 @@ STAGE PLANS: Select Operator expressions: 'k1' (type: string), null (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 2 Data size: 172 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 2 Data size: 256 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false table: @@ -92,10 +92,10 @@ STAGE PLANS: Map Operator Tree: TableScan Union - Statistics: Num rows: 6 Data size: 854 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 6 Data size: 938 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 6 Data size: 854 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 6 Data size: 938 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -103,10 +103,10 @@ STAGE PLANS: name: default.nzhang_part14 TableScan Union - Statistics: Num rows: 6 Data size: 854 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 6 Data size: 938 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 6 Data size: 854 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 6 Data size: 938 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -114,10 +114,10 @@ STAGE PLANS: name: default.nzhang_part14 TableScan Union - Statistics: Num rows: 6 Data size: 854 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 6 Data size: 938 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false - Statistics: Num rows: 6 Data size: 854 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 6 Data size: 938 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat http://git-wip-us.apache.org/repos/asf/hive/blob/9f5bea3b/ql/src/test/results/clientpositive/stats1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/stats1.q.out b/ql/src/test/results/clientpositive/stats1.q.out index 6955f4d..2d5b4f8 100644 --- a/ql/src/test/results/clientpositive/stats1.q.out +++ b/ql/src/test/results/clientpositive/stats1.q.out @@ -53,7 +53,7 @@ STAGE PLANS: Select Operator expressions: 'tst1' (type: string), UDFToString(_col0) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 172 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 272 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false table: @@ -66,10 +66,10 @@ STAGE PLANS: Map Operator Tree: TableScan Union - Statistics: Num rows: 26 Data size: 363 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 26 Data size: 463 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 26 Data size: 363 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 26 Data size: 463 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -83,10 +83,10 @@ STAGE PLANS: outputColumnNames: _col0, _col1 Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE Union - Statistics: Num rows: 26 Data size: 363 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 26 Data size: 463 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 26 Data size: 363 Basic stats: COMPLETE Column stats: PARTIAL + Statistics: Num rows: 26 Data size: 463 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat http://git-wip-us.apache.org/repos/asf/hive/blob/9f5bea3b/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out index 6fe287a..3928b1b 100644 --- a/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out +++ b/ql/src/test/results/clientpositive/tez/explainanalyze_1.q.out @@ -23,19 +23,19 @@ Stage-0 Union 2 <-Map 1 [CONTAINS] File Output Operator [FS_7] - Limit [LIM_6] (rows=10/20 width=178) + Limit [LIM_6] (rows=10/20 width=10) Number of rows:10 - Select Operator [SEL_1] (rows=500/12 width=178) + Select Operator [SEL_1] (rows=500/12 width=10) Output:["_col0","_col1"] - TableScan [TS_0] (rows=500/13 width=178) + TableScan [TS_0] (rows=500/13 width=10) Output:["key","value"] <-Map 3 [CONTAINS] File Output Operator [FS_7] - Limit [LIM_6] (rows=10/20 width=178) + Limit [LIM_6] (rows=10/20 width=10) Number of rows:10 - Select Operator [SEL_3] (rows=500/12 width=178) + Select Operator [SEL_3] (rows=500/12 width=10) Output:["_col0","_col1"] - TableScan [TS_2] (rows=500/13 width=178) + TableScan [TS_2] (rows=500/13 width=10) Output:["key","value"] PREHOOK: query: select key from src @@ -87,10 +87,10 @@ Stage-3 Map 1 File Output Operator [FS_2] table:{"name:":"default.t"} - Select Operator [SEL_1] (rows=500/500 width=87) + Select Operator [SEL_1] (rows=500/500 width=10) Output:["_col0"] - TableScan [TS_0] (rows=500/500 width=87) - default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] + TableScan [TS_0] (rows=500/500 width=10) + default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key"] Stage-0 Move Operator Please refer to the previous Stage-1 @@ -131,10 +131,10 @@ Stage-3 Map 1 File Output Operator [FS_2] table:{"name:":"default.t"} - Select Operator [SEL_1] (rows=500/500 width=87) + Select Operator [SEL_1] (rows=500/500 width=10) Output:["_col0"] - TableScan [TS_0] (rows=500/500 width=87) - default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] + TableScan [TS_0] (rows=500/500 width=10) + default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key"] PREHOOK: query: select key from src limit 10 PREHOOK: type: QUERY @@ -239,18 +239,16 @@ Stage-0 limit:-1 Stage-1 Reducer 2 - File Output Operator [FS_6] - Group By Operator [GBY_4] (rows=205/309 width=95) - Output:["_col0","_col1"],aggregations:["count(VALUE._col0)"],keys:KEY._col0 + File Output Operator [FS_5] + Group By Operator [GBY_3] (rows=250/309 width=10) + Output:["_col0","_col1"],aggregations:["count(KEY._col0)"],keys:KEY._col0 <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_3] - PartitionCols:_col0 - Group By Operator [GBY_2] (rows=205/309 width=95) - Output:["_col0","_col1"],aggregations:["count(key)"],keys:key - Select Operator [SEL_1] (rows=500/500 width=87) - Output:["key"] - TableScan [TS_0] (rows=500/500 width=87) - default@src,src,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] + SHUFFLE [RS_2] + PartitionCols:key + Select Operator [SEL_1] (rows=500/500 width=10) + Output:["key"] + TableScan [TS_0] (rows=500/500 width=10) + default@src,src,Tbl:COMPLETE,Col:NONE,Output:["key"] PREHOOK: query: select count(*) from (select key, count(key) from src group by key)subq PREHOOK: type: QUERY @@ -284,33 +282,31 @@ Stage-0 limit:-1 Stage-1 Reducer 3 - File Output Operator [FS_14] - Group By Operator [GBY_12] (rows=1/1 width=8) - Output:["_col0"],aggregations:["count(VALUE._col0)"] + File Output Operator [FS_13] + Group By Operator [GBY_11] (rows=1/1 width=8) + Output:["_col0"],aggregations:["count()"] <-Reducer 2 [SIMPLE_EDGE] - SHUFFLE [RS_11] - Group By Operator [GBY_10] (rows=1/1 width=8) - Output:["_col0"],aggregations:["count()"] - Merge Join Operator [MERGEJOIN_19] (rows=382/0 width=8) - Conds:RS_6._col0=RS_7._col0(Inner) - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_6] - PartitionCols:_col0 - Select Operator [SEL_2] (rows=166/497 width=87) - Output:["_col0"] - Filter Operator [FIL_17] (rows=166/497 width=87) - predicate:(UDFToDouble(key) > 0.0) - TableScan [TS_0] (rows=500/500 width=87) - default@src,a,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] - <-Map 4 [SIMPLE_EDGE] - SHUFFLE [RS_7] - PartitionCols:_col0 - Select Operator [SEL_5] (rows=166/0 width=91) - Output:["_col0"] - Filter Operator [FIL_18] (rows=166/0 width=91) - predicate:(UDFToDouble(value) > 0.0) - TableScan [TS_3] (rows=500/500 width=91) - default@src,b,Tbl:COMPLETE,Col:COMPLETE,Output:["value"] + SHUFFLE [RS_10] + Merge Join Operator [MERGEJOIN_18] (rows=182/0 width=10) + Conds:RS_6._col0=RS_7._col0(Inner) + <-Map 1 [SIMPLE_EDGE] + SHUFFLE [RS_6] + PartitionCols:_col0 + Select Operator [SEL_2] (rows=166/497 width=10) + Output:["_col0"] + Filter Operator [FIL_16] (rows=166/497 width=10) + predicate:(UDFToDouble(key) > 0.0) + TableScan [TS_0] (rows=500/500 width=10) + default@src,a,Tbl:COMPLETE,Col:NONE,Output:["key"] + <-Map 4 [SIMPLE_EDGE] + SHUFFLE [RS_7] + PartitionCols:_col0 + Select Operator [SEL_5] (rows=166/0 width=10) + Output:["_col0"] + Filter Operator [FIL_17] (rows=166/0 width=10) + predicate:(UDFToDouble(value) > 0.0) + TableScan [TS_3] (rows=500/500 width=10) + default@src,b,Tbl:COMPLETE,Col:NONE,Output:["value"] PREHOOK: query: select count(*) from src a join src b on a.key = b.key where a.key > 0 PREHOOK: type: QUERY @@ -335,33 +331,31 @@ Stage-0 limit:-1 Stage-1 Reducer 3 - File Output Operator [FS_14] - Group By Operator [GBY_12] (rows=1/1 width=8) - Output:["_col0"],aggregations:["count(VALUE._col0)"] + File Output Operator [FS_13] + Group By Operator [GBY_11] (rows=1/1 width=8) + Output:["_col0"],aggregations:["count()"] <-Reducer 2 [SIMPLE_EDGE] - SHUFFLE [RS_11] - Group By Operator [GBY_10] (rows=1/1 width=8) - Output:["_col0"],aggregations:["count()"] - Merge Join Operator [MERGEJOIN_19] (rows=399/1019 width=8) - Conds:RS_6._col0=RS_7._col0(Inner) - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_6] - PartitionCols:_col0 - Select Operator [SEL_2] (rows=166/497 width=87) - Output:["_col0"] - Filter Operator [FIL_17] (rows=166/497 width=87) - predicate:(UDFToDouble(key) > 0.0) - TableScan [TS_0] (rows=500/500 width=87) - default@src,a,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] - <-Map 4 [SIMPLE_EDGE] - SHUFFLE [RS_7] - PartitionCols:_col0 - Select Operator [SEL_5] (rows=166/497 width=87) - Output:["_col0"] - Filter Operator [FIL_18] (rows=166/497 width=87) - predicate:(UDFToDouble(key) > 0.0) - TableScan [TS_3] (rows=500/500 width=87) - default@src,b,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] + SHUFFLE [RS_10] + Merge Join Operator [MERGEJOIN_18] (rows=182/1019 width=10) + Conds:RS_6._col0=RS_7._col0(Inner) + <-Map 1 [SIMPLE_EDGE] + SHUFFLE [RS_6] + PartitionCols:_col0 + Select Operator [SEL_2] (rows=166/497 width=10) + Output:["_col0"] + Filter Operator [FIL_16] (rows=166/497 width=10) + predicate:(UDFToDouble(key) > 0.0) + TableScan [TS_0] (rows=500/500 width=10) + default@src,a,Tbl:COMPLETE,Col:NONE,Output:["key"] + <-Map 4 [SIMPLE_EDGE] + SHUFFLE [RS_7] + PartitionCols:_col0 + Select Operator [SEL_5] (rows=166/497 width=10) + Output:["_col0"] + Filter Operator [FIL_17] (rows=166/497 width=10) + predicate:(UDFToDouble(key) > 0.0) + TableScan [TS_3] (rows=500/500 width=10) + default@src,b,Tbl:COMPLETE,Col:NONE,Output:["key"] PREHOOK: query: select count(*) from src a join src b on a.key = b.key where a.key > 0 PREHOOK: type: QUERY @@ -397,15 +391,15 @@ Stage-0 Union 2 <-Map 1 [CONTAINS] File Output Operator [FS_6] - Select Operator [SEL_1] (rows=500/500 width=178) + Select Operator [SEL_1] (rows=500/500 width=10) Output:["_col0","_col1"] - TableScan [TS_0] (rows=500/500 width=178) + TableScan [TS_0] (rows=500/500 width=10) Output:["key","value"] <-Map 3 [CONTAINS] File Output Operator [FS_6] - Select Operator [SEL_3] (rows=500/500 width=178) + Select Operator [SEL_3] (rows=500/500 width=10) Output:["_col0","_col1"] - TableScan [TS_2] (rows=500/500 width=178) + TableScan [TS_2] (rows=500/500 width=10) Output:["key","value"] PREHOOK: query: select count(*) from (select * from src a union all select * from src b)subq @@ -438,34 +432,31 @@ POSTHOOK: type: QUERY Plan optimized by CBO. Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) +Map 1 <- Map 2 (BROADCAST_EDGE) Stage-0 Fetch Operator limit:-1 Stage-1 - Reducer 2 + Map 1 File Output Operator [FS_10] - Select Operator [SEL_9] (rows=1219/1028 width=178) + Select Operator [SEL_9] (rows=550/1028 width=10) Output:["_col0","_col1"] - Merge Join Operator [MERGEJOIN_15] (rows=1219/1028 width=178) - Conds:RS_6._col0=RS_7._col0(Inner),Output:["_col0","_col2"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_6] - PartitionCols:_col0 - Select Operator [SEL_2] (rows=500/500 width=87) - Output:["_col0"] - Filter Operator [FIL_13] (rows=500/500 width=87) - predicate:key is not null - TableScan [TS_0] (rows=500/500 width=87) - default@src,x,Tbl:COMPLETE,Col:COMPLETE,Output:["key"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_7] + Map Join Operator [MAPJOIN_15] (rows=550/1028 width=10) + Conds:SEL_2._col0=RS_7._col0(Inner),HybridGraceHashJoin:true,Output:["_col0","_col2"] + <-Map 2 [BROADCAST_EDGE] + BROADCAST [RS_7] PartitionCols:_col0 - Select Operator [SEL_5] (rows=500/500 width=178) + Select Operator [SEL_5] (rows=500/500 width=10) Output:["_col0","_col1"] - Filter Operator [FIL_14] (rows=500/500 width=178) + Filter Operator [FIL_14] (rows=500/500 width=10) predicate:key is not null - TableScan [TS_3] (rows=500/500 width=178) - default@src,y,Tbl:COMPLETE,Col:COMPLETE,Output:["key","value"] + TableScan [TS_3] (rows=500/500 width=10) + default@src,y,Tbl:COMPLETE,Col:NONE,Output:["key","value"] + <-Select Operator [SEL_2] (rows=500/500 width=10) + Output:["_col0"] + Filter Operator [FIL_13] (rows=500/500 width=10) + predicate:key is not null + TableScan [TS_0] (rows=500/500 width=10) + default@src,x,Tbl:COMPLETE,Col:NONE,Output:["key"]