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:1303856313000 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-18-34_169_7540361530581615138/-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-18-34_169_7540361530581615138/-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-18-42_067_46716291029153270/-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-18-42_067_46716291029153270/-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 FAILED: Error in semantic analysis: org.apache.hadoop.hive.ql.parse.SemanticException: can not do merge because source table src_rc_concatenate_test is indexed.