Storage index table in HBase

[lxw]

Hi,experts:

  I want to storage hive index table in HBase to improve index performance.
I do it like this :


  CREATE INDEX idx_number on table my_hive_table (number) as  
'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' with DEFERRED 
REBUILD 
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
WITH 
SERDEPROPERTIES(??hbase.columns.mapping??=??:key,cf:bucketname,cf:offsets??)??

  but it fails, exception message is:
org.apache.hadoop.hive.ql.metadata.HiveException:must specify an InputFormat 
class.

 Who can help me to resolve this problem or tell me what should I do.

Thanks all!
Sean