Issue with creating table in hbase

[Omer, Farah]

Hi all,

I was testing hbase integrated with hive, and running into an issue. Would 
anyone has an idea what it means?



hbase(main):001:0> CREATE TABLE hbase_mstr_1(key int, value string) STORED BY 
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES 
("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES ("hbase.table.name" = 
"xyz")

SyntaxError: (hbase):1: syntax error, unexpected tIDENTIFIER



CREATE TABLE hbase_mstr_1(key int, value string) STORED BY 
'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES 
("hbase.columns.mapping" = ":key,cf1:val") TBLPROPERTIES ("hbase.table.name" = 
"xyz")

                                              ^



hbase(main):002:0>



Hive version is 0.7, hbase version is 0.90



Thanks.


Farah Omer
Sr. DB Engineer | MicroStrategy, Inc.
Tel 703.270.2230 | fo...@microstrategy.com
1850 Towers Crescent Plaza | Tysons Corner, VA 22182
www.microstrategy.com