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] [Commented] (AMBARI-21422) Missing database table when using Hive 2.0 View
Date Thu, 06 Jul 2017 22:56:00 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-21422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16077311#comment-16077311
] 

Chien Le commented on AMBARI-21422:
-----------------------------------

Url: http://<ambari_server>/#/main/view/HIVE/auto_hive20_instance

> 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
>         Attachments: ambari-server-hive-2-view-error.txt
>
>
> 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