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

(Updated Sept. 18, 2013, 5:45 a.m.)


Review request for hive, Ashutosh Chauhan and Brock Noland.


Changes
-------

Changes per review feedback.
- rename the comment field.
- fixed typos and updated variable name
- fixed the version comparison case
- build script update to set the hive dist path for testing (was missed in the 
original diff when the large patch was split into two.)


Bugs: HIVE-3764
    https://issues.apache.org/jira/browse/HIVE-3764


Repository: hive-git


Description
-------

This is a 0.12 specific patch. The trunk patch will include additional 
metastore scripts which I will attach separately to the ticket.

- Added a new table in the metastore schema to store the Hive version in the 
metastore.
- Metastore handler compare the version stored in the schema with its own 
version. If there's a mismatch, then it can either record the correct version 
or raise error. The behavior is configurable via a new Hive config. This config 
when set, also restrict dataNucleus to auto upgrade the schema.
- The new schema creation and upgrade scripts record the new version in the 
metastore version table.
- Added 0.12 upgrade scripts for all supported DBs to creates the new table 
version tables in 0.12 metastore schema

The current patch has the verification turned off by default. I would prefer to 
keep it enabled, though it require any add-hoc setup to explicitly disable it 
(or create the metastore schema by running scripts). The default can be changed 
or left as is as per the consensus. 


Diffs (updated)
-----

  build-common.xml ad5ac23 
  common/src/java/org/apache/hadoop/hive/conf/HiveConf.java 1474469 
  conf/hive-default.xml.template c123452 
  metastore/scripts/upgrade/derby/014-HIVE-3764.derby.sql PRE-CREATION 
  metastore/scripts/upgrade/derby/hive-schema-0.12.0.derby.sql cce544f 
  metastore/scripts/upgrade/derby/upgrade-0.10.0-to-0.11.0.derby.sql cae7936 
  metastore/scripts/upgrade/derby/upgrade-0.11.0-to-0.12.0.derby.sql 492cc93 
  metastore/scripts/upgrade/derby/upgrade.order.derby PRE-CREATION 
  metastore/scripts/upgrade/mysql/014-HIVE-3764.mysql.sql PRE-CREATION 
  metastore/scripts/upgrade/mysql/hive-schema-0.12.0.mysql.sql 22a77fe 
  metastore/scripts/upgrade/mysql/upgrade-0.11.0-to-0.12.0.mysql.sql 375a05f 
  metastore/scripts/upgrade/mysql/upgrade.order.mysql PRE-CREATION 
  metastore/scripts/upgrade/oracle/014-HIVE-3764.oracle.sql PRE-CREATION 
  metastore/scripts/upgrade/oracle/hive-schema-0.12.0.oracle.sql 85a0178 
  metastore/scripts/upgrade/oracle/upgrade-0.10.0-to-0.11.0.mysql.sql 
PRE-CREATION 
  metastore/scripts/upgrade/oracle/upgrade-0.11.0-to-0.12.0.oracle.sql a2d0901 
  metastore/scripts/upgrade/oracle/upgrade.order.oracle PRE-CREATION 
  metastore/scripts/upgrade/postgres/014-HIVE-3764.postgres.sql PRE-CREATION 
  metastore/scripts/upgrade/postgres/hive-schema-0.12.0.postgres.sql 7b319ba 
  metastore/scripts/upgrade/postgres/upgrade-0.11.0-to-0.12.0.postgres.sql 
9da0a1b 
  metastore/scripts/upgrade/postgres/upgrade.order.postgres PRE-CREATION 
  metastore/src/java/org/apache/hadoop/hive/metastore/HiveMetaStore.java 
39dda92 
  metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreSchemaInfo.java 
PRE-CREATION 
  metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java a27243d 
  metastore/src/java/org/apache/hadoop/hive/metastore/RawStore.java e410c3a 
  metastore/src/model/org/apache/hadoop/hive/metastore/model/MVersionTable.java 
PRE-CREATION 
  metastore/src/model/package.jdo c42b5b0 
  
metastore/src/test/org/apache/hadoop/hive/metastore/DummyRawStoreControlledCommit.java
 8066784 
  
metastore/src/test/org/apache/hadoop/hive/metastore/DummyRawStoreForJdoConnection.java
 0f9b16c 
  metastore/src/test/org/apache/hadoop/hive/metastore/TestMetastoreVersion.java 
PRE-CREATION 

Diff: https://reviews.apache.org/r/14169/diff/


Testing
-------

Added new tests for schema verification. Manually tested the upgrades using 
derby and MySQL.


Thanks,

Prasad Mujumdar

Reply via email to