[
https://issues.apache.org/jira/browse/HIVE-10468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15144660#comment-15144660
]
Naveen Gangam commented on HIVE-10468:
--------------------------------------
The METASTORE-Test builds are not working on 32-bit VMs including the newly
added upgrade script for Oracle DB.
Test failed: mysql/upgrade-1.2.0-to-2.0.0.mysql.sql
The issue here is that there are 2 upgrade scripts, (true for all other
supported SQL engines)
upgrade-1.2.0-to-1.3.0.*.sql
upgrade-1.2.0-to-2.0.0.*.sql
Both these scripts above run the same SQL commands, for example add the same
column to the same table. When the first script run, that column would have
already been added. So when the second script runs, it fails because that
change already exists.
For some reason, only mysql reports this as error.
{code}
Upgrading MetaStore schema from 1.2.0 to 1.3.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
Finished upgrading MetaStore schema from 1.2.0 to 1.3.0
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) at line 1 in file: '023-HIVE-12807.mysql.sql': Duplicate
column name 'CQ_HIGHEST_TXN_ID'
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
Test failed: mysql/upgrade-1.2.0-to-2.0.0.mysql.sql
{code}
I think we are ready to commit this patch to the code. I will upload the new
patch without the "induced" schema changes that contains just the scripts for
oracle DB. Thanks
> Create scripts to do metastore upgrade tests on jenkins for Oracle DB.
> ----------------------------------------------------------------------
>
> Key: HIVE-10468
> URL: https://issues.apache.org/jira/browse/HIVE-10468
> Project: Hive
> Issue Type: Improvement
> Components: Metastore
> Affects Versions: 1.1.0
> Reporter: Naveen Gangam
> Assignee: Naveen Gangam
> Attachments: HIVE-10468.1.patch, HIVE-10468.10.patch,
> HIVE-10468.2.patch, HIVE-10468.3.patch, HIVE-10468.4.patch,
> HIVE-10468.5.patch, HIVE-10468.6.patch, HIVE-10468.7.patch,
> HIVE-10468.9.patch, HIVE-10468.9.patch, HIVE-10468.patch
>
>
> This JIRA is to isolate the work specific to Oracle DB in HIVE-10239. Because
> of absence of 64 bit debian packages for oracle-xe, the apt-get install fails
> on the AWS systems.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
