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