hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ehsan Haq <ehsan....@klarna.com>
Subject Re: Problem with using Postgres as hive meta store DB.
Date Wed, 23 Jan 2013 17:34:50 GMT
Well I have tested with version 0.8.1 as well and the same postgresql
schema that is working with 0.9.0 is also working with 0.8.1.

/Ehsan

On Wed, Jan 23, 2013 at 3:09 PM, Ehsan Haq <ehsan.haq@klarna.com> wrote:

> 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 <
> dean.wampler@thinkbiganalytics.com> 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 <ehsan.haq@klarna.com> wrote:
>>
>>> Thanks, that solved the problem :-)
>>>
>>> /Ehsan
>>>
>>>
>>> On Wed, Jan 23, 2013 at 10:00 AM, wd <wd@wdicc.com> wrote:
>>>
>>>>
>>>> On Wed, Jan 23, 2013 at 4:46 PM, Ehsan Haq <ehsan.haq@klarna.com>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
>



-- 
*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

Mime
View raw message