Re: how to create index on hbase?

2012-05-21 Thread Abhishek Pratap Singh 
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) 
ransom.hezhiqi...@huawei.com 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.

how to create index on hbase?

2012-05-13 Thread Hezhiqiang (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.

How to create index on HBase?

2012-05-12 Thread ransom.hezhiqiang 
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.

How to create index on HBase?

2012-05-12 Thread ransom.hezhiqiang 
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.

How to create index on HBase?

2012-05-11 Thread ransom.hezhiqiang 
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.