Return-Path: X-Original-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-hdfs-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 21E1AEEF1 for ; Mon, 26 Nov 2012 12:43:56 +0000 (UTC) Received: (qmail 41583 invoked by uid 500); 26 Nov 2012 12:43:51 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 41456 invoked by uid 500); 26 Nov 2012 12:43:51 -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 41444 invoked by uid 99); 26 Nov 2012 12:43:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Nov 2012 12:43:50 +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 (nike.apache.org: domain of barak.yaish@gmail.com designates 209.85.219.48 as permitted sender) Received: from [209.85.219.48] (HELO mail-oa0-f48.google.com) (209.85.219.48) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Nov 2012 12:43:44 +0000 Received: by mail-oa0-f48.google.com with SMTP id h2so12344850oag.35 for ; Mon, 26 Nov 2012 04:43:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=v0xE9nPWFOyHwkj1c5CXi05BYFyn+s634Elv9qSWVnY=; b=s01pyXYZnOaOsle1a424He8DtBcnjrx0/kXcbigXRMPJnn+Q4E9cWpFiCCvXhKQYz3 q8essPQP9ITmtIlC0bMkxvJnlBtbxWvWlyGIsa4udrpazMAK6yf2rJtgL+y4uYz+awen u/XdvDrAhcVo5wPGg5mf4vo1h1B/gPAhEko2gEuCbI2E3j5CJaczaJA2b0l1lNaErPfR s3KiXnVWU9Y78K+CgqXLVZ7MSpWgU0CKdlLC+HpnELu6ylPZzFtVoyzRbknCFb6kpUTz 3MmlafpmT0Sh+qkiuc/4Sa1bNN4Mz/aIPkRCHeUJLScILKW299WXWlE5BQK8gFB9EUn9 OtNQ== MIME-Version: 1.0 Received: by 10.60.27.36 with SMTP id q4mr9278696oeg.111.1353933803132; Mon, 26 Nov 2012 04:43:23 -0800 (PST) Received: by 10.60.133.47 with HTTP; Mon, 26 Nov 2012 04:43:23 -0800 (PST) Date: Mon, 26 Nov 2012 14:43:23 +0200 Message-ID: Subject: hbase hive integration - "FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory" From: Barak Yaish To: user@hadoop.apache.org Content-Type: multipart/alternative; boundary=e89a8fb1f17262986704cf65474d X-Virus-Checked: Checked by ClamAV on apache.org --e89a8fb1f17262986704cf65474d Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi, We would like to integrate hive with hbase, so we are following the instructions listed here https://cwiki.apache.org/Hive/hbaseintegration.htm= l . Hadoop 1.0.4 Hbase 0.94.2 Hive 0.9.0 I=92ve updated hadoop-env.sh HADOOP_CLASSPATH with hive jars. When running 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. --e89a8fb1f17262986704cf65474d Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable

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.name" =3D &= quot;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.

--e89a8fb1f17262986704cf65474d--