[ 
https://issues.apache.org/jira/browse/HIVE-16301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15948269#comment-15948269
 ] 

Naveen Gangam commented on HIVE-16301:
--------------------------------------

Also this is a fairly new test, I added in 2.2. Appears that this is a test 
issue. The test uses the HiveSchemaTool.doUpgrade() API incorrectly. The test 
intends to upgrade from 2.0.0 to 2.2.0. Instead, due to incorrect usage, it 
schema stays at 2.0.0 and compares the DB tables with the 2.0.0 schema files 
and succeeds.
{code}
Starting metastore schema initialization to 2.0.0
Initialization script hive-schema-2.0.0.derby.sql
Initialization script completed
Validating metastore schema tables
Succeeded in schema table validation.
No schema upgrade required from version 2.2.0
Validating metastore schema tables
Succeeded in schema table validation.
Validating metastore schema tables
Table(s) [ [sequence_table, nucleus_tables] ] are missing from the metastore 
database schema.
Schema table validation failed!!!
Validating metastore schema tables
Succeeded in schema table validation.
{code}

But since the new version being added is 2.3.0, the schema is upgraded to 2.3.0 
and hence it sees missing tables that were added in 2.1.0 and hence the failure.
{code}
tarting metastore schema initialization to 2.0.0
Initialization script hive-schema-2.0.0.derby.sql
Initialization script completed
Validating metastore schema tables
Succeeded in schema table validation.
Metastore connection URL:        
jdbc:derby:/home/hiveptest/35.188.60.195-hiveptest-0/apache-github-source-source/itests/hive-unit/target/tmp/test_metastore-1885768448;create=true
Metastore Connection Driver :    org.apache.derby.jdbc.EmbeddedDriver
Metastore connection User:       APP
Starting upgrade metastore schema from version 2.2.0 to 2.3.0
Upgrade script upgrade-2.2.0-to-2.3.0.derby.sql
Completed upgrade-2.2.0-to-2.3.0.derby.sql
Validating metastore schema tables
Table(s) [ [key_constraints, write_set] ] are missing from the metastore 
database schema.
Schema table validation failed!!!
{code}

Fixed the test. Will upload new patch shortly.

> Prepare branch-2 for 2.3 development.
> -------------------------------------
>
>                 Key: HIVE-16301
>                 URL: https://issues.apache.org/jira/browse/HIVE-16301
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 2.3.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>            Priority: Blocker
>         Attachments: HIVE-16301.2.patch, HIVE-16301.patch
>
>
> branch-2 is now being used for 2.3.0 development. The build files will need 
> to reflect this change.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to