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

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


Copy link to this message
-
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