ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chien Le (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMBARI-21422) Missing database table when using Hive 2.0 View
Date Thu, 06 Jul 2017 22:46:00 GMT
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)

Mime
View raw message