Thanks for you reply.. I will use 9.0.x version. -----Original Message----- From: Alexander Lorenz [mailto:wget.n...@gmail.com] Sent: Tuesday, November 06, 2012 3:34 PM To: rohithsharm...@huawei.com Cc: user@hive.apache.org Subject: Re: Which is the postgres version is compatible for hive-trunk..?
Hi, I don't know what exactly was the major changes between 9.0.x and 9.1.x, but when you've a good experience with 9.0.x, use it :) For 9.1.x, it would be great to get a log or stack trace to see whats going wrong there. best, Alex On Nov 6, 2012, at 9:53 AM, rohithsharma <rohithsharm...@huawei.com> wrote: > 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:wget.n...@gmail.com] > Sent: Tuesday, November 06, 2012 12:40 PM > To: user@hive.apache.org; rohithsharm...@huawei.com > 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 <rohithsharm...@huawei.com> 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 > -- Alexander Alten-Lorenz http://mapredit.blogspot.com German Hadoop LinkedIn Group: http://goo.gl/N8pCF
