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

Switch to Threaded View
Hive, mail # user - Problem with using Postgres as hive meta store DB.


Copy link to this message
-
Re: Problem with using Postgres as hive meta store DB.
Ehsan Haq 2013-01-23, 14:09
Hmm. I have ran it on 0.9.0, will try it on 0.8.1. However i also found an
upgrade script for mysql from 0.8.0 to 0.9.0, and it didn't had anything
just two select static text lines. So I thought it would be same for
postgres, also the postgres schema that I am using was for version 0.7.0
which I found in some old version as the latest releases don't have a
postgres script in them.

/Ehsan

On Wed, Jan 23, 2013 at 3:00 PM, Dean Wampler <
[EMAIL PROTECTED]> wrote:

> Are you able to use Hive v0.8.1 and v0.9.0 interchangeably? Since the
> metadata schema changed between versions, I wouldn't expect 0.8.1 to work
> if you're schema is set up for 0.9.0.
>
> dean
>
>
> On Wed, Jan 23, 2013 at 6:35 AM, Ehsan Haq <[EMAIL PROTECTED]> wrote:
>
>> Thanks, that solved the problem :-)
>>
>> /Ehsan
>>
>>
>> On Wed, Jan 23, 2013 at 10:00 AM, wd <[EMAIL PROTECTED]> wrote:
>>
>>>
>>> On Wed, Jan 23, 2013 at 4:46 PM, Ehsan Haq <[EMAIL PROTECTED]> wrote:
>>>
>>>> ERROR: invalid escape string
>>>>   Hint: Escape string must be empty or one character..)
>>>>
>>>
>>>
>>> You can set standard_conforming_strings = off in postgresql.conf to
>>> avoid this.
>>>
>>>
>>
>>
>> --
>> *Muhammad Ehsan ul Haque*
>> Klarna AB
>> Norra Stationsgatan 61
>> SE-113 43 Stockholm
>>
>> Tel: +46 (0)8- 120 120 00
>> Fax: +46 (0)8- 120 120 99
>> Web: www.klarna.com
>>
>
>
>
> --
> *Dean Wampler, Ph.D.*
> thinkbiganalytics.com
> +1-312-339-1330
>
>
--
*Muhammad Ehsan ul Haque*
Klarna AB
Norra Stationsgatan 61
SE-113 43 Stockholm

Tel: +46 (0)8- 120 120 00
Fax: +46 (0)8- 120 120 99
Web: www.klarna.com