[
https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Esteban Gutierrez updated HIVE-2176:
------------------------------------
Description:
When using the DDL SQL scripts to create the Metastore, tables like
SEQUENCE_TABLE are missing and force the user to change the configuration to
use Datanucleus to do all the provisioning of the Metastore tables. Adding the
missing table definitions to the DDL scripts will allow to have a functional
Hive Metastore without enabling additional privileges to the Metastore user
and/or enabling datanucleus.autoCreateSchema property in hive-site.xml
[After running the hive-schema-0.7.0.mysql.sql and revoking ALTER and CREATE
privileges to the 'metastoreuser']
hive> show tables;
FAILED: Error in metadata: javax.jdo.JDOException: Exception thrown calling
table.exists() for `SEQUENCE_TABLE`
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE command
denied to user 'metastoreuser'@'localhost' for table 'SEQUENCE_TABLE'
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
was:
When using the DDL SQL scripts to create the Metastore, tables like
SEQUENCE_TABLE are missing and force the user to change the configuration to
use Datanucleus to do all the provisioning of the Metastore tables. Adding the
missing table definitions to the DDL scripts will allow to have a functional
Hive Metastore without enabling additional privileges to the Metastore user
and/or enabling datanucleus.autoCreateSchema property in hive-site.xml
> Schema creation scripts are incomplete since they leave out tables that are
> specific to DataNucleus
> ---------------------------------------------------------------------------------------------------
>
> Key: HIVE-2176
> URL: https://issues.apache.org/jira/browse/HIVE-2176
> Project: Hive
> Issue Type: Bug
> Components: Configuration, Metastore
> Affects Versions: 0.7.0
> Reporter: Esteban Gutierrez
> Labels: derby, mysql, postgres
>
> When using the DDL SQL scripts to create the Metastore, tables like
> SEQUENCE_TABLE are missing and force the user to change the configuration to
> use Datanucleus to do all the provisioning of the Metastore tables. Adding
> the missing table definitions to the DDL scripts will allow to have a
> functional Hive Metastore without enabling additional privileges to the
> Metastore user and/or enabling datanucleus.autoCreateSchema property in
> hive-site.xml
> [After running the hive-schema-0.7.0.mysql.sql and revoking ALTER and CREATE
> privileges to the 'metastoreuser']
> hive> show tables;
> FAILED: Error in metadata: javax.jdo.JDOException: Exception thrown calling
> table.exists() for `SEQUENCE_TABLE`
> NestedThrowables:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE command
> denied to user 'metastoreuser'@'localhost' for table 'SEQUENCE_TABLE'
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
