hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Omer, Farah" <fo...@microstrategy.com>
Subject Issue with creating table in hbase
Date Tue, 14 Aug 2012 15:05:38 GMT
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 | fomer@microstrategy.com
1850 Towers Crescent Plaza | Tysons Corner, VA 22182
www.microstrategy.com





Mime
View raw message