[
https://issues.apache.org/jira/browse/AMBARI-21422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16077308#comment-16077308
]
Chien Le commented on AMBARI-21422:
-----------------------------------
When trying to use the older Hive View, I just get a generic "S020 Data storage
error".
> 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)
