Hi Tali, Is the Postgres JDBC driver JAR on your CLASSPATH? If not you need to download the driver JAR, stick it in a directory, and then set the environment variable HIVE_AUX_JARS_PATH=<driver directory>. Also, can you please turn on logging and send us the log messages, e.g:
% hive -hiveconf hive.root.logger=INFO,console Thanks. Carl On Thu, Sep 23, 2010 at 3:16 PM, Tali K <ncherr...@hotmail.com> wrote: > Hi All, > > We are trying to fet hive 5.0 to use postgresql as a metastore, and are > getting the following error: > > 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 > > Here is the relevant portion of the hive-site.xml configuration file: > > <property> > <name>javax.jdo.option.ConnectionURL</name> > > <value>jdbc:postgresql://localhost:5432/hive?CreateDatabaseIfNotExist=true</value> > <description>JDBC connect string for a JDBC metastore</description> > </property> > <property> > <name>javax.jdo.option.ConnectionDriverName</name> > <value>com.postgresql.jdbc.Driver</value> > <description>Driver class name for a JDBC metastore</description> > </property> > <property> > <name>javax.jdo.option.ConnectionUserName</name> > <value>hadoop</value> > </property> > <property> > <name>javax.jdo.option.ConnectionPassword</name> > <value>hadoop</value> > </property> > > We added these jars to no avail: > > 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, and the jdo2-api > jar was already present. > > Any ideas? Please help!!!!! > > Thanks in advance, > Tali > >
