Hi Mike, It seems like there are some problems on creating metastore schema. So, create a schema for hive metastore first and then try it again. There is a DDL script for Pg, http://svn.apache.org/repos/asf/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql
- Youngwoo 2011/5/17 Mike <nano_kol...@yahoo.com> > Hi all, > > I am trying to use PostgreSQL as the local metastore in Hive. I have the > postgresql-8.4-701.jdbc4.jar in the path. I use hive-0.7 in my system. > > > I have the following properties added to hive-site.xml. > > > <property> > <name>hive.metastore.local</name> > <value>true</value> > </property> > <property> > <name>javax.jdo.option.ConnectionURL</name> > <value>jdbc:postgresql://localhost:5432/hivedb</value> > </property> > <property> > <name>javax.jdo.option.ConnectionDriverName</name> > <value>org.postgresql.Driver</value> > </property> > <property> > <name>javax.jdo.option.ConnectionUserName</name> > <value>******</value> > </property> > <property> > <name>javax.jdo.option.ConnectionPassword</name> > <value>******</value> > </property> > > I created a table using Hive Cli, and it went good. But when I try to > DROP the table the hive cli hangs and is not responding. > > > I found a similar thread here : > http://search-hadoop.com/m/VYmqW1ejsiA&subj=Re+Can+t+drop+table , but I > didnot quite get the solution. > > Can anyone help me on this? > > > Thanks, > Mike
