Hello,

Does anyone still use postgres as the Hive metastore SQL backend?

I'm in the process of writing scripts to upgrade the metastore schema as part of
https://issues.apache.org/jira/browse/HIVE-2612

I noticed that the postgres metastore upgrade scripts are missing the script for HIVE-2246.  This patch added a new table COLUMNS_V2 and completely rearranged the way column information is stored in the metastore.  Without this  change, I don't know how anyone could continue to use postgres for Hive after upgrading to HIVE-2246.

Thanks,
Kevin Wilfong

-----Original Message-----
From: Kevin Wilfong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 09, 2012 10:59 AM
To: [EMAIL PROTECTED]
Subject: Post-gres Hive Metastore

Hello,

Does anyone still use postgres as the Hive metastore SQL backend?

I'm in the process of writing scripts to upgrade the metastore schema as part of
https://issues.apache.org/jira/browse/HIVE-2612

I noticed that the postgres metastore upgrade scripts are missing the script for HIVE-2246.  This patch added a new table COLUMNS_V2 and completely rearranged the way column information is stored in the metastore.  Without this  change, I don't know how anyone could continue to use postgres for Hive after upgrading to HIVE-2246.

Thanks,
Kevin Wilfong