http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/bucket2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/bucket2.q.out b/ql/src/test/results/clientpositive/tez/bucket2.q.out deleted file mode 100644 index bcf9ab9..0000000 --- a/ql/src/test/results/clientpositive/tez/bucket2.q.out +++ /dev/null @@ -1,466 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE bucket2_1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@bucket2_1 -POSTHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE bucket2_1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@bucket2_1 -PREHOOK: query: explain extended -insert overwrite table bucket2_1 -select * from src -PREHOOK: type: QUERY -POSTHOOK: query: explain extended -insert overwrite table bucket2_1 -select * from src -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - Stage-3 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - null sort order: - sort order: - Map-reduce partition columns: UDFToInteger(_col0) (type: int) - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - tag: -1 - value expressions: _col0 (type: string), _col1 (type: string) - auto parallelism: false - Path -> Alias: -#### A masked pattern was here #### - Path -> Partition: -#### A masked pattern was here #### - Partition - base file name: src - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} - bucket_count -1 - columns key,value - columns.comments 'default','default' - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numRows 500 - rawDataSize 5312 - serialization.ddl struct src { 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 - - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} - bucket_count -1 - columns key,value - columns.comments 'default','default' - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numRows 500 - rawDataSize 5312 - serialization.ddl struct src { 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.src - name: default.src - Truncated Path -> Alias: - /src [src] - Reducer 2 - Needs Tagging: false - Reduce Operator Tree: - Select Operator - expressions: UDFToInteger(VALUE._col0) (type: int), VALUE._col1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - GlobalTableId: 1 -#### A masked pattern was here #### - NumFilesPerFileSink: 2 - Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count 2 - bucket_field_name key - columns key,value - columns.comments - columns.types int:string -#### A masked pattern was here #### - name default.bucket2_1 - numFiles 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct bucket2_1 { i32 key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 0 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucket2_1 - TotalFiles: 2 - GatherStats: true - MultiFileSpray: true - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: true -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count 2 - bucket_field_name key - columns key,value - columns.comments - columns.types int:string -#### A masked pattern was here #### - name default.bucket2_1 - numFiles 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct bucket2_1 { i32 key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 0 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucket2_1 - - Stage: Stage-3 - Stats-Aggr Operator -#### A masked pattern was here #### - -PREHOOK: query: insert overwrite table bucket2_1 -select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@bucket2_1 -POSTHOOK: query: insert overwrite table bucket2_1 -select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@bucket2_1 -POSTHOOK: Lineage: bucket2_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: bucket2_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: explain -select * from bucket2_1 tablesample (bucket 1 out of 2) s -PREHOOK: type: QUERY -POSTHOOK: query: explain -select * from bucket2_1 tablesample (bucket 1 out of 2) s -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - TableScan - alias: s - Filter Operator - predicate: (((hash(key) & 2147483647) % 2) = 0) (type: boolean) - Select Operator - expressions: key (type: int), value (type: string) - outputColumnNames: _col0, _col1 - ListSink - -PREHOOK: query: select * from bucket2_1 tablesample (bucket 1 out of 2) s -PREHOOK: type: QUERY -PREHOOK: Input: default@bucket2_1 -#### A masked pattern was here #### -POSTHOOK: query: select * from bucket2_1 tablesample (bucket 1 out of 2) s -POSTHOOK: type: QUERY -POSTHOOK: Input: default@bucket2_1 -#### A masked pattern was here #### -0 val_0 -0 val_0 -0 val_0 -10 val_10 -100 val_100 -100 val_100 -104 val_104 -104 val_104 -114 val_114 -116 val_116 -118 val_118 -118 val_118 -12 val_12 -12 val_12 -120 val_120 -120 val_120 -126 val_126 -128 val_128 -128 val_128 -128 val_128 -134 val_134 -134 val_134 -136 val_136 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -146 val_146 -146 val_146 -150 val_150 -152 val_152 -152 val_152 -156 val_156 -158 val_158 -160 val_160 -162 val_162 -164 val_164 -164 val_164 -166 val_166 -168 val_168 -170 val_170 -172 val_172 -172 val_172 -174 val_174 -174 val_174 -176 val_176 -176 val_176 -178 val_178 -18 val_18 -18 val_18 -180 val_180 -186 val_186 -190 val_190 -192 val_192 -194 val_194 -196 val_196 -2 val_2 -20 val_20 -200 val_200 -200 val_200 -202 val_202 -208 val_208 -208 val_208 -208 val_208 -214 val_214 -216 val_216 -216 val_216 -218 val_218 -222 val_222 -224 val_224 -224 val_224 -226 val_226 -228 val_228 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -238 val_238 -238 val_238 -24 val_24 -24 val_24 -242 val_242 -242 val_242 -244 val_244 -248 val_248 -252 val_252 -256 val_256 -256 val_256 -258 val_258 -26 val_26 -26 val_26 -260 val_260 -262 val_262 -266 val_266 -272 val_272 -272 val_272 -274 val_274 -278 val_278 -278 val_278 -28 val_28 -280 val_280 -280 val_280 -282 val_282 -282 val_282 -284 val_284 -286 val_286 -288 val_288 -288 val_288 -292 val_292 -296 val_296 -298 val_298 -298 val_298 -298 val_298 -30 val_30 -302 val_302 -306 val_306 -308 val_308 -310 val_310 -316 val_316 -316 val_316 -316 val_316 -318 val_318 -318 val_318 -318 val_318 -322 val_322 -322 val_322 -332 val_332 -336 val_336 -338 val_338 -34 val_34 -342 val_342 -342 val_342 -344 val_344 -344 val_344 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -356 val_356 -360 val_360 -362 val_362 -364 val_364 -366 val_366 -368 val_368 -374 val_374 -378 val_378 -382 val_382 -382 val_382 -384 val_384 -384 val_384 -384 val_384 -386 val_386 -392 val_392 -394 val_394 -396 val_396 -396 val_396 -396 val_396 -4 val_4 -400 val_400 -402 val_402 -404 val_404 -404 val_404 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -414 val_414 -414 val_414 -418 val_418 -42 val_42 -42 val_42 -424 val_424 -424 val_424 -430 val_430 -430 val_430 -430 val_430 -432 val_432 -436 val_436 -438 val_438 -438 val_438 -438 val_438 -44 val_44 -444 val_444 -446 val_446 -448 val_448 -452 val_452 -454 val_454 -454 val_454 -454 val_454 -458 val_458 -458 val_458 -460 val_460 -462 val_462 -462 val_462 -466 val_466 -466 val_466 -466 val_466 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -470 val_470 -472 val_472 -478 val_478 -478 val_478 -480 val_480 -480 val_480 -480 val_480 -482 val_482 -484 val_484 -490 val_490 -492 val_492 -492 val_492 -494 val_494 -496 val_496 -498 val_498 -498 val_498 -498 val_498 -54 val_54 -58 val_58 -58 val_58 -64 val_64 -66 val_66 -70 val_70 -70 val_70 -70 val_70 -72 val_72 -72 val_72 -74 val_74 -76 val_76 -76 val_76 -78 val_78 -8 val_8 -80 val_80 -82 val_82 -84 val_84 -84 val_84 -86 val_86 -90 val_90 -90 val_90 -90 val_90 -92 val_92 -96 val_96 -98 val_98 -98 val_98
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/bucket3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/bucket3.q.out b/ql/src/test/results/clientpositive/tez/bucket3.q.out deleted file mode 100644 index eabcea0..0000000 --- a/ql/src/test/results/clientpositive/tez/bucket3.q.out +++ /dev/null @@ -1,477 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE bucket3_1(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@bucket3_1 -POSTHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE bucket3_1(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@bucket3_1 -PREHOOK: query: explain extended -insert overwrite table bucket3_1 partition (ds='1') -select * from src -PREHOOK: type: QUERY -POSTHOOK: query: explain extended -insert overwrite table bucket3_1 partition (ds='1') -select * from src -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - Stage-3 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - null sort order: - sort order: - Map-reduce partition columns: UDFToInteger(_col0) (type: int) - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - tag: -1 - value expressions: _col0 (type: string), _col1 (type: string) - auto parallelism: false - Path -> Alias: -#### A masked pattern was here #### - Path -> Partition: -#### A masked pattern was here #### - Partition - base file name: src - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} - bucket_count -1 - columns key,value - columns.comments 'default','default' - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numRows 500 - rawDataSize 5312 - serialization.ddl struct src { 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 - - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} - bucket_count -1 - columns key,value - columns.comments 'default','default' - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numRows 500 - rawDataSize 5312 - serialization.ddl struct src { 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.src - name: default.src - Truncated Path -> Alias: - /src [src] - Reducer 2 - Needs Tagging: false - Reduce Operator Tree: - Select Operator - expressions: UDFToInteger(VALUE._col0) (type: int), VALUE._col1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - GlobalTableId: 1 -#### A masked pattern was here #### - NumFilesPerFileSink: 2 - Static Partition Specification: ds=1/ - Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count 2 - bucket_field_name key - columns key,value - columns.comments - columns.types int:string -#### A masked pattern was here #### - name default.bucket3_1 - partition_columns ds - partition_columns.types string - serialization.ddl struct bucket3_1 { i32 key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucket3_1 - TotalFiles: 2 - GatherStats: true - MultiFileSpray: true - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - partition: - ds 1 - replace: true -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - bucket_count 2 - bucket_field_name key - columns key,value - columns.comments - columns.types int:string -#### A masked pattern was here #### - name default.bucket3_1 - partition_columns ds - partition_columns.types string - serialization.ddl struct bucket3_1 { i32 key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucket3_1 - - Stage: Stage-3 - Stats-Aggr Operator -#### A masked pattern was here #### - -PREHOOK: query: insert overwrite table bucket3_1 partition (ds='1') -select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@bucket3_1@ds=1 -POSTHOOK: query: insert overwrite table bucket3_1 partition (ds='1') -select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@bucket3_1@ds=1 -POSTHOOK: Lineage: bucket3_1 PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: bucket3_1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert overwrite table bucket3_1 partition (ds='2') -select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@bucket3_1@ds=2 -POSTHOOK: query: insert overwrite table bucket3_1 partition (ds='2') -select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@bucket3_1@ds=2 -POSTHOOK: Lineage: bucket3_1 PARTITION(ds=2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: bucket3_1 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: explain -select * from bucket3_1 tablesample (bucket 1 out of 2) s where ds = '1' -PREHOOK: type: QUERY -POSTHOOK: query: explain -select * from bucket3_1 tablesample (bucket 1 out of 2) s where ds = '1' -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - TableScan - alias: s - Filter Operator - predicate: (((hash(key) & 2147483647) % 2) = 0) (type: boolean) - Select Operator - expressions: key (type: int), value (type: string), '1' (type: string) - outputColumnNames: _col0, _col1, _col2 - ListSink - -PREHOOK: query: select * from bucket3_1 tablesample (bucket 1 out of 2) s where ds = '1' -PREHOOK: type: QUERY -PREHOOK: Input: default@bucket3_1 -PREHOOK: Input: default@bucket3_1@ds=1 -#### A masked pattern was here #### -POSTHOOK: query: select * from bucket3_1 tablesample (bucket 1 out of 2) s where ds = '1' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@bucket3_1 -POSTHOOK: Input: default@bucket3_1@ds=1 -#### A masked pattern was here #### -0 val_0 1 -0 val_0 1 -0 val_0 1 -10 val_10 1 -100 val_100 1 -100 val_100 1 -104 val_104 1 -104 val_104 1 -114 val_114 1 -116 val_116 1 -118 val_118 1 -118 val_118 1 -12 val_12 1 -12 val_12 1 -120 val_120 1 -120 val_120 1 -126 val_126 1 -128 val_128 1 -128 val_128 1 -128 val_128 1 -134 val_134 1 -134 val_134 1 -136 val_136 1 -138 val_138 1 -138 val_138 1 -138 val_138 1 -138 val_138 1 -146 val_146 1 -146 val_146 1 -150 val_150 1 -152 val_152 1 -152 val_152 1 -156 val_156 1 -158 val_158 1 -160 val_160 1 -162 val_162 1 -164 val_164 1 -164 val_164 1 -166 val_166 1 -168 val_168 1 -170 val_170 1 -172 val_172 1 -172 val_172 1 -174 val_174 1 -174 val_174 1 -176 val_176 1 -176 val_176 1 -178 val_178 1 -18 val_18 1 -18 val_18 1 -180 val_180 1 -186 val_186 1 -190 val_190 1 -192 val_192 1 -194 val_194 1 -196 val_196 1 -2 val_2 1 -20 val_20 1 -200 val_200 1 -200 val_200 1 -202 val_202 1 -208 val_208 1 -208 val_208 1 -208 val_208 1 -214 val_214 1 -216 val_216 1 -216 val_216 1 -218 val_218 1 -222 val_222 1 -224 val_224 1 -224 val_224 1 -226 val_226 1 -228 val_228 1 -230 val_230 1 -230 val_230 1 -230 val_230 1 -230 val_230 1 -230 val_230 1 -238 val_238 1 -238 val_238 1 -24 val_24 1 -24 val_24 1 -242 val_242 1 -242 val_242 1 -244 val_244 1 -248 val_248 1 -252 val_252 1 -256 val_256 1 -256 val_256 1 -258 val_258 1 -26 val_26 1 -26 val_26 1 -260 val_260 1 -262 val_262 1 -266 val_266 1 -272 val_272 1 -272 val_272 1 -274 val_274 1 -278 val_278 1 -278 val_278 1 -28 val_28 1 -280 val_280 1 -280 val_280 1 -282 val_282 1 -282 val_282 1 -284 val_284 1 -286 val_286 1 -288 val_288 1 -288 val_288 1 -292 val_292 1 -296 val_296 1 -298 val_298 1 -298 val_298 1 -298 val_298 1 -30 val_30 1 -302 val_302 1 -306 val_306 1 -308 val_308 1 -310 val_310 1 -316 val_316 1 -316 val_316 1 -316 val_316 1 -318 val_318 1 -318 val_318 1 -318 val_318 1 -322 val_322 1 -322 val_322 1 -332 val_332 1 -336 val_336 1 -338 val_338 1 -34 val_34 1 -342 val_342 1 -342 val_342 1 -344 val_344 1 -344 val_344 1 -348 val_348 1 -348 val_348 1 -348 val_348 1 -348 val_348 1 -348 val_348 1 -356 val_356 1 -360 val_360 1 -362 val_362 1 -364 val_364 1 -366 val_366 1 -368 val_368 1 -374 val_374 1 -378 val_378 1 -382 val_382 1 -382 val_382 1 -384 val_384 1 -384 val_384 1 -384 val_384 1 -386 val_386 1 -392 val_392 1 -394 val_394 1 -396 val_396 1 -396 val_396 1 -396 val_396 1 -4 val_4 1 -400 val_400 1 -402 val_402 1 -404 val_404 1 -404 val_404 1 -406 val_406 1 -406 val_406 1 -406 val_406 1 -406 val_406 1 -414 val_414 1 -414 val_414 1 -418 val_418 1 -42 val_42 1 -42 val_42 1 -424 val_424 1 -424 val_424 1 -430 val_430 1 -430 val_430 1 -430 val_430 1 -432 val_432 1 -436 val_436 1 -438 val_438 1 -438 val_438 1 -438 val_438 1 -44 val_44 1 -444 val_444 1 -446 val_446 1 -448 val_448 1 -452 val_452 1 -454 val_454 1 -454 val_454 1 -454 val_454 1 -458 val_458 1 -458 val_458 1 -460 val_460 1 -462 val_462 1 -462 val_462 1 -466 val_466 1 -466 val_466 1 -466 val_466 1 -468 val_468 1 -468 val_468 1 -468 val_468 1 -468 val_468 1 -470 val_470 1 -472 val_472 1 -478 val_478 1 -478 val_478 1 -480 val_480 1 -480 val_480 1 -480 val_480 1 -482 val_482 1 -484 val_484 1 -490 val_490 1 -492 val_492 1 -492 val_492 1 -494 val_494 1 -496 val_496 1 -498 val_498 1 -498 val_498 1 -498 val_498 1 -54 val_54 1 -58 val_58 1 -58 val_58 1 -64 val_64 1 -66 val_66 1 -70 val_70 1 -70 val_70 1 -70 val_70 1 -72 val_72 1 -72 val_72 1 -74 val_74 1 -76 val_76 1 -76 val_76 1 -78 val_78 1 -8 val_8 1 -80 val_80 1 -82 val_82 1 -84 val_84 1 -84 val_84 1 -86 val_86 1 -90 val_90 1 -90 val_90 1 -90 val_90 1 -92 val_92 1 -96 val_96 1 -98 val_98 1 -98 val_98 1 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/bucket4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/bucket4.q.out b/ql/src/test/results/clientpositive/tez/bucket4.q.out deleted file mode 100644 index f029dfd..0000000 --- a/ql/src/test/results/clientpositive/tez/bucket4.q.out +++ /dev/null @@ -1,465 +0,0 @@ -PREHOOK: query: CREATE TABLE bucket4_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@bucket4_1 -POSTHOOK: query: CREATE TABLE bucket4_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@bucket4_1 -PREHOOK: query: explain extended -insert overwrite table bucket4_1 -select * from src -PREHOOK: type: QUERY -POSTHOOK: query: explain extended -insert overwrite table bucket4_1 -select * from src -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - Stage-3 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: UDFToInteger(_col0) (type: int) - null sort order: a - sort order: + - Map-reduce partition columns: UDFToInteger(_col0) (type: int) - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - tag: -1 - value expressions: _col0 (type: string), _col1 (type: string) - auto parallelism: false - Path -> Alias: -#### A masked pattern was here #### - Path -> Partition: -#### A masked pattern was here #### - Partition - base file name: src - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} - bucket_count -1 - columns key,value - columns.comments 'default','default' - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numRows 500 - rawDataSize 5312 - serialization.ddl struct src { 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 - - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} - bucket_count -1 - columns key,value - columns.comments 'default','default' - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numRows 500 - rawDataSize 5312 - serialization.ddl struct src { 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.src - name: default.src - Truncated Path -> Alias: - /src [src] - Reducer 2 - Needs Tagging: false - Reduce Operator Tree: - Select Operator - expressions: UDFToInteger(VALUE._col0) (type: int), VALUE._col1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - GlobalTableId: 1 -#### A masked pattern was here #### - NumFilesPerFileSink: 2 - Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - SORTBUCKETCOLSPREFIX TRUE - bucket_count 2 - bucket_field_name key - columns key,value - columns.comments - columns.types int:string -#### A masked pattern was here #### - name default.bucket4_1 - numFiles 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct bucket4_1 { i32 key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 0 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucket4_1 - TotalFiles: 2 - GatherStats: true - MultiFileSpray: true - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: true -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - SORTBUCKETCOLSPREFIX TRUE - bucket_count 2 - bucket_field_name key - columns key,value - columns.comments - columns.types int:string -#### A masked pattern was here #### - name default.bucket4_1 - numFiles 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct bucket4_1 { i32 key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 0 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucket4_1 - - Stage: Stage-3 - Stats-Aggr Operator -#### A masked pattern was here #### - -PREHOOK: query: insert overwrite table bucket4_1 -select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@bucket4_1 -POSTHOOK: query: insert overwrite table bucket4_1 -select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@bucket4_1 -POSTHOOK: Lineage: bucket4_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: bucket4_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: explain -select * from bucket4_1 tablesample (bucket 1 out of 2) s -PREHOOK: type: QUERY -POSTHOOK: query: explain -select * from bucket4_1 tablesample (bucket 1 out of 2) s -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - TableScan - alias: s - Filter Operator - predicate: (((hash(key) & 2147483647) % 2) = 0) (type: boolean) - Select Operator - expressions: key (type: int), value (type: string) - outputColumnNames: _col0, _col1 - ListSink - -PREHOOK: query: select * from bucket4_1 tablesample (bucket 1 out of 2) s -PREHOOK: type: QUERY -PREHOOK: Input: default@bucket4_1 -#### A masked pattern was here #### -POSTHOOK: query: select * from bucket4_1 tablesample (bucket 1 out of 2) s -POSTHOOK: type: QUERY -POSTHOOK: Input: default@bucket4_1 -#### A masked pattern was here #### -0 val_0 -0 val_0 -0 val_0 -2 val_2 -4 val_4 -8 val_8 -10 val_10 -12 val_12 -12 val_12 -18 val_18 -18 val_18 -20 val_20 -24 val_24 -24 val_24 -26 val_26 -26 val_26 -28 val_28 -30 val_30 -34 val_34 -42 val_42 -42 val_42 -44 val_44 -54 val_54 -58 val_58 -58 val_58 -64 val_64 -66 val_66 -70 val_70 -70 val_70 -70 val_70 -72 val_72 -72 val_72 -74 val_74 -76 val_76 -76 val_76 -78 val_78 -80 val_80 -82 val_82 -84 val_84 -84 val_84 -86 val_86 -90 val_90 -90 val_90 -90 val_90 -92 val_92 -96 val_96 -98 val_98 -98 val_98 -100 val_100 -100 val_100 -104 val_104 -104 val_104 -114 val_114 -116 val_116 -118 val_118 -118 val_118 -120 val_120 -120 val_120 -126 val_126 -128 val_128 -128 val_128 -128 val_128 -134 val_134 -134 val_134 -136 val_136 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -146 val_146 -146 val_146 -150 val_150 -152 val_152 -152 val_152 -156 val_156 -158 val_158 -160 val_160 -162 val_162 -164 val_164 -164 val_164 -166 val_166 -168 val_168 -170 val_170 -172 val_172 -172 val_172 -174 val_174 -174 val_174 -176 val_176 -176 val_176 -178 val_178 -180 val_180 -186 val_186 -190 val_190 -192 val_192 -194 val_194 -196 val_196 -200 val_200 -200 val_200 -202 val_202 -208 val_208 -208 val_208 -208 val_208 -214 val_214 -216 val_216 -216 val_216 -218 val_218 -222 val_222 -224 val_224 -224 val_224 -226 val_226 -228 val_228 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -238 val_238 -238 val_238 -242 val_242 -242 val_242 -244 val_244 -248 val_248 -252 val_252 -256 val_256 -256 val_256 -258 val_258 -260 val_260 -262 val_262 -266 val_266 -272 val_272 -272 val_272 -274 val_274 -278 val_278 -278 val_278 -280 val_280 -280 val_280 -282 val_282 -282 val_282 -284 val_284 -286 val_286 -288 val_288 -288 val_288 -292 val_292 -296 val_296 -298 val_298 -298 val_298 -298 val_298 -302 val_302 -306 val_306 -308 val_308 -310 val_310 -316 val_316 -316 val_316 -316 val_316 -318 val_318 -318 val_318 -318 val_318 -322 val_322 -322 val_322 -332 val_332 -336 val_336 -338 val_338 -342 val_342 -342 val_342 -344 val_344 -344 val_344 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -356 val_356 -360 val_360 -362 val_362 -364 val_364 -366 val_366 -368 val_368 -374 val_374 -378 val_378 -382 val_382 -382 val_382 -384 val_384 -384 val_384 -384 val_384 -386 val_386 -392 val_392 -394 val_394 -396 val_396 -396 val_396 -396 val_396 -400 val_400 -402 val_402 -404 val_404 -404 val_404 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -414 val_414 -414 val_414 -418 val_418 -424 val_424 -424 val_424 -430 val_430 -430 val_430 -430 val_430 -432 val_432 -436 val_436 -438 val_438 -438 val_438 -438 val_438 -444 val_444 -446 val_446 -448 val_448 -452 val_452 -454 val_454 -454 val_454 -454 val_454 -458 val_458 -458 val_458 -460 val_460 -462 val_462 -462 val_462 -466 val_466 -466 val_466 -466 val_466 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -470 val_470 -472 val_472 -478 val_478 -478 val_478 -480 val_480 -480 val_480 -480 val_480 -482 val_482 -484 val_484 -490 val_490 -492 val_492 -492 val_492 -494 val_494 -496 val_496 -498 val_498 -498 val_498 -498 val_498
