Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=HXz3TN9expXTab5cMkhFB5u4pTTHznQigJ+M3hnhntRM7uqTl53CdT/WU5k+fH+B0M+b1wKe2i2nVKirIIiJ4KUPHyHW32dSTRcSg8JKcRTWCZnxYDXzCojM4w3SkwqgdOa5Q0UFUGySFpiNN15O/Uvgn8VR86uZ5XOZQH24HL4=;
References: <1323754211.42689.YahooMailNeo@web162101.mail.bf1.yahoo.com>
 <CADhkqD+T3_Gum8UFw0710_g8KuFUSY_hgzNEoXEbf6WvL4ivTA@mail.gmail.com>
 <1323754749.50048.YahooMailNeo@web162106.mail.bf1.yahoo.com>
 <1323754870.60475.YahooMailNeo@web162102.mail.bf1.yahoo.com>
 <CADhkqDL1SMert=nsGCw38BCdjzhCK+DtNzTKbo88eyeG_yOdEA@mail.gmail.com>
Message-ID: <1323755789.72165.YahooMailNeo@web162103.mail.bf1.yahoo.com>
Date: Mon, 12 Dec 2011 21:56:29 -0800 (PST)
From: Aditya Kumar <adityakumar345@yahoo.com>
Reply-To: Aditya Kumar <adityakumar345@yahoo.com>
Subject: Re: Hive Basic question
To: "user@hive.apache.org" <user@hive.apache.org>
Cc: "manu.infy@gmail.com" <manu.infy@gmail.com>
In-Reply-To: 
 <CADhkqDL1SMert=nsGCw38BCdjzhCK+DtNzTKbo88eyeG_yOdEA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

no luck..=0A=0Ahere is the Error I am getting:=0A=0Ahive>=0A=A0 =A0 > CREAT=
E TABLE hbase_table_1(key int, event string)=0A=A0 =A0 > STORED BY 'org.apa=
che.hadoop.hive.hbase.HBaseStorageHandler'=0A=A0 =A0 > WITH SERDEPROPERTIES=
 ("hbase.columns.mapping" =3D ":key,cf1:val")=0A=A0 =A0 > TBLPROPERTIES ("h=
base.table.name" =3D 'USER_DETAILS');=0AFAILED: Error in metadata: MetaExce=
ption(message:Table=A0USER_DETAILS=A0already exists within HBase; use CREAT=
E EXTERNAL TABLE instead to register it in Hive.)=0AFAILED: Execution Error=
, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.=0A=0AI dont wa=
nt to create a external table ..but to access the data from hbase=0A=0A=0A=
=0A=0A________________________________=0AFrom: Abhishek Pratap Singh <manu.=
infy@gmail.com>=0ATo: Aditya Kumar <adityakumar345@yahoo.com> =0ACc: "user@=
hive.apache.org" <user@hive.apache.org> =0ASent: Monday, December 12, 2011 =
9:44 PM=0ASubject: Re: Hive Basic question=0A=0A=0Ait will work, as you wil=
l provide the Serde properties related to HBase. Just create the hive table=
, map it with HBase table and try to access it.=0A=0A=0A~Abhishek=0A=0AOn T=
ue, Dec 13, 2011 at 12:41 AM, Aditya Kumar <adityakumar345@yahoo.com> wrote=
:=0A=0A=0A>Thanks Abhishek for the response.=0A>I did see that link but tha=
t is telling more creating HIVE table and than check in HBAse.=0A>my case i=
s I have the data in tables in Hbase. i can view them in HBase.=0A>but want=
 to do access them from HIVE.=0A>=0A>btn I am new to Hadoop world.=0A>=0A>C=
an yoyu pl let me know if I am missing anything and how to proceed=0A>=0A>=
=0A>=0A>________________________________=0A>From: Abhishek Pratap Singh <ma=
nu.infy@gmail.com>=0A>To: user@hive.apache.org; Aditya Kumar <adityakumar34=
5@yahoo.com>=0A>Sent: Monday, December 12, 2011 9:32 PM=0A>Subject: Re: Hiv=
e Basic question=0A>=0A>=0A>=0A>Here you go, check this link=0A>=0A>https:/=
/cwiki.apache.org/confluence/display/Hive/HBaseIntegration=0A>=0A>Regards,=
=0A>Abhishek=0A>=0A>On Tue, Dec 13, 2011 at 12:30 AM, Aditya Kumar <adityak=
umar345@yahoo.com> wrote:=0A>=0A>Hi,=0A>>I have a Hbase table that I am abl=
e to insert data and do scan.=0A>>I want to have use HIVE,.=0A>>=0A>>I was =
able to install HIVE and login to Hive Console.=0A>>Can you please tell me =
the way I can access the HBASE Table fgrom HIVE.=0A>>I want to use HQL Comm=
ands on HBase table...=0A>>=0A>>please let me know how to do that .=0A>>=0A=
>>Thanks in Advance=0A>>-Adi=0A>>=A0=0A>=A0