ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Simon Heeg (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-15279) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.DS_JOBIMPL_4' doesn't exist
Date Tue, 26 Sep 2017 12:17:00 GMT

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

Simon Heeg commented on AMBARI-15279:
-------------------------------------

What I did to come up with the ddl statement was to look in the log, there you will find the
"INSERT INTO ...." dml that contains a list of all the columns your table needs. Now you only
have to match the column names with other ddl statements that solve similar issues. This allows
you to extract the datatype (which is 99% "TEXT") .




> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.DS_JOBIMPL_4'
doesn't exist
> ----------------------------------------------------------------------------------------------------
>
>                 Key: AMBARI-15279
>                 URL: https://issues.apache.org/jira/browse/AMBARI-15279
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server, ambari-views
>    Affects Versions: 2.2.0
>            Reporter: DIPAYAN BHOWMICK
>            Assignee: DIPAYAN BHOWMICK
>             Fix For: 2.2.2
>
>         Attachments: AMBARI-15279.patch
>
>
> *PROBLEM:*
> Trying to run a query from Ambari Hive View generates "S020 Data storage error" in Ambari
server log
> And the end of the stack trace is:
> {noformat}
> ...
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.DS_JOBIMPL_4'
doesn't exist 
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) 
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) 
> at com.mysql.jdbc.Util.getInstance(Util.java:386) 
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) 
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) 
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) 
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) 
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) 
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834) 
> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) 
> at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313) 
> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1007)

> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:642)

> ... 115 more
> {noformat}



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

Mime
View raw message