PREHOOK: query: create table src_rc_concatenate_test(key int, value string) stored as rcfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table src_rc_concatenate_test(key int, value string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@src_rc_concatenate_test
PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test
PREHOOK: type: LOAD
PREHOOK: Output: default@src_rc_concatenate_test
POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test
POSTHOOK: type: LOAD
POSTHOOK: Output: default@src_rc_concatenate_test
PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test
PREHOOK: type: LOAD
PREHOOK: Output: default@src_rc_concatenate_test
POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test
POSTHOOK: type: LOAD
POSTHOOK: Output: default@src_rc_concatenate_test
PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test
PREHOOK: type: LOAD
PREHOOK: Output: default@src_rc_concatenate_test
POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test
POSTHOOK: type: LOAD
POSTHOOK: Output: default@src_rc_concatenate_test
PREHOOK: query: show table extended like `src_rc_concatenate_test`
PREHOOK: type: SHOW_TABLESTATUS
POSTHOOK: query: show table extended like `src_rc_concatenate_test`
POSTHOOK: type: SHOW_TABLESTATUS
tableName:src_rc_concatenate_test
owner:heyongqiang
location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test
inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
columns:struct columns { i32 key, string value}
partitioned:false
partitionColumns:
totalNumberFiles:3
totalFileSize:636
maxFileSize:222
minFileSize:206
lastAccessTime:0
lastUpdateTime:1303856093000

PREHOOK: query: select count(1) from src_rc_concatenate_test
PREHOOK: type: QUERY
PREHOOK: Input: default@src_rc_concatenate_test
PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-14-54_116_5056538740056177435/-mr-10000
POSTHOOK: query: select count(1) from src_rc_concatenate_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_rc_concatenate_test
POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-14-54_116_5056538740056177435/-mr-10000
15
PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
PREHOOK: type: QUERY
PREHOOK: Input: default@src_rc_concatenate_test
PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-01_971_2647514620376325946/-mr-10000
POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_rc_concatenate_test
POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-01_971_2647514620376325946/-mr-10000
214	-7678496319
PREHOOK: query: create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
POSTHOOK: type: CREATEINDEX
PREHOOK: query: show indexes on src_rc_concatenate_test
PREHOOK: type: SHOWINDEXES
POSTHOOK: query: show indexes on src_rc_concatenate_test
POSTHOOK: type: SHOWINDEXES
src_rc_concatenate_test_index	src_rc_concatenate_test	key                 	default__src_rc_concatenate_test_src_rc_concatenate_test_index__	compact             	
PREHOOK: query: alter table src_rc_concatenate_test concatenate
PREHOOK: type: ALTER_TABLE_MERGE
PREHOOK: Input: default@src_rc_concatenate_test
PREHOOK: Output: default@src_rc_concatenate_test
POSTHOOK: query: alter table src_rc_concatenate_test concatenate
POSTHOOK: type: ALTER_TABLE_MERGE
POSTHOOK: Input: default@src_rc_concatenate_test
POSTHOOK: Output: default@src_rc_concatenate_test
PREHOOK: query: show table extended like `src_rc_concatenate_test`
PREHOOK: type: SHOW_TABLESTATUS
POSTHOOK: query: show table extended like `src_rc_concatenate_test`
POSTHOOK: type: SHOW_TABLESTATUS
tableName:src_rc_concatenate_test
owner:heyongqiang
location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test
inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
columns:struct columns { i32 key, string value}
partitioned:false
partitionColumns:
totalNumberFiles:1
totalFileSize:334
maxFileSize:334
minFileSize:334
lastAccessTime:0
lastUpdateTime:1303856111000

PREHOOK: query: select count(1) from src_rc_concatenate_test
PREHOOK: type: QUERY
PREHOOK: Input: default@src_rc_concatenate_test
PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-12_232_1765943327509437357/-mr-10000
POSTHOOK: query: select count(1) from src_rc_concatenate_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_rc_concatenate_test
POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-12_232_1765943327509437357/-mr-10000
15
PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
PREHOOK: type: QUERY
PREHOOK: Input: default@src_rc_concatenate_test
PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-18_738_6289595467011155110/-mr-10000
POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_rc_concatenate_test
POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-18_738_6289595467011155110/-mr-10000
214	-7678496319
PREHOOK: query: drop index src_rc_concatenate_test_index on src_rc_concatenate_test
PREHOOK: type: DROPINDEX
POSTHOOK: query: drop index src_rc_concatenate_test_index on src_rc_concatenate_test
POSTHOOK: type: DROPINDEX
PREHOOK: query: create table src_rc_concatenate_test_part(key int, value string) partitioned by (ds string) stored as rcfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table src_rc_concatenate_test_part(key int, value string) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@src_rc_concatenate_test_part
PREHOOK: query: alter table src_rc_concatenate_test_part add partition (ds='2011')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@src_rc_concatenate_test_part
POSTHOOK: query: alter table src_rc_concatenate_test_part add partition (ds='2011')
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@src_rc_concatenate_test_part
POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test_part partition (ds='2011')
PREHOOK: type: LOAD
PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test_part partition (ds='2011')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test_part partition (ds='2011')
PREHOOK: type: LOAD
PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test_part partition (ds='2011')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test_part partition (ds='2011')
PREHOOK: type: LOAD
PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test_part partition (ds='2011')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
PREHOOK: type: SHOW_TABLESTATUS
POSTHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
POSTHOOK: type: SHOW_TABLESTATUS
tableName:src_rc_concatenate_test_part
owner:heyongqiang
location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test_part/ds=2011
inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
columns:struct columns { i32 key, string value}
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:3
totalFileSize:636
maxFileSize:222
minFileSize:206
lastAccessTime:0
lastUpdateTime:1303856128000

PREHOOK: query: select count(1) from src_rc_concatenate_test_part
PREHOOK: type: QUERY
PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-28_709_6508379632697292274/-mr-10000
POSTHOOK: query: select count(1) from src_rc_concatenate_test_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-28_709_6508379632697292274/-mr-10000
15
PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
PREHOOK: type: QUERY
PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-35_496_4356530739014843487/-mr-10000
POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-35_496_4356530739014843487/-mr-10000
214	-7678496319
PREHOOK: query: create index src_rc_concatenate_test_part_index on table src_rc_concatenate_test_part(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
PREHOOK: type: CREATEINDEX
POSTHOOK: query: create index src_rc_concatenate_test_part_index on table src_rc_concatenate_test_part(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
POSTHOOK: type: CREATEINDEX
PREHOOK: query: show indexes on src_rc_concatenate_test_part
PREHOOK: type: SHOWINDEXES
POSTHOOK: query: show indexes on src_rc_concatenate_test_part
POSTHOOK: type: SHOWINDEXES
src_rc_concatenate_test_part_index	src_rc_concatenate_test_part	key                 	default__src_rc_concatenate_test_part_src_rc_concatenate_test_part_index__	compact             	
PREHOOK: query: alter table src_rc_concatenate_test_part partition (ds='2011') concatenate
PREHOOK: type: ALTER_PARTITION_MERGE
PREHOOK: Input: default@src_rc_concatenate_test_part
PREHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
POSTHOOK: query: alter table src_rc_concatenate_test_part partition (ds='2011') concatenate
POSTHOOK: type: ALTER_PARTITION_MERGE
POSTHOOK: Input: default@src_rc_concatenate_test_part
POSTHOOK: Output: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
PREHOOK: type: SHOW_TABLESTATUS
POSTHOOK: query: show table extended like `src_rc_concatenate_test_part` partition (ds='2011')
POSTHOOK: type: SHOW_TABLESTATUS
tableName:src_rc_concatenate_test_part
owner:heyongqiang
location:pfile:/Users/heyongqiang/Documents/workspace/Hive-3/build/ql/test/data/warehouse/src_rc_concatenate_test_part/ds=2011
inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat
outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat
columns:struct columns { i32 key, string value}
partitioned:true
partitionColumns:struct partition_columns { string ds}
totalNumberFiles:1
totalFileSize:334
maxFileSize:334
minFileSize:334
lastAccessTime:0
lastUpdateTime:1303856144000

PREHOOK: query: select count(1) from src_rc_concatenate_test_part
PREHOOK: type: QUERY
PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-45_308_2380163877365308340/-mr-10000
POSTHOOK: query: select count(1) from src_rc_concatenate_test_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-45_308_2380163877365308340/-mr-10000
15
PREHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
PREHOOK: type: QUERY
PREHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-51_822_7148108227690658912/-mr-10000
POSTHOOK: query: select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test_part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_rc_concatenate_test_part@ds=2011
POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2011-04-26_15-15-51_822_7148108227690658912/-mr-10000
214	-7678496319
PREHOOK: query: drop index src_rc_concatenate_test_part_index on src_rc_concatenate_test_part
PREHOOK: type: DROPINDEX
POSTHOOK: query: drop index src_rc_concatenate_test_part_index on src_rc_concatenate_test_part
POSTHOOK: type: DROPINDEX