http://git-wip-us.apache.org/repos/asf/hive/blob/ba54eb5d/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out b/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out index 8695e25..f7c1cfc 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out @@ -145,12 +145,12 @@ STAGE PLANS: b TableScan alias: b - Statistics: Num rows: 140 Data size: 42000 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 140 Data size: 42000 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: key is not null (type: boolean) - Statistics: Num rows: 140 Data size: 42000 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 140 Data size: 42000 Basic stats: PARTIAL Column stats: NONE HashTable Sink Operator keys: 0 key (type: int) @@ -176,17 +176,17 @@ STAGE PLANS: 1 key (type: int) outputColumnNames: _col0, _col1, _col6 Position of Big Table: 0 - Statistics: Num rows: 154 Data size: 46200 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 154 Data size: 46200 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: UDFToString(_col0) (type: string), _col1 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 154 Data size: 46200 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 154 Data size: 46200 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 154 Data size: 46200 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 154 Data size: 46200 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -217,16 +217,16 @@ STAGE PLANS: Select Operator expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) outputColumnNames: key, value1, value2 - Statistics: Num rows: 154 Data size: 46200 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 154 Data size: 46200 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(key, 'hll'), compute_stats(value1, 'hll'), compute_stats(value2, 'hll') mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1320 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator null sort order: sort order: - Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1320 Basic stats: PARTIAL Column stats: NONE tag: -1 value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>) auto parallelism: false @@ -291,13 +291,13 @@ STAGE PLANS: aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1320 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1320 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/ba54eb5d/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out b/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out index 4398379..c92d0e5 100644 --- a/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out +++ b/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out @@ -201,12 +201,12 @@ STAGE PLANS: b TableScan alias: b - Statistics: Num rows: 156 Data size: 61240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 156 Data size: 61240 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: key is not null (type: boolean) - Statistics: Num rows: 156 Data size: 61240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 156 Data size: 61240 Basic stats: PARTIAL Column stats: NONE HashTable Sink Operator keys: 0 key (type: int) @@ -239,18 +239,18 @@ STAGE PLANS: 1 key (type: int) outputColumnNames: _col0, _col1, _col6 Position of Big Table: 0 - Statistics: Num rows: 171 Data size: 67364 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 171 Data size: 67364 Basic stats: PARTIAL Column stats: NONE BucketMapJoin: true Select Operator expressions: UDFToString(_col0) (type: string), _col1 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 171 Data size: 67364 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 171 Data size: 67364 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 171 Data size: 67364 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 171 Data size: 67364 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -281,16 +281,16 @@ STAGE PLANS: Select Operator expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) outputColumnNames: key, value1, value2 - Statistics: Num rows: 171 Data size: 67364 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 171 Data size: 67364 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(key, 'hll'), compute_stats(value1, 'hll'), compute_stats(value2, 'hll') mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1320 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator null sort order: sort order: - Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1320 Basic stats: PARTIAL Column stats: NONE tag: -1 value expressions: _col0 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>) auto parallelism: false @@ -355,13 +355,13 @@ STAGE PLANS: aggregations: compute_stats(VALUE._col0), compute_stats(VALUE._col1), compute_stats(VALUE._col2) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1320 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 1 Data size: 1320 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 1320 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat http://git-wip-us.apache.org/repos/asf/hive/blob/ba54eb5d/ql/src/test/results/clientpositive/columnstats_partlvl.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/columnstats_partlvl.q.out b/ql/src/test/results/clientpositive/columnstats_partlvl.q.out index ca07f61..1d01c7b 100644 --- a/ql/src/test/results/clientpositive/columnstats_partlvl.q.out +++ b/ql/src/test/results/clientpositive/columnstats_partlvl.q.out @@ -46,22 +46,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: employeeid (type: int) outputColumnNames: employeeid - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(employeeid, 'hll') keys: 2000.0D (type: double) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: 2000.0D (type: double) sort order: + Map-reduce partition columns: 2000.0D (type: double) - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE value expressions: _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>) Reduce Operator Tree: Group By Operator @@ -69,14 +69,14 @@ STAGE PLANS: keys: 2000.0D (type: double) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), 2000.0D (type: double) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -106,25 +106,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Statistics Aggregation Key Prefix: default.employee_part/ GatherStats: true Select Operator expressions: employeeid (type: int) outputColumnNames: employeeid - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(employeeid, 'hll') keys: 2000.0D (type: double) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: 2000.0D (type: double) null sort order: a sort order: + Map-reduce partition columns: 2000.0D (type: double) - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE tag: -1 value expressions: _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>) auto parallelism: false @@ -189,17 +189,17 @@ STAGE PLANS: keys: 2000.0D (type: double) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), 2000.0D (type: double) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat @@ -295,22 +295,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: employeeid (type: int) outputColumnNames: employeeid - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(employeeid, 'hll') keys: 4000.0D (type: double) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: 4000.0D (type: double) sort order: + Map-reduce partition columns: 4000.0D (type: double) - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE value expressions: _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>) Reduce Operator Tree: Group By Operator @@ -318,14 +318,14 @@ STAGE PLANS: keys: 4000.0D (type: double) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), 4000.0D (type: double) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -355,25 +355,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Statistics Aggregation Key Prefix: default.employee_part/ GatherStats: true Select Operator expressions: employeeid (type: int) outputColumnNames: employeeid - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(employeeid, 'hll') keys: 4000.0D (type: double) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: 4000.0D (type: double) null sort order: a sort order: + Map-reduce partition columns: 4000.0D (type: double) - Statistics: Num rows: 3 Data size: 1050 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1050 Basic stats: PARTIAL Column stats: NONE tag: -1 value expressions: _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>) auto parallelism: false @@ -438,17 +438,17 @@ STAGE PLANS: keys: 4000.0D (type: double) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col1 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), 4000.0D (type: double) outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 1 Data size: 350 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 350 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat http://git-wip-us.apache.org/repos/asf/hive/blob/ba54eb5d/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out b/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out index 25194d3..7d83d6e 100644 --- a/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out +++ b/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out @@ -82,22 +82,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part_n0 - Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 640 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: employeeid (type: int), employeename (type: string), country (type: string) outputColumnNames: employeeid, employeename, country - Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 640 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(employeename, 'hll'), compute_stats(employeeid, 'hll') keys: 4000.0D (type: double), country (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 640 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: 4000.0D (type: double), _col1 (type: string) sort order: ++ Map-reduce partition columns: 4000.0D (type: double), _col1 (type: string) - Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 640 Basic stats: PARTIAL Column stats: NONE value expressions: _col2 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col3 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>) Reduce Operator Tree: Group By Operator @@ -105,14 +105,14 @@ STAGE PLANS: keys: 4000.0D (type: double), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 640 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col2 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col3 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), 4000.0D (type: double), _col1 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 640 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 640 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 640 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -213,22 +213,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part_n0 - Statistics: Num rows: 3 Data size: 1690 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1690 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: employeeid (type: int), country (type: string) outputColumnNames: employeeid, country - Statistics: Num rows: 3 Data size: 1690 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1690 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(employeeid, 'hll') keys: 2000.0D (type: double), country (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 3 Data size: 1690 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1690 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: 2000.0D (type: double), _col1 (type: string) sort order: ++ Map-reduce partition columns: 2000.0D (type: double), _col1 (type: string) - Statistics: Num rows: 3 Data size: 1690 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 3 Data size: 1690 Basic stats: PARTIAL Column stats: NONE value expressions: _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>) Reduce Operator Tree: Group By Operator @@ -236,14 +236,14 @@ STAGE PLANS: keys: 2000.0D (type: double), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 563 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 563 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), 2000.0D (type: double), _col1 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 1 Data size: 563 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 563 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 1 Data size: 563 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 563 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -327,22 +327,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: employee_part_n0 - Statistics: Num rows: 27 Data size: 206 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 31 Data size: 2536 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: employeeid (type: int), employeesalary (type: double), country (type: string) outputColumnNames: employeeid, employeesalary, country - Statistics: Num rows: 27 Data size: 206 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 31 Data size: 2536 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(employeeid, 'hll') keys: employeesalary (type: double), country (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 27 Data size: 206 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 31 Data size: 2536 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: _col0 (type: double), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: double), _col1 (type: string) - Statistics: Num rows: 27 Data size: 206 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 31 Data size: 2536 Basic stats: PARTIAL Column stats: NONE value expressions: _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>) Reduce Operator Tree: Group By Operator @@ -350,14 +350,14 @@ STAGE PLANS: keys: KEY._col0 (type: double), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 13 Data size: 99 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 15 Data size: 1227 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: double), _col1 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 13 Data size: 99 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 15 Data size: 1227 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 13 Data size: 99 Basic stats: PARTIAL Column stats: NONE + Statistics: Num rows: 15 Data size: 1227 Basic stats: PARTIAL 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/ba54eb5d/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out b/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out index 52ede72..e04939b 100644 --- a/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out +++ b/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out @@ -427,22 +427,22 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart - Statistics: Num rows: 198 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 198 Data size: 116240 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: key (type: string) outputColumnNames: key - Statistics: Num rows: 198 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 198 Data size: 116240 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: count() keys: key (type: string) mode: hash outputColumnNames: _col0, _col1 - Statistics: Num rows: 198 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 198 Data size: 116240 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 198 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 198 Data size: 116240 Basic stats: PARTIAL Column stats: NONE value expressions: _col1 (type: bigint) Execution mode: vectorized Reduce Operator Tree: @@ -451,14 +451,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 - Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 99 Data size: 58120 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col0 (type: string), UDFToString(_col1) (type: string), if(((UDFToDouble(_col0) % 100.0D) = 0.0D), '11', '12') (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 99 Data size: 58120 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 99 Data size: 58120 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat @@ -467,13 +467,13 @@ STAGE PLANS: Select Operator expressions: _col0 (type: string), _col1 (type: string), '2008-04-08' (type: string), _col2 (type: string) outputColumnNames: key, value, ds, hr - Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 99 Data size: 58120 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll') keys: ds (type: string), hr (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 99 Data size: 58120 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false table: @@ -539,7 +539,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: 99 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 99 Data size: 58120 Basic stats: PARTIAL Column stats: NONE value expressions: _col2 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col3 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>) Execution mode: vectorized Reduce Operator Tree: @@ -548,14 +548,14 @@ STAGE PLANS: keys: KEY._col0 (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 49 Data size: 28766 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 49 Data size: 28766 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col2 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col3 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 49 Data size: 28766 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 49 Data size: 28766 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 49 Data size: 28766 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 49 Data size: 28766 Basic stats: PARTIAL 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/ba54eb5d/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out b/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out index 3740cdb..4f427c5 100644 --- a/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out +++ b/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out @@ -34,25 +34,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: srcpart - Statistics: Num rows: 234 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 234 Data size: 116240 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: if(((key % 3) < 2), 0, 1) (type: int), value (type: string), UDFToInteger((key % 2)) (type: int) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 234 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 234 Data size: 116240 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator sort order: Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 234 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 234 Data size: 116240 Basic stats: PARTIAL Column stats: NONE value expressions: _col0 (type: int), _col1 (type: string), _col2 (type: int) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: VALUE._col0 (type: int), VALUE._col1 (type: string), VALUE._col2 (type: int) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 234 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 234 Data size: 116240 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 234 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 234 Data size: 116240 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -61,13 +61,13 @@ STAGE PLANS: Select Operator expressions: _col0 (type: int), _col1 (type: string), UDFToString(_col2) (type: string) outputColumnNames: key, value, hr - Statistics: Num rows: 234 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 234 Data size: 116240 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(key, 'hll'), compute_stats(value, 'hll') keys: '2008-04-08' (type: string), hr (type: string) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 234 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 234 Data size: 116240 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false table: @@ -104,7 +104,7 @@ STAGE PLANS: key expressions: '2008-04-08' (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: '2008-04-08' (type: string), _col1 (type: string) - Statistics: Num rows: 234 Data size: 116240 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 234 Data size: 116240 Basic stats: PARTIAL Column stats: NONE value expressions: _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,bitvector:binary>), _col3 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>) Execution mode: vectorized Reduce Operator Tree: @@ -113,14 +113,14 @@ STAGE PLANS: keys: '2008-04-08' (type: string), KEY._col1 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 117 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 117 Data size: 58120 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col2 (type: struct<columntype:string,min:bigint,max:bigint,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col3 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), '2008-04-08' (type: string), _col1 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 117 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 117 Data size: 58120 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 117 Data size: 58120 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 117 Data size: 58120 Basic stats: PARTIAL 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/ba54eb5d/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out b/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out index 8f0d998..d62b665 100644 --- a/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out +++ b/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out @@ -61,27 +61,27 @@ STAGE PLANS: Map Operator Tree: TableScan alias: sourcetable - Statistics: Num rows: 124 Data size: 60280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 124 Data size: 60280 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: one (type: string), two (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 124 Data size: 60280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 124 Data size: 60280 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: -- - Statistics: Num rows: 124 Data size: 60280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 124 Data size: 60280 Basic stats: PARTIAL Column stats: NONE Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 124 Data size: 60280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 124 Data size: 60280 Basic stats: PARTIAL Column stats: NONE Limit Number of rows: 5 - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -90,13 +90,13 @@ STAGE PLANS: Select Operator expressions: _col0 (type: string), _col1 (type: string), '2011-11-11' (type: string) outputColumnNames: one, two, ds - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(one, 'hll'), compute_stats(two, 'hll') keys: ds (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false table: @@ -132,7 +132,7 @@ STAGE PLANS: key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE value expressions: _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>) Execution mode: vectorized Reduce Operator Tree: @@ -141,14 +141,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 2 Data size: 972 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 972 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col1 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col2 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 2 Data size: 972 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 972 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 2 Data size: 972 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 972 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -201,27 +201,27 @@ STAGE PLANS: Map Operator Tree: TableScan alias: sourcetable - Statistics: Num rows: 124 Data size: 60280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 124 Data size: 60280 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: one (type: string), two (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 124 Data size: 60280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 124 Data size: 60280 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: -- - Statistics: Num rows: 124 Data size: 60280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 124 Data size: 60280 Basic stats: PARTIAL Column stats: NONE Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 124 Data size: 60280 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 124 Data size: 60280 Basic stats: PARTIAL Column stats: NONE Limit Number of rows: 5 - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -230,13 +230,13 @@ STAGE PLANS: Select Operator expressions: _col0 (type: string), _col1 (type: string), '2011-11-11' (type: string) outputColumnNames: one, two, ds - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: compute_stats(one, 'hll'), compute_stats(two, 'hll') keys: ds (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false table: @@ -272,7 +272,7 @@ STAGE PLANS: key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 5 Data size: 2430 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 5 Data size: 2430 Basic stats: PARTIAL Column stats: NONE value expressions: _col1 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>), _col2 (type: struct<columntype:string,maxlength:bigint,sumlength:bigint,count:bigint,countnulls:bigint,bitvector:binary>) Execution mode: vectorized Reduce Operator Tree: @@ -281,14 +281,14 @@ STAGE PLANS: keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 2 Data size: 972 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 972 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: _col1 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col2 (type: struct<columntype:string,maxlength:bigint,avglength:double,countnulls:bigint,numdistinctvalues:bigint,ndvbitvector:binary>), _col0 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 2 Data size: 972 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 972 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 2 Data size: 972 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 972 Basic stats: PARTIAL 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/ba54eb5d/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out index 59aeda8..2e1ceda 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out @@ -209,16 +209,16 @@ STAGE PLANS: Processor Tree: TableScan alias: fact_daily_n0 - Statistics: Num rows: 2 Data size: 1170 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1170 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: (x <> 86) (type: boolean) - Statistics: Num rows: 2 Data size: 1170 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1170 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: x (type: int) outputColumnNames: _col0 - Statistics: Num rows: 2 Data size: 1170 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1170 Basic stats: PARTIAL Column stats: NONE ListSink PREHOOK: query: SELECT x FROM fact_daily_n0 WHERE ds='1' and not (x = 86) http://git-wip-us.apache.org/repos/asf/hive/blob/ba54eb5d/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out index fd6ae5f..c44a463 100644 --- a/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out +++ b/ql/src/test/results/clientpositive/llap/auto_sortmerge_join_1.q.out @@ -119,16 +119,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: key is not null (type: boolean) - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: key (type: string) outputColumnNames: _col0 - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE Path -> Alias: #### A masked pattern was here #### Path -> Partition: @@ -186,16 +186,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 240 Data size: 158376 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: key is not null (type: boolean) - Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 228 Data size: 150457 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: key (type: string) outputColumnNames: _col0 - Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 228 Data size: 150457 Basic stats: PARTIAL Column stats: NONE Merge Join Operator condition map: Inner Join 0 to 1 @@ -203,16 +203,16 @@ STAGE PLANS: 0 _col0 (type: string) 1 _col0 (type: string) Position of Big Table: 1 - Statistics: Num rows: 250 Data size: 165502 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 165502 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: count() mode: hash outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator null sort order: sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE tag: -1 value expressions: _col0 (type: bigint) auto parallelism: false @@ -329,13 +329,13 @@ STAGE PLANS: aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat @@ -396,16 +396,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: key is not null (type: boolean) - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: key (type: string) outputColumnNames: _col0 - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE Path -> Alias: #### A masked pattern was here #### Path -> Partition: @@ -463,16 +463,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a - Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 240 Data size: 158376 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: key is not null (type: boolean) - Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 228 Data size: 150457 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: key (type: string) outputColumnNames: _col0 - Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 228 Data size: 150457 Basic stats: PARTIAL Column stats: NONE Merge Join Operator condition map: Inner Join 0 to 1 @@ -480,16 +480,16 @@ STAGE PLANS: 0 _col0 (type: string) 1 _col0 (type: string) Position of Big Table: 0 - Statistics: Num rows: 250 Data size: 165502 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 165502 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: count() mode: hash outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator null sort order: sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE tag: -1 value expressions: _col0 (type: bigint) auto parallelism: false @@ -606,13 +606,13 @@ STAGE PLANS: aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat @@ -673,16 +673,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: key is not null (type: boolean) - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: key (type: string) outputColumnNames: _col0 - Statistics: Num rows: 2 Data size: 1508 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2 Data size: 1508 Basic stats: PARTIAL Column stats: NONE Path -> Alias: #### A masked pattern was here #### Path -> Partition: @@ -740,16 +740,16 @@ STAGE PLANS: Map Operator Tree: TableScan alias: a - Statistics: Num rows: 240 Data size: 158376 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 240 Data size: 158376 Basic stats: PARTIAL Column stats: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: key is not null (type: boolean) - Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 228 Data size: 150457 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: key (type: string) outputColumnNames: _col0 - Statistics: Num rows: 228 Data size: 150457 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 228 Data size: 150457 Basic stats: PARTIAL Column stats: NONE Merge Join Operator condition map: Inner Join 0 to 1 @@ -757,16 +757,16 @@ STAGE PLANS: 0 _col0 (type: string) 1 _col0 (type: string) Position of Big Table: 0 - Statistics: Num rows: 250 Data size: 165502 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 250 Data size: 165502 Basic stats: PARTIAL Column stats: NONE Group By Operator aggregations: count() mode: hash outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator null sort order: sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE tag: -1 value expressions: _col0 (type: bigint) auto parallelism: false @@ -883,13 +883,13 @@ STAGE PLANS: aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column stats: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat