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