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

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