You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by "Omer, Farah" <fo...@microstrategy.com> on 2012/08/14 17:05:41 UTC

Issue with creating table in hbase

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



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

Re: Issue with creating table in hbase

Posted by gemini alex <ge...@gmail.com>.
it seems you didn't start hive with --aux-path as mentioned in hive hbase
integration document.


2012/8/15 Kevin O'dell <ke...@cloudera.com>

> What happens if you paste that into the hive shell?
>
> On Tue, Aug 14, 2012 at 11:05 AM, Omer, Farah <fomer@microstrategy.com
> >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
> >
> >
> >
> > 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
> >
> >
> >
>
>
> --
> Kevin O'Dell
> Customer Operations Engineer, Cloudera
>

Re: Issue with creating table in hbase

Posted by Kevin O'dell <ke...@cloudera.com>.
What happens if you paste that into the hive shell?

On Tue, Aug 14, 2012 at 11:05 AM, Omer, Farah <fo...@microstrategy.com>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
>
>
>
> 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
>
>
>


-- 
Kevin O'Dell
Customer Operations Engineer, Cloudera