Re: Re: Is there a metastore schema script for postgresql for Hive version 0.9.0

2012-05-12 Thread Xiaobo Gu
Thanks, I will try that. Xiaobo Gu From: Carl Steinbach Date: 2012-05-13 10:30 To: user CC: guxiaobo1982 Subject: Re: Is there a metastore schema script for postgresql for Hive version 0.9.0 Hi Xiabo, Upgrade/schema scripts for Postgres were committed to trunk last week in HIVE-2529

Re: Is there a metastore schema script for postgresql for Hive version 0.9.0

2012-05-12 Thread Carl Steinbach
Hi Xiabo, Upgrade/schema scripts for Postgres were committed to trunk last week in HIVE-2529 (https://issues.apache.org/jira/browse/HIVE-2529). This patch includes schema DDL for Hive 0.8.0 and 0.9.0, as well as an 0.7.0->0.8.0 upgrade script. Right now these scripts are only available in the sour

Re: Is there a metastore schema script for postgresql for Hive version 0.9.0

2012-05-12 Thread Ashutosh Chauhan
Hi Xiaobo, It depends on what your current setup is: a) If you are trying Hive for the first time, then you don't necessarily need to create schema in postgres upfront. As wd suggested, datanucleus (ORM used by Hive) can autocreate the schema if it doesn't exist. b) If you are already using Hive 0

Re: Is there a metastore schema script for postgresql for Hive version 0.9.0

2012-05-12 Thread wd
Hive can auto create metadata tables, maybe you can try it out. On Sat, May 12, 2012 at 2:28 PM, Xiaobo Gu wrote: > I can't find it in the release package. > > > Xiaobo Gu

Re: Is there a metastore schema script for postgresql for Hive version 0.9.0

2012-05-11 Thread Jagat
May be you can see razorsql to convert schemas. --- Sent from Mobile , short and crisp. On 12-May-2012 11:58 AM, "Xiaobo Gu" wrote: > ** > I can't find it in the release package. > > -- > Xiaobo Gu >