You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by "ransom.hezhiqiang" <ab...@gmail.com> on 2012/05/12 07:39:43 UTC

How to create index on HBase?

Hi all
I create index on hbase faild .
This is my 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");

Best regards
Ransom.