Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 22BBBD5C2 for ; Tue, 14 Aug 2012 15:11:57 +0000 (UTC) Received: (qmail 80436 invoked by uid 500); 14 Aug 2012 15:11:55 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 80370 invoked by uid 500); 14 Aug 2012 15:11:55 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 80361 invoked by uid 99); 14 Aug 2012 15:11:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Aug 2012 15:11:55 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kulkarni.swarnim@gmail.com designates 209.85.212.48 as permitted sender) Received: from [209.85.212.48] (HELO mail-vb0-f48.google.com) (209.85.212.48) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Aug 2012 15:11:51 +0000 Received: by vbme21 with SMTP id e21so529964vbm.35 for ; Tue, 14 Aug 2012 08:11:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=8aDAnrVeOtO+NL4hWwjCpxLPP4n8X8HcHoigRGkF3Zc=; b=BX3yGupSpgFy33pVC3hoFkT+gHrXULJJnQnd3aDKlJvg8Eplh98kGMoRekWNQ+R4rX yARQyqb2BHlQgOsXh4+R+zq9aSiSNfgbzjs3zHnkpUHngqUkoSblc/AAdg9QsLJWCOKO Mel5m/gelHy2gdFZw4gvVZJ1eAeSm0EDD63CI74lcGKS/Agd4caJ8pFc2IYBQxYubF05 2rNybPx9D9lla8XP+OzVlzxC3TGROrBIA28RbAKVzn/cYrXQ3AF2yo1xr9JswRuYKP/3 N43KWZqzM7VOUFqZM63pW6tJtGS8npoe0etL5Jy3EehbYc3/8etD/lGawAHJ9HQpT3Xr SLIw== Received: by 10.220.220.76 with SMTP id hx12mr10975613vcb.9.1344957090175; Tue, 14 Aug 2012 08:11:30 -0700 (PDT) MIME-Version: 1.0 Received: by 10.58.227.36 with HTTP; Tue, 14 Aug 2012 08:11:09 -0700 (PDT) In-Reply-To: References: From: "kulkarni.swarnim@gmail.com" Date: Tue, 14 Aug 2012 10:11:09 -0500 Message-ID: Subject: Re: Issue with creating table in hbase To: user@hive.apache.org Content-Type: multipart/alternative; boundary=14dae9cfcdf09918ff04c73b3982 X-Virus-Checked: Checked by ClamAV on apache.org --14dae9cfcdf09918ff04c73b3982 Content-Type: text/plain; charset=ISO-8859-1 > *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 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 | fomer@microstrategy.com**** > > 1850 Towers Crescent Plaza | Tysons Corner, VA 22182**** > > www.microstrategy.com**** > > ** ** > > ** ** > -- Swarnim --14dae9cfcdf09918ff04c73b3982 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
>=A0hbase(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, Fara= h <fomer@microstrategy.com> wrote:

Hi all,

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

=A0

hbase(main):001:0> CREATE TABLE hbase_mstr_1(key int, value string) S= TORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SE= RDEPROPERTIES ("hbase.columns.mapping" =3D ":key,cf1:val&quo= t;) TBLPROPERTIES ("hbase.table.name" =3D "xyz")

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

=A0

CREATE TABLE hbase_mstr_1(key int, value string) STORED BY 'org.apac= he.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("h= base.columns.mapping" =3D ":key,cf1:val") TBLPROPERTIES (&qu= ot;hbase.table.name" =3D "xyz")

=A0=A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0^<= u>

=A0

hbase(main):002:0>

=A0

Hive version is 0.7, hbase version is 0.90

=A0

Thanks.

=A0

Farah Omer

Sr. DB Engineer = | MicroStrategy, Inc.

Tel 703.270.2230 | fomer@microstr= ategy.com

1850 Towers Crescent Plaza | Tyso= ns Corner, VA 22182

www.microstrategy.com

=A0

=A0




--
Swarnim
--14dae9cfcdf09918ff04c73b3982--