hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "tc@postgresql.hk" ...@postgresql.hk>
Subject Re: Which is the postgres version is compatible for hive-trunk..?
Date Tue, 06 Nov 2012 10:41:39 GMT
Hi,

Some major differences between these versions are:
PostgreSQL 9.0 - Streaming Replication and Hot Standby  (latest is 9.0.10)
PostgreSQL 9.1 - Synchronous Replication (latest is 9.1.6)
PostgreSQL 9.2 - Cascading Replication (latest is 9.2.1) 
PostgreSQL 9.3 - (not yet release version: Multiple-master replication)

Also here is a link about PostgreSQL Feature Matrix per version: http://www.emblocsoft.com/PostgreSQL/PostgreSQL-Feature-Matrix

Could you share what issues you have about '9.1, basic "show table" in hive failed' so we
might be of help.

With Regards
TC

On 6 Nov 2012, at 6:03 PM, Alexander Lorenz wrote:

> 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 <rohithsharmaks@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.null@gmail.com] 
>> Sent: Tuesday, November 06, 2012 12:40 PM
>> To: user@hive.apache.org; rohithsharmaks@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 <rohithsharmaks@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
> 


Mime
View raw message