hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike <nano_kol...@yahoo.com>
Subject Using PostgreSQL as Hive metastore
Date Mon, 16 May 2011 15:54:21 GMT
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

Mime
View raw message