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 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
Ransom.
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