Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Hive index rebuild

Copy link to this message
Hive index rebuild

I created index and try to rebuild by partitions, however it did not work.
Here is my script to create and rebuild index:
create index ix_name_cid on table a (customer_id) as
'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED

alter index ix_name_cid on a partition(day=20130319) rebuild;

the table is partitioned by 'day', but I got error :
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException:
table is partitioned but partition spec is not specified or does not fully
match table partitioning: {day=20130319}*

the hive version is 0.10. Anybody know what's wrong with my scripts? it
does work when I don't specify any partitions when rebuild though.