This is OK, you don't need to do anything, Tableau just tries some queries on connection, that Ignite does not support. It won't preserve you from working with Tableau.
Best Regards, Igor On Tue, May 29, 2018 at 8:14 PM, manuelmourato <[email protected]> wrote: > I am trying to connect Tableau to my Ignite (version 2.2) cache in a > different host. > > I have followed the steps mentioned here > https://apacheignite-sql.readme.io/docs/tableau , and everything worked > well. > > However, when I try to connect to the Apache Ignite Driver, as described in > this section: > https://apacheignite-sql.readme.io/docs/tableau# > section-connecting-to-cluster > , I get the following error on the Ignite cluster logs: > > ------------------------------------------------------------ > ------------------------------------------------------- > > 01_E355260B_0EAB_4918_80CD_DD45C322815F_1_Connect ( > COL INTEGER > ) ON COMMIT PRESERVE ROWS, args=[]]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: > Failed > to parse query: CREATE LOCAL TEMPORARY TABLE > XT01_E355260B_0EAB_4918_80CD_DD45C322815F_1_Connect ( > COL INTEGER > ) ON COMMIT PRESERVE ROWS > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing. > queryDistributedSqlFields(IgniteH2Indexing.java:1293) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx( > GridQueryProcessor.java:1856) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx( > GridQueryProcessor.java:1852) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX. > apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor. > executeQuery(GridQueryProcessor.java:2293) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor. > querySqlFieldsNoCache(GridQueryProcessor.java:1860) > at > org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler. > executeQuery(OdbcRequestHandler.java:192) > at > org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.handle( > OdbcRequestHandler.java:126) > at > org.apache.ignite.internal.processors.odbc.SqlListenerNioListener. > onMessage(SqlListenerNioListener.java:152) > at > org.apache.ignite.internal.processors.odbc.SqlListenerNioListener. > onMessage(SqlListenerNioListener.java:44) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$ > TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter. > proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3. > body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1. > run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement > "CREATE LOCAL TEMPORARY TABLE > XT01_E355260B_0EAB_4918_80CD_DD45C322815F_1_CONNECT ( > COL INTEGER > ) ON COMMIT PRESERVE[*] ROWS "; SQL statement: > CREATE LOCAL TEMPORARY TABLE > XT01_E355260B_0EAB_4918_80CD_DD45C322815F_1_Connect ( > COL INTEGER > ) ON COMMIT PRESERVE ROWS [42000-195] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.message.DbException.getSyntaxError(DbException.java:191) > at org.h2.command.Parser.getSyntaxError(Parser.java:533) > at org.h2.command.Parser.prepareCommand(Parser.java:260) > at org.h2.engine.Session.prepareLocal(Session.java:573) > at org.h2.engine.Session.prepareCommand(Session.java:514) > at > org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204) > at > org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73) > at > org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing. > prepareStatement(IgniteH2Indexing.java:398) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing. > queryDistributedSqlFields(IgniteH2Indexing.java:1273) > ... 17 more > [16:53:02,274][SEVERE][sql-connector-#112%ignite_node1%][ > OdbcRequestHandler] > Failed to execute SQL query [reqId=48, req=OdbcQueryExecuteRequest > [schema=Test_Data, sqlQry=DROP TABLE > XT01_E355260B_0EAB_4918_80CD_DD45C322815F_1_Connect, args=[]]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: DROP > TABLE can only be executed on PUBLIC schema. > at > org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor. > convert(DdlStatementsProcessor.java:277) > at > org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor. > runDdlStatement(DdlStatementsProcessor.java:221) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing. > queryDistributedSqlFields(IgniteH2Indexing.java:1331) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx( > GridQueryProcessor.java:1856) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx( > GridQueryProcessor.java:1852) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX. > apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor. > executeQuery(GridQueryProcessor.java:2293) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor. > querySqlFieldsNoCache(GridQueryProcessor.java:1860) > at > org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler. > executeQuery(OdbcRequestHandler.java:192) > at > org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.handle( > OdbcRequestHandler.java:126) > at > org.apache.ignite.internal.processors.odbc.SqlListenerNioListener. > onMessage(SqlListenerNioListener.java:152) > at > org.apache.ignite.internal.processors.odbc.SqlListenerNioListener. > onMessage(SqlListenerNioListener.java:44) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$ > TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter. > proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3. > body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1. > run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > [16:53:02,325][SEVERE][sql-connector-#104%ignite_node1%][ > OdbcRequestHandler] > Failed to execute SQL query [reqId=59, req=OdbcQueryExecuteRequest > [schema=Test_Data, sqlQry=SELECT TOP 1 * > INTO XT01_E355260B_0EAB_4918_80CD_DD45C322815F_2_Connect > FROM (SELECT 1 AS COL) AS CHECKTEMP, args=[]]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: > Failed > to parse query: SELECT TOP 1 * > INTO XT01_E355260B_0EAB_4918_80CD_DD45C322815F_2_Connect > FROM (SELECT 1 AS COL) AS CHECKTEMP > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing. > queryDistributedSqlFields(IgniteH2Indexing.java:1293) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx( > GridQueryProcessor.java:1856) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx( > GridQueryProcessor.java:1852) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX. > apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor. > executeQuery(GridQueryProcessor.java:2293) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor. > querySqlFieldsNoCache(GridQueryProcessor.java:1860) > at > org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler. > executeQuery(OdbcRequestHandler.java:192) > at > org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.handle( > OdbcRequestHandler.java:126) > at > org.apache.ignite.internal.processors.odbc.SqlListenerNioListener. > onMessage(SqlListenerNioListener.java:152) > at > org.apache.ignite.internal.processors.odbc.SqlListenerNioListener. > onMessage(SqlListenerNioListener.java:44) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$ > TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter. > proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3. > body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1. > run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement > "SELECT TOP 1 * > INTO[*] XT01_E355260B_0EAB_4918_80CD_DD45C322815F_2_CONNECT > FROM (SELECT 1 AS COL) AS CHECKTEMP "; SQL statement: > SELECT TOP 1 * > INTO XT01_E355260B_0EAB_4918_80CD_DD45C322815F_2_Connect > FROM (SELECT 1 AS COL) AS CHECKTEMP [42000-195] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.message.DbException.getSyntaxError(DbException.java:191) > at org.h2.command.Parser.getSyntaxError(Parser.java:533) > at org.h2.command.Parser.prepareCommand(Parser.java:260) > at org.h2.engine.Session.prepareLocal(Session.java:573) > at org.h2.engine.Session.prepareCommand(Session.java:514) > at > org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204) > at > org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73) > at > org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing. > prepareStatement(IgniteH2Indexing.java:398) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing. > queryDistributedSqlFields(IgniteH2Indexing.java:1273) > ... 17 more > [16:53:02,329][SEVERE][sql-connector-#105%ignite_node1%][ > OdbcRequestHandler] > Failed to execute SQL query [reqId=60, req=OdbcQueryExecuteRequest > [schema=Test_Data, sqlQry=DROP TABLE > XT01_E355260B_0EAB_4918_80CD_DD45C322815F_2_Connect, args=[]]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: DROP > TABLE can only be executed on PUBLIC schema. > at > org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor. > convert(DdlStatementsProcessor.java:277) > at > org.apache.ignite.internal.processors.query.h2.ddl.DdlStatementsProcessor. > runDdlStatement(DdlStatementsProcessor.java:221) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing. > queryDistributedSqlFields(IgniteH2Indexing.java:1331) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx( > GridQueryProcessor.java:1856) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx( > GridQueryProcessor.java:1852) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX. > apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor. > executeQuery(GridQueryProcessor.java:2293) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor. > querySqlFieldsNoCache(GridQueryProcessor.java:1860) > at > org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler. > executeQuery(OdbcRequestHandler.java:192) > at > org.apache.ignite.internal.processors.odbc.odbc.OdbcRequestHandler.handle( > OdbcRequestHandler.java:126) > at > org.apache.ignite.internal.processors.odbc.SqlListenerNioListener. > onMessage(SqlListenerNioListener.java:152) > at > org.apache.ignite.internal.processors.odbc.SqlListenerNioListener. > onMessage(SqlListenerNioListener.java:44) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$ > TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter. > proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3. > body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1. > run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > > ------------------------------------------------------------ > -------------------------------------------- > > I have created this "Test_Data" cache via Java, so I specified the schema > for the Apache Ignite DNS as being "Test_Data". > > I have also added the following to my ignite config xml > > > <property name="odbcConfiguration"> > <bean class="org.apache.ignite.configuration.OdbcConfiguration"> > <property name="endpointAddress" value="0.0.0.0:10800..10810"/> > <property name="maxOpenCursors" value="128"/> > <property name="socketSendBufferSize" value="0"/> > <property name="socketReceiveBufferSize" value="0"/> > <property name="threadPoolSize" value="4"/> > </bean> > </property> > > And it does look like Tableau can connect to Ignite, since it returned the > above error. > > What could be wrong here? If you need anymore info please ask. > > Thank you. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
