hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-2176) Schema creation scripts are incomplete since they leave out tables that are specific to DataNucleus
Date Thu, 02 Jun 2011 06:46:48 GMT

     [ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Carl Steinbach reassigned HIVE-2176:
------------------------------------

    Assignee: Esteban Gutierrez  (was: Carl Steinbach)

@Esteban: Reassigning this to you. Thanks!

> 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
>            Assignee: Esteban Gutierrez
>              Labels: derby, mysql, postgres
>             Fix For: 0.7.1
>
>
> 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

Mime
View raw message