set hive.exec.concatenate.check.index=true; create table src_rc_concatenate_test(key int, value string) stored as rcfile; load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_concatenate_test; load data local inpath '../data/files/smbbucket_2.rc' into table src_rc_concatenate_test; load data local inpath '../data/files/smbbucket_3.rc' into table src_rc_concatenate_test; show table extended like `src_rc_concatenate_test`; select count(1) from src_rc_concatenate_test; select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test; create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2"); show indexes on src_rc_concatenate_test; alter table src_rc_concatenate_test concatenate;