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

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


+
Ehsan Haq 2013-01-23, 08:46
+
wd 2013-01-23, 09:00
+
Ehsan Haq 2013-01-23, 12:35
Copy link to this message
-
Re: Problem with using Postgres as hive meta store DB.
Dean Wampler 2013-01-23, 14:00
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
+
Ehsan Haq 2013-01-23, 14:09
+
Ehsan Haq 2013-01-23, 17:34