Return-Path: Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org Received: (qmail 64077 invoked from network); 23 Sep 2010 22:17:00 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 23 Sep 2010 22:17:00 -0000 Received: (qmail 50976 invoked by uid 500); 23 Sep 2010 22:16:59 -0000 Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org Received: (qmail 50928 invoked by uid 500); 23 Sep 2010 22:16:59 -0000 Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-user@hadoop.apache.org Delivered-To: mailing list hive-user@hadoop.apache.org Received: (qmail 50919 invoked by uid 99); 23 Sep 2010 22:16:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Sep 2010 22:16:59 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of ncherryus@hotmail.com designates 65.55.90.141 as permitted sender) Received: from [65.55.90.141] (HELO snt0-omc3-s2.snt0.hotmail.com) (65.55.90.141) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Sep 2010 22:16:49 +0000 Received: from SNT135-W3 ([65.55.90.135]) by snt0-omc3-s2.snt0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 23 Sep 2010 15:16:28 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_718cb00e-ac73-479d-8c07-8bbcc41238a4_" X-Originating-IP: [146.79.254.10] From: Tali K To: Subject: Hive multi-user setup: FAILED: Error in metadata: javax.jdo.JDOFatalInternalException Date: Thu, 23 Sep 2010 15:16:28 -0700 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 23 Sep 2010 22:16:28.0276 (UTC) FILETIME=[F7D5A340:01CB5B6C] X-Virus-Checked: Checked by ClamAV on apache.org --_718cb00e-ac73-479d-8c07-8bbcc41238a4_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All=2C =20 We are trying to fet hive 5.0 to use postgresql as a metastore=2C and are = getting the following error: =20 FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creat= ing transactional connection factory NestedThrowables: java.lang.reflect.InvocationTargetException FAILED: Execution Error=2C return code 1 from org.apache.hadoop.hive.ql.exe= c.DDLTask =20 Here is the relevant portion of the hive-site.xml configuration file: =20 javax.jdo.option.ConnectionURL jdbc:postgresql://localhost:5432/hive?CreateDatabaseIfNotExist=3Dt= rue JDBC connect string for a JDBC metastore javax.jdo.option.ConnectionDriverName com.postgresql.jdbc.Driver Driver class name for a JDBC metastore javax.jdo.option.ConnectionUserName hadoop javax.jdo.option.ConnectionPassword hadoop =20 We added these jars to no avail: =20 jpox-rdbms-1.2.3.jar jpox-core-1.2.3.jar jdo2-core-2.0.jar We are using the Cloudera distribution of hadoop & hive=2C and the jdo2-api= jar was already present. =20 Any ideas? Please help!!!!! =20 Thanks in advance=2C Tali = --_718cb00e-ac73-479d-8c07-8bbcc41238a4_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All=2C
=3B
We are trying to fet hive 5.0 =3B =3Bto use postgresql as a metasto= re=2C and are getting the following error:
=3B
FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creat= ing transactional connection factory
NestedThrowables:
java.lang.refl= ect.InvocationTargetException
FAILED: Execution Error=2C return code 1 f= rom org.apache.hadoop.hive.ql.exec.DDLTask
=3B
Here is the relevant portion of the hive-site.xml configuration file:
=3B
<=3Bproperty>=3B
=3B <=3Bname>=3Bjavax.jdo.option.Connectio= nURL<=3B/name>=3B
=3B <=3Bvalue>=3Bjdbc:postgresql://localh= ost:5432/hive?CreateDatabaseIfNotExist=3Dtrue<=3B/value>=3B
=3B= <=3Bdescription>=3BJDBC connect string for a JDBC metastore<=3B/desc= ription>=3B
<=3B/property>=3B
<=3Bproperty>=3B
=3B <=3Bname>=3Bjavax.jdo.option.Connectio= nDriverName<=3B/name>=3B
=3B <=3Bvalue>=3Bcom.postgresql.jd= bc.Driver<=3B/value>=3B
=3B <=3Bdescription>=3BDriver class= name for a JDBC metastore<=3B/description>=3B
<=3B/property>=3B=
<=3Bproperty>=3B
=3B <=3Bname>=3Bjavax.jdo.option.Connectio= nUserName<=3B/name>=3B
=3B <=3Bvalue>=3Bhadoop<=3B/value&= gt=3B
<=3B/property>=3B
<=3Bproperty>=3B
=3B <=3Bname>=3Bjavax.jdo.option.Connectio= nPassword<=3B/name>=3B
=3B <=3Bvalue>=3Bhadoop<=3B/value&= gt=3B
<=3B/property>=3B
=3B
We added these jars to no avail:
=3B
jpox-rdbms-1.2.3.jar
jpox-core-1.2.3.jar
jdo2-core-2.0.jar

We are using the Cloudera distribution of hadoop &=3B hive=2C and the jd= o2-api jar was already present.
=3B
Any ideas? Please help!!!!!
=3B
Thanks in advance=2C
Tali

= --_718cb00e-ac73-479d-8c07-8bbcc41238a4_--