hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergio Pena <sergio.p...@cloudera.com>
Subject Re: [VOTE] Apache Hive 2.0.0 Release Candidate 3
Date Thu, 11 Feb 2016 20:13:08 GMT
I found the reason of the failure, and it is due to these 2 upgrades
executed in order:

mysql/upgrade-1.2.0-to-1.3.0.mysql.sql
mysql/upgrade-1.2.0-to-2.0.0.mysql.sql

Both sql files have the same commands, so 1.2.0 -> 2.0.0 fails with
repeated columns.
The HMS upgrade script will need to handle this special situation.

Back to +1

On Thu, Feb 11, 2016 at 2:04 PM, Sergio Pena <sergio.pena@cloudera.com>
wrote:

> 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 <alanfgates@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 <sershe@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.
>>
>>
>>
>

Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message