Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # dev >> Post-gres Hive Metastore

Copy link to this message
Post-gres Hive Metastore

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

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.

Kevin Wilfong
Steven Wong 2012-02-09, 19:30