[
https://issues.apache.org/jira/browse/AMBARI-21422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chien Le updated AMBARI-21422:
------------------------------
Description:
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.
was:
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
bq. Error Code: 1146
bq. 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 (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bq. bind => [23 parameters bound]
bq. at
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:159)
bq. at
org.apache.ambari.server.view.persistence.DataStoreImpl.store(DataStoreImpl.java:142)
bq. ... 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.
> 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)
