[jira] [Created] (AMBARI-21422) Missing database table when using Hive 2.0 View

["Chien Le (JIRA)" <ji...@apache.org>]

Chien Le created AMBARI-21422:
---------------------------------

             Summary: Missing database table when using Hive 2.0 View
                 Key: AMBARI-21422
                 URL: https://issues.apache.org/jira/browse/AMBARI-21422
             Project: Ambari
          Issue Type: Bug
          Components: ambari-views
    Affects Versions: 2.5.1
         Environment: Mysql 5.6
Ubuntu 16.04 x64
            Reporter: Chien Le


When trying to use Hive 2.0 view to run adhoc queries, even simple describe table commands are failing with attached stack trace. Relevant portion:
{{Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.DS_JOBIMPL_63' doesn't exist
Error Code: 1146
Call: INSERT INTO DS_JOBIMPL_63 (DS_id, DS_applicationId, DS_confFile, DS_dagId, DS_dagName, DS_dataBase, DS_dateSubmitted, DS_duration, DS_forcedContent, DS_globalSettings, DS_guid, DS_hiveQueryId, DS_logFile, DS_owner, DS_queryFile, DS_queryId, DS_referrer, DS_sessionTag, DS_sqlState, DS_status, DS_statusDir, DS_statusMessage, DS_title) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
 bind => [23 parameters bound]
 at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:159)
 at org.apache.ambari.server.view.persistence.DataStoreImpl.store(DataStoreImpl.java:142)
 ... 104 more}}

The table indeed does not exist in ambari database. From grepping around in code, it looks like it might be related to the hue to ambari migration code. Only reference seems to be in https://github.com/apache/ambari/blob/release-2.5.1/contrib/views/hueambarimigration/src/main/java/org/apache/ambari/view/huetoambarimigration/datasource/queryset/ambariqueryset/hive/savedqueryset/MysqlQuerySetAmbariDB.java#L49.

This was a clean install of Ambari Server 2.5.1 running HDP 2.6.1.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)