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

Switch to Threaded View
Hive >> mail # user >> How to create index on HBase?

Copy link to this message
how to create index on hbase?
Hi all
I want to create index on hbase, but it was faild .
This is the sql. How to create index on HBase?

create index i_hhive on hhive(c1,c2) as "compact" with deferred rebuild  STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val,cf1:val2,cf1:val3") TBLPROPERTIES ("hbase.table.name" = "xyz");

When rebuild index,throws exception.
hive> ALTER INDEX i_txt_hhive ON hhive1 REBUILD;
FAILED: Error in semantic analysis: org.apache.hadoop.hive.ql.metadata.HiveException: must specify an InputFormat class

Best regards