Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
> *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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB