http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/correlationoptimizer5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out b/ql/src/test/results/clientpositive/correlationoptimizer5.q.out index c95b4ce..8ad1f70 100644 --- a/ql/src/test/results/clientpositive/correlationoptimizer5.q.out +++ b/ql/src/test/results/clientpositive/correlationoptimizer5.q.out @@ -117,35 +117,35 @@ STAGE PLANS: Map Operator Tree: TableScan alias: n - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), val (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: string) TableScan alias: m - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: @@ -154,11 +154,11 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 1 Data size: 308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3080 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3080 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -174,14 +174,14 @@ STAGE PLANS: key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3080 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: string) TableScan Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 63932 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: @@ -190,14 +190,14 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -223,34 +223,34 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE TableScan alias: y - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: @@ -259,7 +259,7 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 63932 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -324,68 +324,68 @@ STAGE PLANS: Map Operator Tree: TableScan alias: n - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), val (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: string) TableScan alias: m - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE TableScan alias: x - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE TableScan alias: y - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Demux Operator - Statistics: Num rows: 4 Data size: 12099 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 120990 Basic stats: COMPLETE Column stats: NONE Join Operator condition map: Inner Join 0 to 1 @@ -393,13 +393,13 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 4 Data size: 13308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 133089 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 4 Data size: 13308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 133089 Basic stats: COMPLETE Column stats: NONE Mux Operator - Statistics: Num rows: 8 Data size: 26616 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 8 Data size: 266178 Basic stats: COMPLETE Column stats: NONE Join Operator condition map: Inner Join 0 to 1 @@ -407,14 +407,14 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 8 Data size: 29277 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 8 Data size: 292795 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 8 Data size: 29277 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 8 Data size: 292795 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 8 Data size: 29277 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 8 Data size: 292795 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -427,9 +427,9 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 4 Data size: 13308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 133089 Basic stats: COMPLETE Column stats: NONE Mux Operator - Statistics: Num rows: 8 Data size: 26616 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 8 Data size: 266178 Basic stats: COMPLETE Column stats: NONE Join Operator condition map: Inner Join 0 to 1 @@ -437,14 +437,14 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 8 Data size: 29277 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 8 Data size: 292795 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 8 Data size: 29277 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 8 Data size: 292795 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 8 Data size: 29277 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 8 Data size: 292795 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -536,14 +536,14 @@ STAGE PLANS: $hdt$_0:$hdt$_1:m TableScan alias: m - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2160 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator keys: 0 _col0 (type: int) @@ -554,14 +554,14 @@ STAGE PLANS: Map Operator Tree: TableScan alias: n - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int), val (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 2800 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Inner Join 0 to 1 @@ -569,11 +569,11 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 1 Data size: 308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3080 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3080 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -611,14 +611,14 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -666,14 +666,14 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -690,14 +690,14 @@ STAGE PLANS: key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 308 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3080 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: string) TableScan Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 63932 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: @@ -706,14 +706,14 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col2 (type: int), _col1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 338 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3388 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -730,14 +730,14 @@ STAGE PLANS: $hdt$_1:$hdt$_2:y TableScan alias: y - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 5791 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 57910 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator keys: 0 _col0 (type: int) @@ -748,14 +748,14 @@ STAGE PLANS: Map Operator Tree: TableScan alias: x - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: key is not null (type: boolean) - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 58120 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Inner Join 0 to 1 @@ -763,7 +763,7 @@ STAGE PLANS: 0 _col0 (type: int) 1 _col0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 63932 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table:
http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/decimal_precision.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_precision.q.out b/ql/src/test/results/clientpositive/decimal_precision.q.out index b8d73b4..ab33736 100644 --- a/ql/src/test/results/clientpositive/decimal_precision.q.out +++ b/ql/src/test/results/clientpositive/decimal_precision.q.out @@ -536,11 +536,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_precision - Statistics: Num rows: 1 Data size: 2661 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 26610 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: dec (type: decimal(20,10)) outputColumnNames: dec - Statistics: Num rows: 1 Data size: 2661 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 26610 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: avg(dec), sum(dec) mode: hash http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/decimal_precision2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_precision2.q.out b/ql/src/test/results/clientpositive/decimal_precision2.q.out index ce92ff9..ca533a4 100644 --- a/ql/src/test/results/clientpositive/decimal_precision2.q.out +++ b/ql/src/test/results/clientpositive/decimal_precision2.q.out @@ -13,7 +13,7 @@ STAGE PLANS: TableScan alias: _dummy_table Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 100.001 (type: decimal(6,3)) outputColumnNames: _col0 @@ -35,7 +35,7 @@ STAGE PLANS: TableScan alias: _dummy_table Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 100 (type: decimal(3,0)) outputColumnNames: _col0 @@ -57,7 +57,7 @@ STAGE PLANS: TableScan alias: _dummy_table Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 0 (type: decimal(1,0)) outputColumnNames: _col0 @@ -79,7 +79,7 @@ STAGE PLANS: TableScan alias: _dummy_table Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 0.1 (type: decimal(1,1)) outputColumnNames: _col0 @@ -101,7 +101,7 @@ STAGE PLANS: TableScan alias: _dummy_table Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 0.01 (type: decimal(2,2)) outputColumnNames: _col0 @@ -123,7 +123,7 @@ STAGE PLANS: TableScan alias: _dummy_table Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 0.01 (type: decimal(6,3)) outputColumnNames: _col0 @@ -145,7 +145,7 @@ STAGE PLANS: TableScan alias: _dummy_table Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 69.0212249755859375 (type: decimal(18,16)) outputColumnNames: _col0 http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/decimal_udf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_udf.q.out b/ql/src/test/results/clientpositive/decimal_udf.q.out index 086f38c..3f84a00 100644 --- a/ql/src/test/results/clientpositive/decimal_udf.q.out +++ b/ql/src/test/results/clientpositive/decimal_udf.q.out @@ -38,11 +38,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key + key) (type: decimal(21,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key + key FROM DECIMAL_UDF @@ -105,11 +105,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key + CAST( value AS decimal(10,0))) (type: decimal(21,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key + value FROM DECIMAL_UDF @@ -172,11 +172,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (UDFToDouble(key) + (UDFToDouble(value) / 2.0)) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key + (value/2) FROM DECIMAL_UDF @@ -239,11 +239,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (UDFToDouble(key) + 1.0) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key + '1.0' FROM DECIMAL_UDF @@ -306,11 +306,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key - key) (type: decimal(21,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key - key FROM DECIMAL_UDF @@ -373,11 +373,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key - CAST( value AS decimal(10,0))) (type: decimal(21,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key - value FROM DECIMAL_UDF @@ -440,11 +440,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (UDFToDouble(key) - (UDFToDouble(value) / 2.0)) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key - (value/2) FROM DECIMAL_UDF @@ -507,11 +507,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (UDFToDouble(key) - 1.0) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key - '1.0' FROM DECIMAL_UDF @@ -574,11 +574,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key * key) (type: decimal(38,17)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key * key FROM DECIMAL_UDF @@ -641,14 +641,14 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key * CAST( value AS decimal(10,0))) > 0) (type: boolean) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)), value (type: int) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key, value FROM DECIMAL_UDF where key * value > 0 @@ -696,11 +696,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key * CAST( value AS decimal(10,0))) (type: decimal(31,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key * value FROM DECIMAL_UDF @@ -763,11 +763,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (UDFToDouble(key) * (UDFToDouble(value) / 2.0)) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key * (value/2) FROM DECIMAL_UDF @@ -830,11 +830,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (UDFToDouble(key) * 2.0) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key * '2.0' FROM DECIMAL_UDF @@ -897,14 +897,14 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key / 0) (type: decimal(22,12)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 1 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key / 0 FROM DECIMAL_UDF limit 1 @@ -930,14 +930,14 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (UDFToDouble(key) / null) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 1 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key / NULL FROM DECIMAL_UDF limit 1 @@ -963,14 +963,14 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key <> 0) (type: boolean) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key / key) (type: decimal(38,18)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key / key FROM DECIMAL_UDF WHERE key is not null and key <> 0 @@ -1029,14 +1029,14 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value <> 0) (type: boolean) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (key / CAST( value AS decimal(10,0))) (type: decimal(31,21)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0 @@ -1085,14 +1085,14 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (value <> 0) (type: boolean) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (UDFToDouble(key) / (UDFToDouble(value) / 2.0)) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0 @@ -1141,11 +1141,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (1.0 + (UDFToDouble(key) / 2.0)) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT 1 + (key / '2.0') FROM DECIMAL_UDF @@ -1208,11 +1208,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: abs(key) (type: decimal(20,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT abs(key) FROM DECIMAL_UDF @@ -1276,22 +1276,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)), value (type: int) outputColumnNames: key, value - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: sum(key), count(key), avg(key) keys: value (type: int) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: decimal(30,10)), _col2 (type: bigint), _col3 (type: struct<count:bigint,sum:decimal(30,10),input:decimal(20,10)>) Reduce Operator Tree: Group By Operator @@ -1299,11 +1299,11 @@ STAGE PLANS: keys: KEY._col0 (type: int) mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: int), (_col1 / CAST( _col2 AS decimal(19,0))) (type: decimal(38,18)), _col3 (type: decimal(24,14)), _col1 (type: decimal(30,10)) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -1318,16 +1318,16 @@ STAGE PLANS: Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: decimal(38,18)), _col2 (type: decimal(24,14)), _col3 (type: decimal(30,10)) Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: decimal(38,18)), VALUE._col1 (type: decimal(24,14)), VALUE._col2 (type: decimal(30,10)) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -1378,11 +1378,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: (- key) (type: decimal(20,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT -key FROM DECIMAL_UDF @@ -1445,11 +1445,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT +key FROM DECIMAL_UDF @@ -1512,11 +1512,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ceil(key) (type: decimal(11,0)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT CEIL(key) FROM DECIMAL_UDF @@ -1579,11 +1579,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: floor(key) (type: decimal(11,0)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT FLOOR(key) FROM DECIMAL_UDF @@ -1646,11 +1646,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: round(key, 2) (type: decimal(13,2)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT ROUND(key, 2) FROM DECIMAL_UDF @@ -1713,11 +1713,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: power(key, 2) (type: double) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT POWER(key, 2) FROM DECIMAL_UDF @@ -1780,11 +1780,11 @@ STAGE PLANS: Processor Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: ((key + 1) % (key / 2)) (type: decimal(22,12)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE ListSink PREHOOK: query: SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF @@ -1847,22 +1847,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)), value (type: int) outputColumnNames: key, value - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: stddev(key), variance(key) keys: value (type: int) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>) Reduce Operator Tree: Group By Operator @@ -1870,10 +1870,10 @@ STAGE PLANS: keys: KEY._col0 (type: int) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -1924,22 +1924,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)), value (type: int) outputColumnNames: key, value - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: stddev_samp(key), var_samp(key) keys: value (type: int) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: struct<count:bigint,sum:double,variance:double>), _col2 (type: struct<count:bigint,sum:double,variance:double>) Reduce Operator Tree: Group By Operator @@ -1947,10 +1947,10 @@ STAGE PLANS: keys: KEY._col0 (type: int) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -2001,11 +2001,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: histogram_numeric(_col0, 3) mode: hash @@ -2058,11 +2058,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)) outputColumnNames: key - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: min(key) mode: hash @@ -2115,11 +2115,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)) outputColumnNames: key - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: max(key) mode: hash @@ -2172,11 +2172,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: decimal(20,10)) outputColumnNames: key - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(key) mode: hash http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/decimal_udf2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_udf2.q.out b/ql/src/test/results/clientpositive/decimal_udf2.q.out index 948132f..b6c2db5 100644 --- a/ql/src/test/results/clientpositive/decimal_udf2.q.out +++ b/ql/src/test/results/clientpositive/decimal_udf2.q.out @@ -42,17 +42,17 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf2 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 10) (type: boolean) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: null (type: double), null (type: double), 1.4711276743037347 (type: double), -0.8390715290764524 (type: double), -0.5440211108893698 (type: double), 0.6483608274590866 (type: double), 0.17453292519943295 (type: double) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -99,17 +99,17 @@ STAGE PLANS: Map Operator Tree: TableScan alias: decimal_udf2 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 10) (type: boolean) - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: 22026.465794806718 (type: double), 2.302585092994046 (type: double), 2.302585092994046 (type: double), 1.0 (type: double), log(10, value) (type: double), log(value, 10) (type: double), 1.0 (type: double), 3.1622776601683795 (type: double) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 359 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 3590 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out b/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out index b8113ee..c2226f6 100644 --- a/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out +++ b/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out @@ -79,11 +79,11 @@ STAGE PLANS: Map Operator Tree: TableScan alias: uservisits_web_text_none - Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: sourceip (type: string), adrevenue (type: float), avgtimeonsite (type: int) outputColumnNames: sourceip, adrevenue, avgtimeonsite - Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: compute_stats(sourceip, 'hll'), compute_stats(avgtimeonsite, 'hll'), compute_stats(adrevenue, 'hll') mode: hash @@ -131,13 +131,13 @@ STAGE PLANS: Map Operator Tree: TableScan alias: uservisits_web_text_none - Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE Statistics Aggregation Key Prefix: default.uservisits_web_text_none/ GatherStats: true Select Operator expressions: sourceip (type: string), adrevenue (type: float), avgtimeonsite (type: int) outputColumnNames: sourceip, adrevenue, avgtimeonsite - Statistics: Num rows: 1 Data size: 7060 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 70600 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: compute_stats(sourceip, 'hll'), compute_stats(avgtimeonsite, 'hll'), compute_stats(adrevenue, 'hll') mode: hash http://git-wip-us.apache.org/repos/asf/hive/blob/e26b9325/ql/src/test/results/clientpositive/distinct_windowing.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/distinct_windowing.q.out b/ql/src/test/results/clientpositive/distinct_windowing.q.out index 09fb24c..ab9d4a0 100644 --- a/ql/src/test/results/clientpositive/distinct_windowing.q.out +++ b/ql/src/test/results/clientpositive/distinct_windowing.q.out @@ -61,18 +61,18 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: si (type: smallint), i (type: int) sort order: ++ Map-reduce partition columns: si (type: smallint) - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE value expressions: t (type: tinyint) Reduce Operator Tree: Select Operator expressions: VALUE._col0 (type: tinyint), KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -92,16 +92,16 @@ STAGE PLANS: name: first_value window function: GenericUDAFFirstValueEvaluator window frame: RANGE PRECEDING(MAX)~CURRENT - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: first_value_window_0 (type: tinyint) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col0 (type: tinyint) mode: hash outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -117,20 +117,20 @@ STAGE PLANS: key expressions: _col0 (type: tinyint) sort order: + Map-reduce partition columns: _col0 (type: tinyint) - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE TopN Hash Memory Usage: 0.1 Reduce Operator Tree: Group By Operator keys: KEY._col0 (type: tinyint) mode: mergepartial outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 10 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -179,17 +179,17 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: si (type: smallint), i (type: int) sort order: ++ Map-reduce partition columns: si (type: smallint) - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int) outputColumnNames: _col1, _col2 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -209,16 +209,16 @@ STAGE PLANS: name: last_value window function: GenericUDAFLastValueEvaluator window frame: RANGE PRECEDING(MAX)~CURRENT - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: last_value_window_0 (type: int) outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col0 (type: int) mode: hash outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -234,20 +234,20 @@ STAGE PLANS: key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE TopN Hash Memory Usage: 0.1 Reduce Operator Tree: Group By Operator keys: KEY._col0 (type: int) mode: mergepartial outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 10 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -300,18 +300,18 @@ STAGE PLANS: Map Operator Tree: TableScan alias: over10k - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: si (type: smallint), i (type: int) sort order: ++ Map-reduce partition columns: si (type: smallint) - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE value expressions: t (type: tinyint) Reduce Operator Tree: Select Operator expressions: VALUE._col0 (type: tinyint), KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE PTF Operator Function definitions: Input definition @@ -337,16 +337,16 @@ STAGE PLANS: name: first_value window function: GenericUDAFFirstValueEvaluator window frame: RANGE PRECEDING(MAX)~CURRENT - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: last_value_window_0 (type: int), first_value_window_1 (type: tinyint) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col0 (type: int), _col1 (type: tinyint) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -362,20 +362,20 @@ STAGE PLANS: key expressions: _col0 (type: int), _col1 (type: tinyint) sort order: ++ Map-reduce partition columns: _col0 (type: int), _col1 (type: tinyint) - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE TopN Hash Memory Usage: 0.1 Reduce Operator Tree: Group By Operator keys: KEY._col0 (type: int), KEY._col1 (type: tinyint) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 50 - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 10175440 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
