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

Switch to Threaded View
Hive >> mail # dev >> Review Request 14170: HIVE-5301: Add a schema tool for offline metastore schema upgrade


Copy link to this message
-
Re: Review Request 14170: HIVE-5301: Add a schema tool for offline metastore schema upgrade

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/14170/
-----------------------------------------------------------

(Updated Sept. 23, 2013, 8:52 p.m.)
Review request for hive, Ashutosh Chauhan, Brock Noland, and Thejas Nair.
Changes
-------

- DB parser re-factoring to handle 0.7 to 0.8 MySQL scritps
- Fixed column name update from COMMENT to VERSION_COMMENT, that was missed in the original  HIVE-3764 patch for a couple of upgrade scripts
Bugs: HIVE-5301
    https://issues.apache.org/jira/browse/HIVE-5301
Repository: hive-git
Description
-------

Schema tool to initialize and migrate hive metastore schema
- Extract the metastore connection details from hive configuration
- the target version is extracted from binary and metastore if possible, optionally can be specified as argument
- determine the scripts needs to be executed for the initialization or upgrade
- handle DB nested scripts
- execute the required scripts using beeline
Diffs (updated)
-----

  beeline/src/java/org/apache/hive/beeline/BeeLine.java 2802f4c
  beeline/src/java/org/apache/hive/beeline/BeeLineOpts.java c9e24fa
  beeline/src/java/org/apache/hive/beeline/Commands.java c574cd4
  beeline/src/java/org/apache/hive/beeline/HiveSchemaHelper.java PRE-CREATION
  beeline/src/java/org/apache/hive/beeline/HiveSchemaTool.java PRE-CREATION
  beeline/src/test/org/apache/hive/beeline/src/test/TestSchemaTool.java PRE-CREATION
  bin/ext/schemaTool.sh PRE-CREATION
  bin/schematool PRE-CREATION
  build.xml cf75b3d
  metastore/scripts/upgrade/derby/014-HIVE-3764.derby.sql 4e08fc1
  metastore/scripts/upgrade/mysql/014-HIVE-3764.mysql.sql 08c73f6
  metastore/scripts/upgrade/oracle/014-HIVE-3764.oracle.sql 7e8530d
  metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql a6f1537

Diff: https://reviews.apache.org/r/14170/diff/
Testing
-------

Added unit tests. Manually tested various options using derby and MySQL.
Thanks,

Prasad Mujumdar