What is the query On Fri, May 3, 2019 at 5:28 PM KhajaAsmath Mohammed <mdkhajaasm...@gmail.com> wrote:
> Hi > > I have followed link > https://community.teradata.com/t5/Connectivity/Teradata-JDBC-Driver-returns-the-wrong-schema-column-nullability/m-p/77824 > to > connect teradata from spark. > > I was able to print schema if I give table name instead of sql query. > > I am getting below error if I give query(code snippet from above link). > any help is appreciated? > > Exception in thread "main" java.sql.SQLException: [Teradata Database] > [TeraJDBC 16.20.00.10] [Error 3707] [SQLState 42000] Syntax error, expected > something like an 'EXCEPT' keyword or an 'UNION' keyword or a 'MINUS' > keyword between the word 'VEHP91_BOM' and '?'. > at > com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:309) > at > com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:103) > at > com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:311) > at > com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:200) > at > com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:137) > at > com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:128) > at > com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:389) > at > com.teradata.jdbc.jdbc_4.TDStatement.prepareRequest(TDStatement.java:576) > at > com.teradata.jdbc.jdbc_4.TDPreparedStatement.<init>(TDPreparedStatement.java:131) > at > com.teradata.jdbc.jdk6.JDK6_SQL_PreparedStatement.<init>(JDK6_SQL_PreparedStatement.java:30) > at > com.teradata.jdbc.jdk6.JDK6_SQL_Connection.constructPreparedStatement(JDK6_SQL_Connection.java:82) > at com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1337) > at com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1381) > at com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1367) > > > Thanks, > Asmath >