[
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)
