hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <>
Subject [jira] [Commented] (HIVE-16942) INFORMATION_SCHEMA: schematool for setting it up is not idempotent
Date Tue, 27 Jun 2017 16:38:00 GMT


Hive QA commented on HIVE-16942:

Here are the results of testing the latest attachment:

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 10 failed/errored test(s), 10850 tests executed
*Failed tests:*
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_smb_main] (batchId=150)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr] (batchId=146)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query16] (batchId=233)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query94] (batchId=233)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCustomSchema (batchId=178)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation (batchId=178)

Test results:
Console output:
Test logs:

Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 10 tests failed

This message is automatically generated.

ATTACHMENT ID: 12874335 - PreCommit-HIVE-Build

> INFORMATION_SCHEMA: schematool for setting it up is not idempotent
> ------------------------------------------------------------------
>                 Key: HIVE-16942
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: Carter Shanklin
>            Assignee: Gunther Hagleitner
>         Attachments: HIVE-16942.1.patch
> If you run schematool to set up information schema, but the SYS database already exists,
here's what happens:
> {code}
> [vagrant@trunk apache-hive-3.0.0-SNAPSHOT-bin]$ schematool -metaDbType mysql -dbType
hive -initSchema -url jdbc:hive2://localhost:10000/default -driver org.apache.hive.jdbc.HiveDriver
> Metastore connection URL:	 jdbc:hive2://localhost:10000/default
> Metastore Connection Driver :	 org.apache.hive.jdbc.HiveDriver
> Metastore connection User:	 hive
> Starting metastore schema initialization to 3.0.0
> Initialization script hive-schema-3.0.0.hive.sql
> Error: org.apache.hive.service.cli.HiveSQLException: Error while processing statement:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Database
SYS already exists
> 	at org.apache.hive.service.cli.operation.Operation.toSQLException(
> 	at org.apache.hive.service.cli.operation.SQLOperation.runQuery(
> {code}
> Why is this a problem you ask?
> If you run schematool without hive.metastore.db.type set (or set to the wrong thing),
it will create the sys database but fail to create any of the tables within it. If you go
and fix hive.metastore.db.type and re-run you'll get this failure until you drop the SYS database
(which must be done as the hive user).
> Can the init script use "create database if not exists sys" rather than just "create
database sys"?

This message was sent by Atlassian JIRA

View raw message