Added: hive/trunk/ql/src/test/results/clientpositive/alter_merge_orc.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_merge_orc.q.out?rev=1614793&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/alter_merge_orc.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/alter_merge_orc.q.out Wed Jul 30 23:50:11 2014 @@ -0,0 +1,261 @@ +PREHOOK: query: create table src_orc_merge_test(key int, value string) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +POSTHOOK: query: create table src_orc_merge_test(key int, value string) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@src_orc_merge_test +PREHOOK: query: insert overwrite table src_orc_merge_test select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test +POSTHOOK: query: insert overwrite table src_orc_merge_test select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test +POSTHOOK: Lineage: src_orc_merge_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert into table src_orc_merge_test select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test +POSTHOOK: query: insert into table src_orc_merge_test select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test +POSTHOOK: Lineage: src_orc_merge_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert into table src_orc_merge_test select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test +POSTHOOK: query: insert into table src_orc_merge_test select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test +POSTHOOK: Lineage: src_orc_merge_test.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show table extended like `src_orc_merge_test` +PREHOOK: type: SHOW_TABLESTATUS +POSTHOOK: query: show table extended like `src_orc_merge_test` +POSTHOOK: type: SHOW_TABLESTATUS +tableName:src_orc_merge_test +#### A masked pattern was here #### +inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +columns:struct columns { i32 key, string value} +partitioned:false +partitionColumns: +totalNumberFiles:3 +totalFileSize:7380 +maxFileSize:2460 +minFileSize:2460 +#### A masked pattern was here #### + +PREHOOK: query: select count(1) from src_orc_merge_test +PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test +#### A masked pattern was here #### +POSTHOOK: query: select count(1) from src_orc_merge_test +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test +#### A masked pattern was here #### +1500 +PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test +PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test +#### A masked pattern was here #### +390273 108631194210 +PREHOOK: query: alter table src_orc_merge_test concatenate +PREHOOK: type: ALTER_TABLE_MERGE +PREHOOK: Input: default@src_orc_merge_test +PREHOOK: Output: default@src_orc_merge_test +POSTHOOK: query: alter table src_orc_merge_test concatenate +POSTHOOK: type: ALTER_TABLE_MERGE +POSTHOOK: Input: default@src_orc_merge_test +POSTHOOK: Output: default@src_orc_merge_test +PREHOOK: query: show table extended like `src_orc_merge_test` +PREHOOK: type: SHOW_TABLESTATUS +POSTHOOK: query: show table extended like `src_orc_merge_test` +POSTHOOK: type: SHOW_TABLESTATUS +tableName:src_orc_merge_test +#### A masked pattern was here #### +inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +columns:struct columns { i32 key, string value} +partitioned:false +partitionColumns: +totalNumberFiles:1 +totalFileSize:7059 +maxFileSize:7059 +minFileSize:7059 +#### A masked pattern was here #### + +PREHOOK: query: select count(1) from src_orc_merge_test +PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test +#### A masked pattern was here #### +POSTHOOK: query: select count(1) from src_orc_merge_test +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test +#### A masked pattern was here #### +1500 +PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test +PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test +#### A masked pattern was here #### +390273 108631194210 +PREHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +POSTHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@src_orc_merge_test_part +PREHOOK: query: alter table src_orc_merge_test_part add partition (ds='2011') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Output: default@src_orc_merge_test_part +POSTHOOK: query: alter table src_orc_merge_test_part add partition (ds='2011') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Output: default@src_orc_merge_test_part +POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 +PREHOOK: query: insert overwrite table src_orc_merge_test_part partition (ds='2011') select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_part@ds=2011 +POSTHOOK: query: insert overwrite table src_orc_merge_test_part partition (ds='2011') select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 +POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert into table src_orc_merge_test_part partition (ds='2011') select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_part@ds=2011 +POSTHOOK: query: insert into table src_orc_merge_test_part partition (ds='2011') select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 +POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert into table src_orc_merge_test_part partition (ds='2011') select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_part@ds=2011 +POSTHOOK: query: insert into table src_orc_merge_test_part partition (ds='2011') select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 +POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_part PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show table extended like `src_orc_merge_test_part` partition (ds='2011') +PREHOOK: type: SHOW_TABLESTATUS +POSTHOOK: query: show table extended like `src_orc_merge_test_part` partition (ds='2011') +POSTHOOK: type: SHOW_TABLESTATUS +tableName:src_orc_merge_test_part +#### A masked pattern was here #### +inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +columns:struct columns { i32 key, string value} +partitioned:true +partitionColumns:struct partition_columns { string ds} +totalNumberFiles:3 +totalFileSize:7380 +maxFileSize:2460 +minFileSize:2460 +#### A masked pattern was here #### + +PREHOOK: query: select count(1) from src_orc_merge_test_part +PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test_part +PREHOOK: Input: default@src_orc_merge_test_part@ds=2011 +#### A masked pattern was here #### +POSTHOOK: query: select count(1) from src_orc_merge_test_part +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test_part +POSTHOOK: Input: default@src_orc_merge_test_part@ds=2011 +#### A masked pattern was here #### +1500 +PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part +PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test_part +PREHOOK: Input: default@src_orc_merge_test_part@ds=2011 +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test_part +POSTHOOK: Input: default@src_orc_merge_test_part@ds=2011 +#### A masked pattern was here #### +390273 108631194210 +PREHOOK: query: alter table src_orc_merge_test_part partition (ds='2011') concatenate +PREHOOK: type: ALTER_PARTITION_MERGE +PREHOOK: Input: default@src_orc_merge_test_part +PREHOOK: Output: default@src_orc_merge_test_part@ds=2011 +POSTHOOK: query: alter table src_orc_merge_test_part partition (ds='2011') concatenate +POSTHOOK: type: ALTER_PARTITION_MERGE +POSTHOOK: Input: default@src_orc_merge_test_part +POSTHOOK: Output: default@src_orc_merge_test_part@ds=2011 +PREHOOK: query: show table extended like `src_orc_merge_test_part` partition (ds='2011') +PREHOOK: type: SHOW_TABLESTATUS +POSTHOOK: query: show table extended like `src_orc_merge_test_part` partition (ds='2011') +POSTHOOK: type: SHOW_TABLESTATUS +tableName:src_orc_merge_test_part +#### A masked pattern was here #### +inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +columns:struct columns { i32 key, string value} +partitioned:true +partitionColumns:struct partition_columns { string ds} +totalNumberFiles:1 +totalFileSize:7059 +maxFileSize:7059 +minFileSize:7059 +#### A masked pattern was here #### + +PREHOOK: query: select count(1) from src_orc_merge_test_part +PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test_part +PREHOOK: Input: default@src_orc_merge_test_part@ds=2011 +#### A masked pattern was here #### +POSTHOOK: query: select count(1) from src_orc_merge_test_part +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test_part +POSTHOOK: Input: default@src_orc_merge_test_part@ds=2011 +#### A masked pattern was here #### +1500 +PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part +PREHOOK: type: QUERY +PREHOOK: Input: default@src_orc_merge_test_part +PREHOOK: Input: default@src_orc_merge_test_part@ds=2011 +#### A masked pattern was here #### +POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_orc_merge_test_part +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src_orc_merge_test_part +POSTHOOK: Input: default@src_orc_merge_test_part@ds=2011 +#### A masked pattern was here #### +390273 108631194210 +PREHOOK: query: drop table src_orc_merge_test +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@src_orc_merge_test +PREHOOK: Output: default@src_orc_merge_test +POSTHOOK: query: drop table src_orc_merge_test +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@src_orc_merge_test +POSTHOOK: Output: default@src_orc_merge_test +PREHOOK: query: drop table src_orc_merge_test_part +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@src_orc_merge_test_part +PREHOOK: Output: default@src_orc_merge_test_part +POSTHOOK: query: drop table src_orc_merge_test_part +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@src_orc_merge_test_part +POSTHOOK: Output: default@src_orc_merge_test_part
Added: hive/trunk/ql/src/test/results/clientpositive/alter_merge_stats_orc.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_merge_stats_orc.q.out?rev=1614793&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/alter_merge_stats_orc.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/alter_merge_stats_orc.q.out Wed Jul 30 23:50:11 2014 @@ -0,0 +1,380 @@ +PREHOOK: query: create table src_orc_merge_test_stat(key int, value string) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +POSTHOOK: query: create table src_orc_merge_test_stat(key int, value string) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@src_orc_merge_test_stat +PREHOOK: query: insert overwrite table src_orc_merge_test_stat select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: query: insert overwrite table src_orc_merge_test_stat select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: Lineage: src_orc_merge_test_stat.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_stat.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert into table src_orc_merge_test_stat select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: query: insert into table src_orc_merge_test_stat select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: Lineage: src_orc_merge_test_stat.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_stat.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert into table src_orc_merge_test_stat select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: query: insert into table src_orc_merge_test_stat select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: Lineage: src_orc_merge_test_stat.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_stat.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show table extended like `src_orc_merge_test_stat` +PREHOOK: type: SHOW_TABLESTATUS +POSTHOOK: query: show table extended like `src_orc_merge_test_stat` +POSTHOOK: type: SHOW_TABLESTATUS +tableName:src_orc_merge_test_stat +#### A masked pattern was here #### +inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +columns:struct columns { i32 key, string value} +partitioned:false +partitionColumns: +totalNumberFiles:3 +totalFileSize:7380 +maxFileSize:2460 +minFileSize:2460 +#### A masked pattern was here #### + +PREHOOK: query: desc extended src_orc_merge_test_stat +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@src_orc_merge_test_stat +POSTHOOK: query: desc extended src_orc_merge_test_stat +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@src_orc_merge_test_stat +key int +value string + +#### A masked pattern was here #### +PREHOOK: query: analyze table src_orc_merge_test_stat compute statistics noscan +PREHOOK: type: QUERY +PREHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: query: analyze table src_orc_merge_test_stat compute statistics noscan +POSTHOOK: type: QUERY +POSTHOOK: Output: default@src_orc_merge_test_stat +PREHOOK: query: desc formatted src_orc_merge_test_stat +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@src_orc_merge_test_stat +POSTHOOK: query: desc formatted src_orc_merge_test_stat +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@src_orc_merge_test_stat +# col_name data_type comment + +key int +value string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Protect Mode: None +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE true + numFiles 3 + numRows 1500 + rawDataSize 141000 + totalSize 7380 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde +InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 +PREHOOK: query: alter table src_orc_merge_test_stat concatenate +PREHOOK: type: ALTER_TABLE_MERGE +PREHOOK: Input: default@src_orc_merge_test_stat +PREHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: query: alter table src_orc_merge_test_stat concatenate +POSTHOOK: type: ALTER_TABLE_MERGE +POSTHOOK: Input: default@src_orc_merge_test_stat +POSTHOOK: Output: default@src_orc_merge_test_stat +PREHOOK: query: analyze table src_orc_merge_test_stat compute statistics noscan +PREHOOK: type: QUERY +PREHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: query: analyze table src_orc_merge_test_stat compute statistics noscan +POSTHOOK: type: QUERY +POSTHOOK: Output: default@src_orc_merge_test_stat +PREHOOK: query: desc formatted src_orc_merge_test_stat +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@src_orc_merge_test_stat +POSTHOOK: query: desc formatted src_orc_merge_test_stat +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@src_orc_merge_test_stat +# col_name data_type comment + +key int +value string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Protect Mode: None +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE true + numFiles 1 + numRows 1500 + rawDataSize 141000 + totalSize 7059 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde +InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 +PREHOOK: query: create table src_orc_merge_test_part_stat(key int, value string) partitioned by (ds string) stored as orc +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +POSTHOOK: query: create table src_orc_merge_test_part_stat(key int, value string) partitioned by (ds string) stored as orc +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@src_orc_merge_test_part_stat +PREHOOK: query: alter table src_orc_merge_test_part_stat add partition (ds='2011') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Output: default@src_orc_merge_test_part_stat +POSTHOOK: query: alter table src_orc_merge_test_part_stat add partition (ds='2011') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Output: default@src_orc_merge_test_part_stat +POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +PREHOOK: query: insert overwrite table src_orc_merge_test_part_stat partition (ds='2011') select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: query: insert overwrite table src_orc_merge_test_part_stat partition (ds='2011') select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert into table src_orc_merge_test_part_stat partition (ds='2011') select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: query: insert into table src_orc_merge_test_part_stat partition (ds='2011') select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: insert into table src_orc_merge_test_part_stat partition (ds='2011') select * from src +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: query: insert into table src_orc_merge_test_part_stat partition (ds='2011') select * from src +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: src_orc_merge_test_part_stat PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: show table extended like `src_orc_merge_test_part_stat` partition (ds='2011') +PREHOOK: type: SHOW_TABLESTATUS +POSTHOOK: query: show table extended like `src_orc_merge_test_part_stat` partition (ds='2011') +POSTHOOK: type: SHOW_TABLESTATUS +tableName:src_orc_merge_test_part_stat +#### A masked pattern was here #### +inputformat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +outputformat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +columns:struct columns { i32 key, string value} +partitioned:true +partitionColumns:struct partition_columns { string ds} +totalNumberFiles:3 +totalFileSize:7380 +maxFileSize:2460 +minFileSize:2460 +#### A masked pattern was here #### + +PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@src_orc_merge_test_part_stat +POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@src_orc_merge_test_part_stat +# col_name data_type comment + +key int +value string + +# Partition Information +# col_name data_type comment + +ds string + +# Detailed Partition Information +Partition Value: [2011] +Database: default +Table: src_orc_merge_test_part_stat +#### A masked pattern was here #### +Protect Mode: None +#### A masked pattern was here #### +Partition Parameters: + COLUMN_STATS_ACCURATE true + numFiles 3 + numRows 500 + rawDataSize 47000 + totalSize 7380 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde +InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 +PREHOOK: query: analyze table src_orc_merge_test_part_stat partition(ds='2011') compute statistics noscan +PREHOOK: type: QUERY +PREHOOK: Output: default@src_orc_merge_test_part_stat +PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: query: analyze table src_orc_merge_test_part_stat partition(ds='2011') compute statistics noscan +POSTHOOK: type: QUERY +POSTHOOK: Output: default@src_orc_merge_test_part_stat +POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@src_orc_merge_test_part_stat +POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@src_orc_merge_test_part_stat +# col_name data_type comment + +key int +value string + +# Partition Information +# col_name data_type comment + +ds string + +# Detailed Partition Information +Partition Value: [2011] +Database: default +Table: src_orc_merge_test_part_stat +#### A masked pattern was here #### +Protect Mode: None +#### A masked pattern was here #### +Partition Parameters: + COLUMN_STATS_ACCURATE true + numFiles 3 + numRows 1500 + rawDataSize 141000 + totalSize 7380 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde +InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 +PREHOOK: query: alter table src_orc_merge_test_part_stat partition (ds='2011') concatenate +PREHOOK: type: ALTER_PARTITION_MERGE +PREHOOK: Input: default@src_orc_merge_test_part_stat +PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: query: alter table src_orc_merge_test_part_stat partition (ds='2011') concatenate +POSTHOOK: type: ALTER_PARTITION_MERGE +POSTHOOK: Input: default@src_orc_merge_test_part_stat +POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +PREHOOK: query: analyze table src_orc_merge_test_part_stat partition(ds='2011') compute statistics noscan +PREHOOK: type: QUERY +PREHOOK: Output: default@src_orc_merge_test_part_stat +PREHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +POSTHOOK: query: analyze table src_orc_merge_test_part_stat partition(ds='2011') compute statistics noscan +POSTHOOK: type: QUERY +POSTHOOK: Output: default@src_orc_merge_test_part_stat +POSTHOOK: Output: default@src_orc_merge_test_part_stat@ds=2011 +PREHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@src_orc_merge_test_part_stat +POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@src_orc_merge_test_part_stat +# col_name data_type comment + +key int +value string + +# Partition Information +# col_name data_type comment + +ds string + +# Detailed Partition Information +Partition Value: [2011] +Database: default +Table: src_orc_merge_test_part_stat +#### A masked pattern was here #### +Protect Mode: None +#### A masked pattern was here #### +Partition Parameters: + COLUMN_STATS_ACCURATE true + numFiles 1 + numRows 1500 + rawDataSize 141000 + totalSize 7059 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde +InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 +PREHOOK: query: drop table src_orc_merge_test_stat +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@src_orc_merge_test_stat +PREHOOK: Output: default@src_orc_merge_test_stat +POSTHOOK: query: drop table src_orc_merge_test_stat +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@src_orc_merge_test_stat +POSTHOOK: Output: default@src_orc_merge_test_stat +PREHOOK: query: drop table src_orc_merge_test_part_stat +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@src_orc_merge_test_part_stat +PREHOOK: Output: default@src_orc_merge_test_part_stat +POSTHOOK: query: drop table src_orc_merge_test_part_stat +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@src_orc_merge_test_part_stat +POSTHOOK: Output: default@src_orc_merge_test_part_stat Modified: hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out Wed Jul 30 23:50:11 2014 @@ -563,10 +563,14 @@ STAGE PLANS: Stats-Aggr Operator Stage: Stage-4 - Block level merge + Merge Work + merge level: block + input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat Stage: Stage-6 - Block level merge + Merge Work + merge level: block + input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat Stage: Stage-7 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_10.q.out Wed Jul 30 23:50:11 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out Wed Jul 30 23:50:11 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out Wed Jul 30 23:50:11 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out Wed Jul 30 23:50:11 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out Wed Jul 30 23:50:11 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out Wed Jul 30 23:50:11 2014 @@ -199,10 +199,14 @@ STAGE PLANS: Stats-Aggr Operator Stage: Stage-3 - Block level merge + Merge Work + merge level: block + input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat Stage: Stage-5 - Block level merge + Merge Work + merge level: block + input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat Stage: Stage-6 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out Wed Jul 30 23:50:11 2014 @@ -173,10 +173,14 @@ STAGE PLANS: Stats-Aggr Operator Stage: Stage-3 - Block level merge + Merge Work + merge level: block + input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat Stage: Stage-5 - Block level merge + Merge Work + merge level: block + input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat Stage: Stage-6 Move Operator Modified: hive/trunk/ql/src/test/results/clientpositive/orc_createas1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_createas1.q.out?rev=1614793&r1=1614792&r2=1614793&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/orc_createas1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/orc_createas1.q.out Wed Jul 30 23:50:11 2014 @@ -110,28 +110,14 @@ STAGE PLANS: Stats-Aggr Operator Stage: Stage-3 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.orc_createas1b + Merge Work + merge level: stripe + input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat Stage: Stage-5 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.orc_createas1b + Merge Work + merge level: stripe + input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat Stage: Stage-6 Move Operator @@ -280,28 +266,14 @@ STAGE PLANS: Stats-Aggr Operator Stage: Stage-3 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.orc_createas1c + Merge Work + merge level: stripe + input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat Stage: Stage-5 - Map Reduce - Map Operator Tree: - TableScan - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat - output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat - serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: default.orc_createas1c + Merge Work + merge level: stripe + input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat Stage: Stage-6 Move Operator
