Hi, For large tables, its takes a lot of time to load the indexes in the index table. Is there any way we can reduce the index load time?
CREATE TABLE SE_TX_SUMMARY (COUNTY string, BLOCKGROUPID string, GROUPING_ID int) PARTITIONED BY (EXPOSED_TIME int) row format delimited fields terminated by '|' stored as textfile; CREATE INDEX se_vt_summary_county_index ON TABLE se_vt_summary (exposed_time) AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD; ALTER INDEX se_vt_county_index ON se_vt REBUILD; Thanks and Regards, Saquib
