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

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

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

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 <[EMAIL PROTECTED]> 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:[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
>

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

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 <[EMAIL PROTECTED]> 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:[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
>>
>
> --
> Alexander Alten-Lorenz
> http://mapredit.blogspot.com
> German Hadoop LinkedIn Group: http://goo.gl/N8pCF
>

Thanks for you reply.. I will use 9.0.x version.

-----Original Message-----
From: Alexander Lorenz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 06, 2012 3:34 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]> 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:[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
>

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