Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Issue with creating table in hbase


Copy link to this message
-
Re: Issue with creating table in hbase
kulkarni.swarnim@...) 2012-08-14, 15:11
> *hbase(main):001:0*> CREATE TABLE hbase_mstr_1.....

Are you running the CREATE TABLE from the hbase shell? You should run it
from the hive shell. You can start it from "$HIVE_HOME/bin/hive"

On Tue, Aug 14, 2012 at 10:05 AM, Omer, Farah <[EMAIL PROTECTED]>wrote:

>  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 | [EMAIL PROTECTED]****
>
> 1850 Towers Crescent Plaza | Tysons Corner, VA 22182****
>
> www.microstrategy.com****
>
> ** **
>
> ** **
>

--
Swarnim