Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


Copy link to this message
-
Hive index rebuild
Hi,

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
REBUILD;

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.

Echo
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB