Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Which is the postgres version is compatible for hive-trunk..?


Copy link to this message
-
RE: Which is the postgres version is compatible for hive-trunk..?
rohithsharma 2012-11-06, 08:53
Hi Lorenz,

Thanks for you fast reply :-)

>> Postgres 9x I personally wouldn't choose.
Can you please tell what is the problem using 9x version with hive.?

I tried with 9.0.7, it was successfully integrated and functionality also
fine. But when I changed to 9.1, basic "show table" in hive failed.

I was wondering what is the major change between 9.0.7 to 9.1.4.?
Regards
Rohith Sharma K S

-----Original Message-----
From: Alexander Lorenz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 06, 2012 12:40 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Which is the postgres version is compatible for hive-trunk..?

Hey Rohith,

last time I used psql was with postgresql-8.4-701.jdbc4.jar, and was working
great. But I guess all 8.x version should work. Postgres 9x I personally
wouldn't choose.

best,
 Alex

On Nov 6, 2012, at 5:29 AM, rohithsharma <[EMAIL PROTECTED]> wrote:

> Hi Guys,
>
> I am planning to use postgres as metastore with Hive.  Can anyone point me
> which is the postgres version is compatible with Hive..?
>
>
>
> Regards
>
> Rohith Sharma K S
>

--
Alexander Alten-Lorenz
http://mapredit.blogspot.com
German Hadoop LinkedIn Group: http://goo.gl/N8pCF