Re: Problem with using Postgres as hive meta store DB.

2013-01-23 Thread Ehsan Haq
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 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 fr

Re: Problem with using Postgres as hive meta store DB.

2013-01-23 Thread Ehsan Haq
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 f

Re: Problem with using Postgres as hive meta store DB.

2013-01-23 Thread Dean Wampler
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 wrote: > Thanks, that solved the problem :-) > > /Ehsan > > > On

Re: Problem with using Postgres as hive meta store DB.

2013-01-23 Thread Ehsan Haq
Thanks, that solved the problem :-) /Ehsan On Wed, Jan 23, 2013 at 10:00 AM, wd wrote: > > On Wed, Jan 23, 2013 at 4:46 PM, Ehsan Haq wrote: > >> ERROR: invalid escape string >> Hint: Escape string must be empty or one character..) >> > > > You can set standard_conforming_strings = off in po

Re: Problem with using Postgres as hive meta store DB.

2013-01-23 Thread wd
On Wed, Jan 23, 2013 at 4:46 PM, Ehsan Haq 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.

Problem with using Postgres as hive meta store DB.

2013-01-23 Thread Ehsan Haq
Hi, I am new to hive, and I am trying to use postgresql9.1 as a meta data store for hive. I read and followed the tutorial posted by cloudera " https://ccp.cloudera.com/display/CDH4DOC/Hive+Installation#HiveInstallation-InstallingHive";. However I am unable to use it. Below are further details.