create table part (a int,b int) PARTITIONED by (c int); create index part_idx on table part(b,c) AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD partitioned by (a) ;
hive> create index part_idx on table part(b,c) AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD > partitioned by (a) ; FAILED: Parse Error: line 2:0 mismatched input 'partitioned' expecting EOF near 'REBUILD' hive> If I remove the partitioned by (a), then the index can be created. But I need to partition it on column. Is that not supported yet or I made some mistake?