You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Esteban Gutierrez (JIRA)" <ji...@apache.org> on 2011/05/21 02:29:47 UTC
[jira] [Created] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
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
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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2176:
---------------------------------
Fix Version/s: 0.7.1
> 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: Carl Steinbach
> 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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ 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.3.patch.txt
Fix for PostgreSQL type in IS_COMPRESSED now is included again.
> 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.3.patch.txt, 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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Esteban Gutierrez updated HIVE-2176:
------------------------------------
Affects Version/s: 0.5.0
0.6.0
Status: Patch Available (was: Open)
The patch fixes the missing tables in the SQL schema for MySQL, PostgreSQL and Derby that Datanucleus creates at runtime.
Also fixes a type incompatibility in the SDS table for PostgreSQL (IS_COMPRESSED should be boolean but is de
> 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, 0.6.0, 0.5.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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Esteban Gutierrez updated HIVE-2176:
------------------------------------
Attachment: (was: HIVE-2176.2.patch)
> 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.3.patch.txt
>
>
> 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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Esteban Gutierrez updated HIVE-2176:
------------------------------------
Attachment: metastore-datanucleus.patch
> 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: metastore-datanucleus.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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Assigned] (HIVE-2176) Schema creation scripts are
incomplete since they leave out tables that are specific to DataNucleus
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach reassigned HIVE-2176:
------------------------------------
Assignee: Carl Steinbach
> 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: Carl Steinbach
> 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
[jira] [Commented] (HIVE-2176) Schema creation scripts are
incomplete since they leave out tables that are specific to DataNucleus
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13042401#comment-13042401 ]
Carl Steinbach commented on HIVE-2176:
--------------------------------------
We should try to get a fix for this in to 0.7.1.
Assigning to myself.
> 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
> 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
[jira] [Resolved] (HIVE-2176) Schema creation scripts are
incomplete since they leave out tables that are specific to DataNucleus
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach resolved HIVE-2176.
----------------------------------
Resolution: Fixed
Fix Version/s: 0.8.0
Hadoop Flags: [Reviewed]
Committed to trunk and branch-0.7. Thanks Esteban!
> 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, 0.8.0
>
> Attachments: HIVE-2176.3.patch.txt
>
>
> 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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Esteban Gutierrez updated HIVE-2176:
------------------------------------
Attachment: (was: HIVE-2176.patch)
> 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.3.patch.txt
>
>
> 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
[jira] [Commented] (HIVE-2176) Schema creation scripts are
incomplete since they leave out tables that are specific to DataNucleus
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13054059#comment-13054059 ]
Hudson commented on HIVE-2176:
------------------------------
Integrated in Hive-trunk-h0.21 #790 (See [https://builds.apache.org/job/Hive-trunk-h0.21/790/])
> 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, 0.8.0
>
> Attachments: HIVE-2176.3.patch.txt
>
>
> 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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Esteban Gutierrez updated HIVE-2176:
------------------------------------
Attachment: (was: metastore-datanucleus.patch)
> 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.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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Commented] (HIVE-2176) Schema creation scripts are
incomplete since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13042613#comment-13042613 ]
Esteban Gutierrez commented on HIVE-2176:
-----------------------------------------
I'm working on a patch for this.
> 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: Carl Steinbach
> 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
[jira] [Assigned] (HIVE-2176) Schema creation scripts are
incomplete since they leave out tables that are specific to DataNucleus
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ 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.patch
> 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.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
[jira] [Updated] (HIVE-2176) Schema creation scripts are incomplete
since they leave out tables that are specific to DataNucleus
Posted by "Esteban Gutierrez (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Esteban Gutierrez updated HIVE-2176:
------------------------------------
Status: In Progress (was: Patch Available)
Attached patch solves issue, please review.
> 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, 0.6.0, 0.5.0
> Reporter: Esteban Gutierrez
> Assignee: Esteban Gutierrez
> Labels: derby, mysql, postgres
> Fix For: 0.7.1
>
> Attachments: HIVE-2176.3.patch.txt
>
>
> 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