While running some HMS upgrade tests, I found an issue while upgrading Mysql metastore from 1.2.0 to 2.0.0 http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-METASTORE-Test/110/consoleFull
Executing sql test: mysql/upgrade-1.2.0-to-2.0.0.mysql.sql ++ dirname /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql + cd /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql Executing script: /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql + echo 'Executing script: /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql' + mysql hive_hms_testing ERROR 1060 (42S21) Upgrading MetaStore schema from 1.2.0 to 2.0.0 < HIVE-7018 Remove Table and Partition tables column LINK_TARGET_ID from Mysql for other DBs do not have it > Completed remove LINK_TARGET_ID Completed remove LINK_TARGET_ID at line 1 in file: '023-HIVE-12807.mysql.sql': Duplicate column name 'CQ_HIGHEST_TXN_ID' Test failed: mysql/upgrade-1.2.0-to-2.0.0.mysql.sql Error: Cannot execute SQL file: /hive/testutils/metastore/../../metastore/scripts/upgrade/mysql/upgrade-1.2.0-to-2.0.0.mysql.sql I think we should identify and fix the issue. I am -1 - Sergio On Thu, Feb 11, 2016 at 1:40 PM, Alan Gates <alanfga...@gmail.com> wrote: > +1, checks sigs, build with fresh maven repo, and did a quick smoke test. > > Does the PMC member who votes on the most RC's get a prize? > > Alan. > > Sergey Shelukhin <ser...@apache.org> > February 9, 2016 at 18:52 > Another day, another release candidate... this time fixing the logging > issue. > > Apache Hive 2.0.0 Release Candidate 3 is available here: > > http://people.apache.org/~sershe/hive-2.0.0-rc3/ > > Maven artifacts are at > > https://repository.apache.org/content/repositories/orgapachehive-1046/ > > > Source tag for RC3 (github mirror) is: > https://github.com/apache/hive/releases/tag/release-2.0.0-rc3 > > > Voting will conclude in 72 hours. > > Hive PMC Members: Please test and vote. > > > Thanks. > > >