Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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
+
Steven Wong 2012-02-09, 19:30
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB