hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 김영우 <warwit...@gmail.com>
Subject Re: Using PostgreSQL as Hive metastore
Date Tue, 17 May 2011 06:23:02 GMT
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_kollam@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

Mime
View raw message