Mailing-List: contact issues-help@ambari.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ambari.apache.org
Date: Tue, 26 Sep 2017 12:17:00 +0000 (UTC)
From: "Simon Heeg (JIRA)" <jira@apache.org>
To: issues@ambari.apache.org
Message-ID: <JIRA.12946429.1456989074000.203649.1506428220866@Atlassian.JIRA>
In-Reply-To: <JIRA.12946429.1456989074000@Atlassian.JIRA>
References: <JIRA.12946429.1456989074000@Atlassian.JIRA> <JIRA.12946429.1456989074578@jira-lw-us.apache.org>
Subject: [jira] [Commented] (AMBARI-15279)
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
 'ambari.DS_JOBIMPL_4' doesn't exist
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 26 Sep 2017 12:17:10 -0000


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