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
