http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/subquery_in_having.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/subquery_in_having.q.out b/ql/src/test/results/clientpositive/subquery_in_having.q.out index 627d1b4..8ccc185 100644 --- a/ql/src/test/results/clientpositive/subquery_in_having.q.out +++ b/ql/src/test/results/clientpositive/subquery_in_having.q.out @@ -279,21 +279,21 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_mfgr is not null (type: boolean) - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: avg(p_size) keys: p_mfgr (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: struct<count:bigint,sum:double,input:int>) Reduce Operator Tree: Group By Operator @@ -301,7 +301,7 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 15 Data size: 1586 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -317,14 +317,14 @@ STAGE PLANS: key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 15 Data size: 1586 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: double) TableScan Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 5 Data size: 528 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: @@ -333,10 +333,10 @@ STAGE PLANS: 0 _col0 (type: string) 1 _col0 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -347,21 +347,21 @@ STAGE PLANS: Map Operator Tree: TableScan alias: part_subq - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_mfgr is not null (type: boolean) - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: max(p_size), min(p_size) keys: p_mfgr (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: int), _col2 (type: int) Reduce Operator Tree: Group By Operator @@ -369,14 +369,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 15 Data size: 1586 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((_col1 - _col2) < 20) (type: boolean) - Statistics: Num rows: 5 Data size: 528 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 5 Data size: 528 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -422,51 +422,51 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_mfgr is not null (type: boolean) - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: avg(p_size) keys: p_mfgr (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: struct<count:bigint,sum:double,input:int>) TableScan alias: part_subq - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_mfgr is not null (type: boolean) - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: max(p_size), min(p_size) keys: p_mfgr (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: int), _col2 (type: int) Reduce Operator Tree: Demux Operator - Statistics: Num rows: 60 Data size: 6346 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 6346 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: avg(VALUE._col0) keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Mux Operator - Statistics: Num rows: 40 Data size: 4230 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 6346 Basic stats: COMPLETE Column stats: NONE Join Operator condition map: Inner Join 0 to 1 @@ -487,16 +487,16 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 30 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((_col1 - _col2) < 20) (type: boolean) - Statistics: Num rows: 10 Data size: 1057 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 10 Data size: 1057 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Mux Operator - Statistics: Num rows: 40 Data size: 4230 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 6346 Basic stats: COMPLETE Column stats: NONE Join Operator condition map: Inner Join 0 to 1 @@ -1584,21 +1584,21 @@ STAGE PLANS: Map Operator Tree: TableScan alias: part_subq - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: p_name is not null (type: boolean) - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: avg(p_size) keys: p_name (type: string), p_mfgr (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE value expressions: _col2 (type: struct<count:bigint,sum:double,input:int>) Reduce Operator Tree: Group By Operator @@ -1606,11 +1606,11 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 7 Data size: 1480 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col1 (type: string), _col0 (type: string), _col2 (type: double) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 7 Data size: 1480 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -1646,10 +1646,10 @@ STAGE PLANS: 0 _col1 (type: string) 1 _col0 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -1665,14 +1665,14 @@ STAGE PLANS: key expressions: _col1 (type: string) sort order: + Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 7 Data size: 1480 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col2 (type: double) TableScan Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: @@ -1681,10 +1681,10 @@ STAGE PLANS: 0 _col1 (type: string) 1 _col0 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 16 Data size: 3490 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3490 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -1695,18 +1695,18 @@ STAGE PLANS: Map Operator Tree: TableScan alias: part_subq - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: p_mfgr (type: string), p_size (type: int) sort order: ++ Map-reduce partition columns: p_mfgr (type: string) - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE value expressions: p_name (type: string) Reduce Operator Tree: Select Operator expressions: VALUE._col1 (type: string), KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: int) outputColumnNames: _col1, _col2, _col5 - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -1726,19 +1726,19 @@ STAGE PLANS: name: first_value window function: GenericUDAFFirstValueEvaluator window frame: RANGE PRECEDING(MAX)~CURRENT - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: first_value_window_0 is not null (type: boolean) - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: first_value_window_0 (type: string) outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col0 (type: string) mode: hash outputColumnNames: _col0 - Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3173 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -1834,30 +1834,30 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_null - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: value (type: string) mode: hash outputColumnNames: _col0 - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Group By Operator keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0 - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), true (type: boolean) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -1887,11 +1887,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join 0 to 1 @@ -1900,20 +1900,20 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1, _col2, _col3 residual filter predicates: {(_col1 <> _col2)} - Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: _col3 is null (type: boolean) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() keys: _col1 (type: string), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -1931,7 +1931,7 @@ STAGE PLANS: key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE value expressions: _col2 (type: bigint) Reduce Operator Tree: Group By Operator @@ -1939,11 +1939,11 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col1 (type: string), _col0 (type: string), _col2 (type: bigint) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -1979,7 +1979,7 @@ STAGE PLANS: 0 _col1 (type: string) 1 _col0 (type: string) outputColumnNames: _col0, _col1, _col2, _col4, _col5 - Statistics: Num rows: 259 Data size: 130759 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 12805 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -1997,19 +1997,19 @@ STAGE PLANS: key expressions: _col1 (type: string), _col2 (type: bigint) sort order: ++ Map-reduce partition columns: _col1 (type: string), _col2 (type: bigint) - Statistics: Num rows: 259 Data size: 130759 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 12805 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col4 (type: bigint), _col5 (type: bigint) TableScan Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: bigint) sort order: ++ Map-reduce partition columns: _col0 (type: string), _col1 (type: bigint) - Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Demux Operator - Statistics: Num rows: 731 Data size: 368503 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 30267 Basic stats: COMPLETE Column stats: NONE Mux Operator - Statistics: Num rows: 1096 Data size: 552502 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 45400 Basic stats: COMPLETE Column stats: NONE Join Operator condition map: Left Outer Join 0 to 1 @@ -2036,20 +2036,20 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: bigint) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 365 Data size: 183999 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 15133 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col1 (type: bigint), _col0 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 365 Data size: 183999 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 15133 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: _col0 is not null (type: boolean) - Statistics: Num rows: 365 Data size: 183999 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 15133 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: bigint), _col1 (type: string), true (type: boolean) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 365 Data size: 183999 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 15133 Basic stats: COMPLETE Column stats: NONE Mux Operator - Statistics: Num rows: 1096 Data size: 552502 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 45400 Basic stats: COMPLETE Column stats: NONE Join Operator condition map: Left Outer Join 0 to 1 @@ -2081,14 +2081,14 @@ STAGE PLANS: key expressions: _col1 (type: string) sort order: + Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col2 (type: bigint) TableScan Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 236 Data size: 118872 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: bigint), _col2 (type: bigint) Reduce Operator Tree: Join Operator @@ -2098,7 +2098,7 @@ STAGE PLANS: 0 _col1 (type: string) 1 _col0 (type: string) outputColumnNames: _col0, _col1, _col2, _col4, _col5 - Statistics: Num rows: 259 Data size: 130759 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 12805 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2111,19 +2111,19 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string) TableScan Reduce Output Operator sort order: - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: boolean) Reduce Operator Tree: Join Operator @@ -2134,20 +2134,20 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1, _col2, _col3 residual filter predicates: {(_col1 <> _col2)} - Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: _col3 is null (type: boolean) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() keys: _col1 (type: string), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2160,30 +2160,30 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_null - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: value (type: string) mode: hash outputColumnNames: _col0 - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Group By Operator keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0 - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), true (type: boolean) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2213,11 +2213,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join 0 to 1 @@ -2226,19 +2226,19 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1, _col2, _col3 residual filter predicates: {(_col1 <> _col2)} - Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: _col3 is null (type: boolean) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col1 (type: string), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2256,22 +2256,22 @@ STAGE PLANS: key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Group By Operator keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string) outputColumnNames: _col1 - Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col1 (type: string) mode: complete outputColumnNames: _col0 - Statistics: Num rows: 105 Data size: 31713 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2289,14 +2289,14 @@ STAGE PLANS: $hdt$_1:$hdt$_1:$hdt$_1:s1 TableScan alias: s1 - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > '9') (type: boolean) - Statistics: Num rows: 9 Data size: 1806 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 9 Data size: 1806 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator keys: 0 @@ -2313,25 +2313,25 @@ STAGE PLANS: 0 1 outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col1 <> _col2) (type: boolean) - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col2 (type: string) outputColumnNames: _col0, _col2 - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() keys: _col2 (type: string), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE value expressions: _col2 (type: bigint) Local Work: Map Reduce Local Work @@ -2341,17 +2341,17 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col2 (type: bigint) outputColumnNames: _col1, _col2 - Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(), count(_col2) keys: _col1 (type: string) mode: complete outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 236 Data size: 118872 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2364,19 +2364,19 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string) TableScan Reduce Output Operator sort order: - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: boolean) Reduce Operator Tree: Join Operator @@ -2387,19 +2387,19 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1, _col2, _col3 residual filter predicates: {(_col1 <> _col2)} - Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: _col3 is null (type: boolean) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col1 (type: string), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2412,30 +2412,30 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src_null - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: value is not null (type: boolean) - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: value (type: string) mode: hash outputColumnNames: _col0 - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 58 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Group By Operator keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0 - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), true (type: boolean) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2465,11 +2465,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Left Outer Join 0 to 1 @@ -2478,19 +2478,19 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1, _col2, _col3 residual filter predicates: {(_col1 <> _col2)} - Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: _col3 is null (type: boolean) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col1 (type: string), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2508,22 +2508,22 @@ STAGE PLANS: key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Group By Operator keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string) outputColumnNames: _col1 - Statistics: Num rows: 210 Data size: 63427 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col1 (type: string) mode: complete outputColumnNames: _col0 - Statistics: Num rows: 105 Data size: 31713 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2541,14 +2541,14 @@ STAGE PLANS: $hdt$_2:$hdt$_2:$hdt$_2:$hdt$_2:$hdt$_2:s1 TableScan alias: s1 - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key > '9') (type: boolean) - Statistics: Num rows: 9 Data size: 1806 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 9 Data size: 1806 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator keys: 0 @@ -2565,25 +2565,25 @@ STAGE PLANS: 0 1 outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col1 <> _col2) (type: boolean) - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col2 (type: string) outputColumnNames: _col0, _col2 - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count() keys: _col2 (type: string), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string), _col1 (type: string) - Statistics: Num rows: 945 Data size: 475992 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE value expressions: _col2 (type: bigint) Local Work: Map Reduce Local Work @@ -2593,16 +2593,16 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col2 (type: bigint) outputColumnNames: _col1, _col2 - Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col1 (type: string), _col2 (type: bigint) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 472 Data size: 237744 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 17462 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -2615,19 +2615,19 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator sort order: - Statistics: Num rows: 29 Data size: 5820 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string) TableScan Reduce Output Operator sort order: - Statistics: Num rows: 29 Data size: 2910 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5820 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: boolean) Reduce Operator Tree: Join Operator @@ -2638,19 +2638,19 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1, _col2, _col3 residual filter predicates: {(_col1 <> _col2)} - Statistics: Num rows: 841 Data size: 254011 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: _col3 is null (type: boolean) - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col1 (type: string), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 420 Data size: 126854 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 11641 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table:
http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out index 7cb8335..8ea8ac7 100644 --- a/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out +++ b/ql/src/test/results/clientpositive/tez/explainanalyze_3.q.out @@ -667,11 +667,11 @@ Stage-3 Map 1 File Output Operator [FS_3] table:{"name:":"default.orc_merge5"} - Select Operator [SEL_2] (rows=306/3 width=335) + Select Operator [SEL_2] (rows=1/3 width=352) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_4] (rows=306/3 width=335) + Filter Operator [FIL_4] (rows=1/3 width=352) predicate:(userid <= 13) - TableScan [TS_0] (rows=919/15000 width=335) + TableScan [TS_0] (rows=1/15000 width=352) default@orc_merge5,orc_merge5,Tbl:COMPLETE,Col:NONE,Output:["userid","string1","subtype","decimal1","ts"] Stage-4(CONDITIONAL) File Merge http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out b/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out index ce94316..7f43645 100644 --- a/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out +++ b/ql/src/test/results/clientpositive/tez/explainanalyze_5.q.out @@ -296,16 +296,16 @@ Stage-3 Reducer 2 File Output Operator [FS_8] table:{"name:":"default.acid_uami"} - Select Operator [SEL_4] (rows=4/2 width=302) + Select Operator [SEL_4] (rows=1/2 width=302) Output:["_col0","_col1","_col2","_col3"] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_3] PartitionCols:UDFToInteger(_col0) - Select Operator [SEL_2] (rows=4/2 width=302) + Select Operator [SEL_2] (rows=1/2 width=302) Output:["_col0","_col1","_col3"] - Filter Operator [FIL_9] (rows=4/2 width=226) + Filter Operator [FIL_9] (rows=1/2 width=226) predicate:((de = 109.23) or (de = 119.23)) - TableScan [TS_0] (rows=8/4 width=226) + TableScan [TS_0] (rows=1/4 width=226) default@acid_uami,acid_uami, ACID table,Tbl:COMPLETE,Col:COMPLETE,Output:["i","de","vc"] PREHOOK: query: select * from acid_uami order by de http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/tez/explainuser_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out index d26a9a3..a331bf7 100644 --- a/ql/src/test/results/clientpositive/tez/explainuser_3.q.out +++ b/ql/src/test/results/clientpositive/tez/explainuser_3.q.out @@ -511,11 +511,11 @@ Stage-3 Map 1 vectorized File Output Operator [FS_10] table:{"name:":"default.orc_merge5"} - Select Operator [SEL_9] (rows=306 width=335) + Select Operator [SEL_9] (rows=1 width=352) Output:["_col0","_col1","_col2","_col3","_col4"] - Filter Operator [FIL_8] (rows=306 width=335) + Filter Operator [FIL_8] (rows=1 width=352) predicate:(userid <= 13) - TableScan [TS_0] (rows=919 width=335) + TableScan [TS_0] (rows=1 width=352) default@orc_merge5,orc_merge5,Tbl:COMPLETE,Col:NONE,Output:["userid","string1","subtype","decimal1","ts"] Stage-4(CONDITIONAL) File Merge http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out b/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out index ff6942a..546934c 100644 --- a/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out +++ b/ql/src/test/results/clientpositive/udaf_percentile_approx_23.q.out @@ -510,11 +510,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: bucket - Statistics: Num rows: 726 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: CASE WHEN ((key < 100.0)) THEN (NaN) ELSE (key) END (type: double) outputColumnNames: _col0 - Statistics: Num rows: 726 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: percentile_approx(_col0, 0.5) mode: hash @@ -569,11 +569,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: bucket - Statistics: Num rows: 726 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: double) outputColumnNames: _col0 - Statistics: Num rows: 726 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: percentile_approx(_col0, 0.5) mode: hash http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/udf_trunc_number.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udf_trunc_number.q.out b/ql/src/test/results/clientpositive/udf_trunc_number.q.out index dfc9d70..1bdab02 100644 --- a/ql/src/test/results/clientpositive/udf_trunc_number.q.out +++ b/ql/src/test/results/clientpositive/udf_trunc_number.q.out @@ -69,11 +69,11 @@ STAGE PLANS: Processor Tree: TableScan alias: sampletable - Statistics: Num rows: 4 Data size: 50 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: trunc(c, d) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 4 Data size: 50 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: select trunc (c,d) from sampletable @@ -124,11 +124,11 @@ STAGE PLANS: Processor Tree: TableScan alias: sampletable1 - Statistics: Num rows: 6 Data size: 50 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: trunc(c, d) (type: float) outputColumnNames: _col0 - Statistics: Num rows: 6 Data size: 50 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: select trunc (c,d) from sampletable1 @@ -179,11 +179,11 @@ STAGE PLANS: Processor Tree: TableScan alias: sampletable2 - Statistics: Num rows: 3 Data size: 50 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: trunc(c, d) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 3 Data size: 50 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 50 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: select trunc (c,d) from sampletable2 @@ -234,11 +234,11 @@ STAGE PLANS: Processor Tree: TableScan alias: sampletable3 - Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: trunc(c, d) (type: bigint) outputColumnNames: _col0 - Statistics: Num rows: 2 Data size: 30 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: select trunc (c,d) from sampletable3 @@ -289,11 +289,11 @@ STAGE PLANS: Processor Tree: TableScan alias: sampletable4 - Statistics: Num rows: 3 Data size: 30 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: trunc(c, d) (type: int) outputColumnNames: _col0 - Statistics: Num rows: 3 Data size: 30 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 30 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: select trunc (c,d) from sampletable4 http://git-wip-us.apache.org/repos/asf/hive/blob/6a99cf53/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out b/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out index ecf866a..beb01b4 100644 --- a/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out +++ b/ql/src/test/results/clientpositive/vector_windowing_expressions.q.out @@ -399,7 +399,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k - Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] @@ -412,7 +412,7 @@ STAGE PLANS: native: false nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map Vectorization: enabled: true @@ -435,7 +435,7 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey0 (type: tinyint), KEY.reducesinkkey3 (type: smallint), KEY.reducesinkkey4 (type: float), KEY.reducesinkkey1 (type: boolean), KEY.reducesinkkey2 (type: string) outputColumnNames: _col0, _col1, _col4, _col6, _col7 - Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -456,17 +456,17 @@ STAGE PLANS: window function: GenericUDAFLeadEvaluator window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX) isPivotResult: true - Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col7 (type: string), _col1 (type: smallint), _col4 (type: float), (UDFToFloat(_col1) - lead_window_0) (type: float) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 8771 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 100 - Statistics: Num rows: 100 Data size: 11600 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 100 Data size: 11600 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -608,7 +608,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k - Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] @@ -621,7 +621,7 @@ STAGE PLANS: native: false nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map Vectorization: enabled: true @@ -644,7 +644,7 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: string) outputColumnNames: _col1, _col2, _col7 - Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -665,17 +665,17 @@ STAGE PLANS: window function: GenericUDAFLeadEvaluator window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX) isPivotResult: true - Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col7 (type: string), _col2 (type: int), (_col2 - lead_window_0) (type: int) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 100 - Statistics: Num rows: 100 Data size: 10800 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 100 Data size: 10800 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -817,7 +817,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k - Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] @@ -830,7 +830,7 @@ STAGE PLANS: native: false nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Execution mode: vectorized Map Vectorization: enabled: true @@ -853,7 +853,7 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey1 (type: smallint), KEY.reducesinkkey0 (type: bigint), KEY.reducesinkkey3 (type: double), KEY.reducesinkkey2 (type: string) outputColumnNames: _col1, _col3, _col5, _col7 - Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -874,17 +874,17 @@ STAGE PLANS: window function: GenericUDAFLagEvaluator window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX) isPivotResult: true - Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col7 (type: string), _col1 (type: smallint), _col5 (type: double), (UDFToDouble(_col1) - lag_window_0) (type: double) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 8479 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 100 - Statistics: Num rows: 100 Data size: 12000 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 100 Data size: 12000 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -1026,7 +1026,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k - Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] @@ -1039,7 +1039,7 @@ STAGE PLANS: native: false nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE value expressions: s (type: string) Execution mode: vectorized Map Vectorization: @@ -1063,7 +1063,7 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey1 (type: bigint), KEY.reducesinkkey0 (type: float), VALUE._col5 (type: string) outputColumnNames: _col3, _col4, _col7 - Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -1084,17 +1084,17 @@ STAGE PLANS: window function: GenericUDAFLagEvaluator window frame: ROWS PRECEDING(MAX)~FOLLOWING(MAX) isPivotResult: true - Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col7 (type: string), lag_window_0 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 9085 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 100 - Statistics: Num rows: 100 Data size: 11200 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 100 Data size: 11200 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -1519,7 +1519,7 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE TableScan Vectorization: native: true projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] @@ -1532,7 +1532,7 @@ STAGE PLANS: native: false nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true nativeConditionsNotMet: hive.execution.engine mr IN [tez, spark] IS false - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE value expressions: s (type: string) Execution mode: vectorized Map Vectorization: @@ -1556,7 +1556,7 @@ STAGE PLANS: Select Operator expressions: KEY.reducesinkkey1 (type: int), VALUE._col6 (type: string), KEY.reducesinkkey0 (type: timestamp) outputColumnNames: _col2, _col7, _col8 - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -1576,18 +1576,18 @@ STAGE PLANS: name: sum window function: GenericUDAFSumLong window frame: RANGE PRECEDING(MAX)~CURRENT - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: sum_window_0 (type: bigint), _col7 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: UDFToInteger(_col0) (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -1596,10 +1596,10 @@ STAGE PLANS: Select Operator expressions: UDFToInteger(_col0) (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 7066 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat