Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out?rev=1550837&r1=1550836&r2=1550837&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out Fri Dec 13 20:55:40 2013 @@ -72,6 +72,7 @@ Table: fact_daily Protect Mode: None #### A masked pattern was here #### Partition Parameters: + COLUMN_STATS_ACCURATE true numFiles 3 numRows 500 rawDataSize 5312 @@ -130,12 +131,16 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (value = 'val_484') type: boolean + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: key @@ -143,6 +148,8 @@ STAGE PLANS: expr: value type: string outputColumnNames: _col0, _col1 + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -150,6 +157,8 @@ STAGE PLANS: expr: _col1 type: string sort order: ++ + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -168,6 +177,7 @@ STAGE PLANS: ds 1 hr 4 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -192,15 +202,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 3 - numPartitions 1 - numRows 500 partition_columns ds/hr - rawDataSize 5312 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -214,6 +219,7 @@ STAGE PLANS: ds 1 hr 4 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -238,15 +244,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 3 - numPartitions 1 - numRows 500 partition_columns ds/hr - rawDataSize 5312 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -257,11 +258,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -282,7 +287,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: -- List Bucketing Query SELECT key, value FROM fact_daily WHERE ds='1' and hr='4' and value= 'val_484' ORDER BY key, value PREHOOK: type: QUERY @@ -322,22 +326,30 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (key = '406') type: boolean + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: key type: string outputColumnNames: _col0 + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 type: string sort order: + + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -354,6 +366,7 @@ STAGE PLANS: ds 1 hr 4 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -378,15 +391,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 3 - numPartitions 1 - numRows 500 partition_columns ds/hr - rawDataSize 5312 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -396,11 +404,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -421,7 +433,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: -- List Bucketing Query SELECT key, value FROM fact_daily WHERE ds='1' and hr='4' and key= '406' ORDER BY key PREHOOK: type: QUERY @@ -464,12 +475,16 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (((key = '484') and (value = 'val_484')) or ((key = '238') and (value = 'val_238'))) type: boolean + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: key @@ -477,6 +492,8 @@ STAGE PLANS: expr: value type: string outputColumnNames: _col0, _col1 + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -484,6 +501,8 @@ STAGE PLANS: expr: _col1 type: string sort order: ++ + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -502,6 +521,7 @@ STAGE PLANS: ds 1 hr 4 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -526,15 +546,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 3 - numPartitions 1 - numRows 500 partition_columns ds/hr - rawDataSize 5312 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -548,6 +563,7 @@ STAGE PLANS: ds 1 hr 4 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -572,15 +588,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 3 - numPartitions 1 - numRows 500 partition_columns ds/hr - rawDataSize 5312 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -591,11 +602,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -616,7 +631,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: -- List Bucketing Query SELECT key, value FROM fact_daily WHERE ds='1' and hr='4' and ( (key='484' and value ='val_484') or (key='238' and value= 'val_238')) ORDER BY key, value PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out?rev=1550837&r1=1550836&r2=1550837&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out Fri Dec 13 20:55:40 2013 @@ -74,6 +74,7 @@ Table: fact_daily Protect Mode: None #### A masked pattern was here #### Partition Parameters: + COLUMN_STATS_ACCURATE true numFiles 1 numRows 500 rawDataSize 5312 @@ -143,6 +144,7 @@ Table: fact_daily Protect Mode: None #### A masked pattern was here #### Partition Parameters: + COLUMN_STATS_ACCURATE true numFiles 3 numRows 500 rawDataSize 5312 @@ -223,6 +225,7 @@ Table: fact_daily Protect Mode: None #### A masked pattern was here #### Partition Parameters: + COLUMN_STATS_ACCURATE true numFiles 2 numRows 500 rawDataSize 5312 @@ -272,12 +275,16 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (key = '145') type: boolean + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: key @@ -289,11 +296,15 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 250 dataSize: 2656 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -321,6 +332,7 @@ STAGE PLANS: ds 1 hr 1 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -345,15 +357,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 6 - numPartitions 3 - numRows 1500 partition_columns ds/hr - rawDataSize 15936 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 17436 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -365,7 +372,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: select * from fact_daily where ds = '1' and hr='1' and key='145' PREHOOK: type: QUERY PREHOOK: Input: default@fact_daily @@ -409,16 +415,24 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: COMPLETE GatherStats: false Select Operator + Statistics: + numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: COMPLETE Group By Operator aggregations: expr: count() bucketGroup: false mode: hash outputColumnNames: _col0 + Statistics: + numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE Reduce Output Operator sort order: + Statistics: + numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE tag: -1 value expressions: expr: _col0 @@ -435,6 +449,7 @@ STAGE PLANS: ds 1 hr 1 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -459,15 +474,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 6 - numPartitions 3 - numRows 1500 partition_columns ds/hr - rawDataSize 15936 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 17436 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -482,16 +492,22 @@ STAGE PLANS: bucketGroup: false mode: mergepartial outputColumnNames: _col0 + Statistics: + numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE Select Operator expressions: expr: _col0 type: bigint outputColumnNames: _col0 + Statistics: + numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 1 dataSize: 8 basicStatsState: COMPLETE colStatsState: COMPLETE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -512,7 +528,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: select count(*) from fact_daily where ds = '1' and hr='1' PREHOOK: type: QUERY PREHOOK: Input: default@fact_daily @@ -558,12 +573,16 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: ((key = '484') and (value = 'val_484')) type: boolean + Statistics: + numRows: 125 dataSize: 1328 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: key @@ -575,11 +594,15 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 125 dataSize: 1328 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 125 dataSize: 1328 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -607,6 +630,7 @@ STAGE PLANS: ds 1 hr 2 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -631,15 +655,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 6 - numPartitions 3 - numRows 1500 partition_columns ds/hr - rawDataSize 15936 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 17436 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -651,7 +670,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: SELECT * FROM fact_daily WHERE ds='1' and hr='2' and (key='484' and value='val_484') PREHOOK: type: QUERY PREHOOK: Input: default@fact_daily @@ -697,12 +715,16 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 500 dataSize: 5312 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: ((key = '327') and (value = 'val_327')) type: boolean + Statistics: + numRows: 125 dataSize: 1328 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: key @@ -714,11 +736,15 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 125 dataSize: 1328 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 125 dataSize: 1328 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -746,6 +772,7 @@ STAGE PLANS: ds 1 hr 3 properties: + COLUMN_STATS_ACCURATE true bucket_count -1 columns key,value columns.types string:string @@ -770,15 +797,10 @@ STAGE PLANS: columns.types string:string #### A masked pattern was here #### name default.fact_daily - numFiles 6 - numPartitions 3 - numRows 1500 partition_columns ds/hr - rawDataSize 15936 serialization.ddl struct fact_daily { string key, string value} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 17436 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.fact_daily @@ -790,7 +812,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: SELECT * FROM fact_daily WHERE ds='1' and hr='3' and (key='327' and value='val_327') PREHOOK: type: QUERY PREHOOK: Input: default@fact_daily Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out?rev=1550837&r1=1550836&r2=1550837&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out Fri Dec 13 20:55:40 2013 @@ -135,6 +135,12 @@ Table: fact_daily Protect Mode: None #### A masked pattern was here #### Partition Parameters: + COLUMN_STATS_ACCURATE false +#### A masked pattern was here #### + numFiles 2 + numRows -1 + rawDataSize -1 + totalSize 8 #### A masked pattern was here #### # Storage Information @@ -188,22 +194,30 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 2 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (x = 484) type: boolean + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: x type: int outputColumnNames: _col0 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -230,15 +244,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x columns.types int #### A masked pattern was here #### name default.fact_daily + numFiles 2 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 8 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -305,22 +324,30 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 2 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (x = 495) type: boolean + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: x type: int outputColumnNames: _col0 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -347,15 +374,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x columns.types int #### A masked pattern was here #### name default.fact_daily + numFiles 2 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 8 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -418,22 +450,30 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 2 dataSize: 8 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (x = 1) type: boolean + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: x type: int outputColumnNames: _col0 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -460,15 +500,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x columns.types int #### A masked pattern was here #### name default.fact_daily + numFiles 2 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 8 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out?rev=1550837&r1=1550836&r2=1550837&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out Fri Dec 13 20:55:40 2013 @@ -151,6 +151,12 @@ Table: fact_daily Protect Mode: None #### A masked pattern was here #### Partition Parameters: + COLUMN_STATS_ACCURATE false +#### A masked pattern was here #### + numFiles 2 + numRows -1 + rawDataSize -1 + totalSize 24 #### A masked pattern was here #### # Storage Information @@ -208,22 +214,30 @@ STAGE PLANS: subq:fact_daily TableScan alias: fact_daily + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (x = 484) type: boolean + Statistics: + numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: x type: int outputColumnNames: _col0 + Statistics: + numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -250,15 +264,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x,y columns.types int:string #### A masked pattern was here #### name default.fact_daily + numFiles 2 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x, string y} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 24 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -329,12 +348,16 @@ STAGE PLANS: subq:fact_daily TableScan alias: fact_daily + Statistics: + numRows: 0 dataSize: 24 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (x = 484) type: boolean + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE Select Operator expressions: expr: x @@ -342,6 +365,8 @@ STAGE PLANS: expr: y type: string outputColumnNames: _col0, _col1 + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -349,6 +374,8 @@ STAGE PLANS: expr: _col1 type: string sort order: ++ + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -366,15 +393,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x,y columns.types int:string #### A masked pattern was here #### name default.fact_daily + numFiles 2 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x, string y} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 24 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -400,11 +432,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -425,7 +461,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: -- List Bucketing Query select x1, y1 from(select x as x1, y as y1 from fact_daily where ds ='1') subq where x1 = 484 ORDER BY x1, y1 PREHOOK: type: QUERY @@ -469,17 +504,23 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 0 dataSize: 24 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (x = 484) type: boolean + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE Select Operator expressions: expr: y type: string outputColumnNames: y + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -489,6 +530,8 @@ STAGE PLANS: type: string mode: hash outputColumnNames: _col0, _col1 + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -497,6 +540,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: string + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE tag: -1 value expressions: expr: _col1 @@ -512,15 +557,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x,y columns.types int:string #### A masked pattern was here #### name default.fact_daily + numFiles 2 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x, string y} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 24 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -554,6 +604,8 @@ STAGE PLANS: type: string mode: mergepartial outputColumnNames: _col0, _col1 + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -561,11 +613,15 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -586,7 +642,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: -- List Bucketing Query select y, count(1) from fact_daily where ds ='1' and x = 484 group by y PREHOOK: type: QUERY @@ -630,17 +685,23 @@ STAGE PLANS: subq:fact_daily TableScan alias: fact_daily + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (x = 484) type: boolean + Statistics: + numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: x type: int outputColumnNames: x + Statistics: + numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -650,6 +711,8 @@ STAGE PLANS: type: int mode: hash outputColumnNames: _col0, _col1 + Statistics: + numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -658,6 +721,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: int + Statistics: + numRows: 3 dataSize: 12 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col1 @@ -673,15 +738,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x,y columns.types int:string #### A masked pattern was here #### name default.fact_daily + numFiles 2 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x, string y} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 24 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -715,6 +785,8 @@ STAGE PLANS: type: int mode: mergepartial outputColumnNames: _col0, _col1 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -722,11 +794,15 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 1 dataSize: 4 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -747,7 +823,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: -- List Bucketing Query select x, c from (select x, count(1) as c from fact_daily where ds = '1' group by x) subq where x = 484 PREHOOK: type: QUERY Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out?rev=1550837&r1=1550836&r2=1550837&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out Fri Dec 13 20:55:40 2013 @@ -201,6 +201,12 @@ Table: fact_daily Protect Mode: None #### A masked pattern was here #### Partition Parameters: + COLUMN_STATS_ACCURATE false +#### A masked pattern was here #### + numFiles 3 + numRows -1 + rawDataSize -1 + totalSize 117 #### A masked pattern was here #### # Storage Information @@ -272,22 +278,30 @@ STAGE PLANS: fact_daily TableScan alias: fact_daily + Statistics: + numRows: 29 dataSize: 117 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (not (x = 86)) type: boolean + Statistics: + numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: x type: int outputColumnNames: _col0 + Statistics: + numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 type: int sort order: + + Statistics: + numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -303,15 +317,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x,y,z columns.types int:string:string #### A masked pattern was here #### name default.fact_daily + numFiles 3 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x, string y, string z} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 117 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -340,15 +359,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x,y,z columns.types int:string:string #### A masked pattern was here #### name default.fact_daily + numFiles 3 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x, string y, string z} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 117 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -377,15 +401,20 @@ STAGE PLANS: partition values: ds 1 properties: + COLUMN_STATS_ACCURATE false bucket_count -1 columns x,y,z columns.types int:string:string #### A masked pattern was here #### name default.fact_daily + numFiles 3 + numRows -1 partition_columns ds + rawDataSize -1 serialization.ddl struct fact_daily { i32 x, string y, string z} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + totalSize 117 #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe @@ -413,11 +442,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 15 dataSize: 60 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -438,7 +471,6 @@ STAGE PLANS: Fetch Operator limit: -1 - PREHOOK: query: -- List Bucketing Query SELECT x FROM fact_daily WHERE ds='1' and not (x = 86) ORDER BY x PREHOOK: type: QUERY
