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.

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

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.

Does Hbase support secondary indexes? I don't think so!!!  I m not sure you
can create indexes in Hbase even if it is integrated with hive.

Regards,
Abhishek

On Sun, May 13, 2012 at 7:10 PM, Hezhiqiang (Ransom) <
[EMAIL PROTECTED]> wrote:

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