Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-2176

Schema creation scripts are incomplete since they leave out tables that are specific to DataNucleus

    Details

    • Hadoop Flags:
      Reviewed

      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

        Attachments

        1. HIVE-2176.3.patch.txt
          14 kB
          Esteban Gutierrez

          Issue Links

            Activity

              People

              • Assignee:
                esteban Esteban Gutierrez
                Reporter:
                esteban Esteban Gutierrez
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: