Hi all, We use postgres as a metastore for Hive and haven't come across any problems. The postgres driver jar is: postgresql-8.4.701-jdbc.jar. We use the version of hive that comes out of Cloudera's CDH3b2, which I believe is some variant of Hive 0.5.0.
Java: HotSpot 1.6.0_20 OS: Ubuntu Lucid (10.04) Postgres: 8.4.4 Postgres JDBC driver: postgresql-8.4.701-jdbc.jar Hadoop: 0.20.2+320 (Cloudera CDH3b2) Hive: 0.5.0+20 (Cloudera CDH3b2) Thanks, Jamie On 17 January 2011 13:13, Edward Capriolo <edlinuxg...@gmail.com> wrote: > You are the first person I have heard of using postgres. I commend you > for not succumbing to the social pressure and just installing mysql. > However I would advice succumbing to the social pressure and using > either derby or mysql. > > The reason I say this is because jpox "has support" for a number of > data stores (M$ SQL server) however, people have run into issues with > them. Databases other then derby and mysql 'should work' but are > generally untested. > > Edward > > On Mon, Jan 17, 2011 at 2:52 AM, wd <w...@wdicc.com> wrote: > > Finally I found, when use hive-0.5.0-bin, 'drop table' will hung at first > > time, after Ctrl-c kill the client, and run hive again, it can > successfully > > drop the table. When use hive-0.6.0-bin, it will always hung there. > > > > 2011/1/6 wd <w...@wdicc.com> > >> > >> hi, > >> > >> I've setup a single node hadoop and hive. And can create table in hive, > >> but can't drop table, hive cli will hang there, nothing more infos. > >> > >> hive-0.6.0-bin > >> hadoop-0.20.2 > >> jre1.6.0_23 > >> postgresql-9.0-801.jdbc4.jar (have tried postgresql-8.4-701.jdbc4.jar) > >> pgsql 9.0.2 > >> > >> How to find what's wrong happed? thx. > > > > >