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
this is caused by HIVE auto create some meta tables when found them has not
created.
when you create table without partition or index,it will not touch the
partition or index meta table,all goes well.but when you drop the table ,it
will query the partition or index meta table,but find it has not c
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.
hive.metastore.local
true
javax.jdo.option.ConnectionURL
