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.8 then there is no upgrade step, there are no metastore schema changes between 0.8 & 0.9, so your existing Hive 0.8 postgres will continue to work with Hive 0.9 c) If you are currently using Hive 0.7 or earlier, then you do need to migrate. Unfortunately, with Hive 0.8 we didn't publish upgrade script for 0.7 to 0.8. But, good news is support for Postgres is reinstated in trunk. You can find Postgres upgrade scripts here: http://svn.apache.org/repos/asf/hive/trunk/metastore/scripts/upgrade/postgres/
Hope it helps, Ashutosh On Fri, May 11, 2012 at 11:28 PM, Xiaobo Gu <guxiaobo1...@gmail.com> wrote: > ** > I can't find it in the release package. > > ------------------------------ > Xiaobo Gu >
