Return-Path: X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 418F9EF39 for ; Mon, 26 Nov 2012 12:54:48 +0000 (UTC) Received: (qmail 72007 invoked by uid 500); 26 Nov 2012 12:54:43 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 71807 invoked by uid 500); 26 Nov 2012 12:54:43 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 71779 invoked by uid 99); 26 Nov 2012 12:54:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Nov 2012 12:54:42 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dontariq@gmail.com designates 209.85.216.176 as permitted sender) Received: from [209.85.216.176] (HELO mail-qc0-f176.google.com) (209.85.216.176) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Nov 2012 12:54:36 +0000 Received: by mail-qc0-f176.google.com with SMTP id n41so8712492qco.35 for ; Mon, 26 Nov 2012 04:54:16 -0800 (PST) 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=BXG6zkUt1W5CNn9MlCDc5AbedgSQtpI6gYzDuZGwFkY=; b=UM9gnSvQIjmzH9wW9mNZTrnENZfosJeiqfneuQSjtaZmuJDPnum9VC2+0Cg73k3Z8K ZGS3pzn/3cYM+BZE6yEdZ1E/ZFXDyAKH2fU0VkWZTQRkSJvws7TAPcBg7cThokFTKaHl VIcdIwOlnAwMLxivvbuf8W//acaWXrPikTfpytjdrOz6TeNFqjqFiLJc547hulGXQDuC fupDHd1wSRvMVimL1A8Lf3Rpt66WUT7yAEP4Ikxi1RPIYhZEVN1FUJwD5xwsyM1++cOE u6DiCmA76eHiFayH49k5+h/35wJGt3yIGAKrwAVFB9jKD3+0TtqDvcH3byHCTOPgkNQY 4BOw== Received: by 10.224.95.196 with SMTP id e4mr12018698qan.88.1353934456048; Mon, 26 Nov 2012 04:54:16 -0800 (PST) MIME-Version: 1.0 Received: by 10.229.126.165 with HTTP; Mon, 26 Nov 2012 04:53:35 -0800 (PST) In-Reply-To: References: From: Mohammad Tariq Date: Mon, 26 Nov 2012 18:23:35 +0530 Message-ID: Subject: Re: hbase hive integration - "FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory" To: "user@hadoop.apache.org" Content-Type: multipart/alternative; boundary=20cf3063e3554d4d6f04cf656e60 X-Virus-Checked: Checked by ClamAV on apache.org --20cf3063e3554d4d6f04cf656e60 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hello Barak, Are you using the default metadata store(derby) or tying to use something else like MySQL?If latter is the case, make sure you have the necessary connector in place. Also, is your Hive working fine independently= ? Regards, Mohammad Tariq On Mon, Nov 26, 2012 at 6:13 PM, Barak Yaish wrote: > Hi, > > > > We would like to integrate hive with hbase, so we are following the > instructions listed here > https://cwiki.apache.org/Hive/hbaseintegration.html. > > > > Hadoop 1.0.4 > > Hbase 0.94.2 > > Hive 0.9.0 > > > > I=92ve updated hadoop-env.sh HADOOP_CLASSPATH with hive jars. When runnin= g > hive and trying to create the table as described in the above link, the > following error is thrown: > > > > hive> CREATE TABLE hbase_table_1(key int, value string) > > > STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' > > > WITH SERDEPROPERTIES ("hbase.columns.mapping" =3D ":key,cf1:val") > > > TBLPROPERTIES ("hbase.table.name" =3D "xyz"); > > FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error > creating transactional connection factory > > NestedThrowables: > > java.lang.reflect.InvocationTargetException > > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask > > > > Can anyone suggest what else need to be done in order to set up the > integration? > > > > Thanks. > --20cf3063e3554d4d6f04cf656e60 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hello Barak,

=A0 =A0 =A0Are you using the default metada= ta store(derby) or tying to use something else like MySQL?If latter is the = case, make sure you have the necessary connector in place. Also, is your Hi= ve working fine independently?

Regards,
=A0=A0 =A0Mohamma= d Tariq



On Mon, Nov 26, 2012 at 6:13 PM, Barak Y= aish <barak.yaish@gmail.com> wrote:

Hi,

=A0

We would like to integrate hive with hbase, so we ar= e following the instructions listed here https://cwiki.apache.org/Hive= /hbaseintegration.html.

=A0

Hadoop 1.0.4

Hbase 0.94.2

Hive 0.9.0

=A0

I=92ve updated hadoop-env.sh HADOOP_CLASSPATH with h= ive jars. When running hive and trying to create the table as described in the above link,= the following error is thrown:

=A0

hive> CREATE TABLE hbase_table_1(key int, value s= tring)

=A0=A0=A0 > STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'

=A0=A0=A0 > WITH SERDEPROPERTIES ("hbase.columns.mapping" =3D ":key,cf1:val&q= uot;)

=A0=A0=A0 > TBLPROPERTIES ("hbase.table.na= me" =3D "xyz");

FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connectio= n factory

NestedThrowables:

java.lang.reflect.InvocationTargetException

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

=A0

Can anyone suggest what else need to be done in orde= r to set up the integration?

=A0

Thanks.


--20cf3063e3554d4d6f04cf656e60--