[
https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Esteban Gutierrez updated HIVE-2176:
------------------------------------
Attachment: HIVE-2176.2.patch
Updated patch doesn't include type incompatibility fix for IS_COMPRESSED column
in PostgreSQL and fixes diff file.
> 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.5.0, 0.6.0, 0.7.0
> Reporter: Esteban Gutierrez
> Assignee: Esteban Gutierrez
> Labels: derby, mysql, postgres
> Fix For: 0.7.1
>
> Attachments: HIVE-2176.2.patch, HIVE-2176.patch
>
>
> 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
