You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by manuelmourato <ma...@gmail.com> on 2018/05/29 17:14:11 UTC
Failed to connect Apache Ignite cache to Tableau
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/
Re: Failed to connect Apache Ignite cache to Tableau
Posted by Igor Sapego <is...@apache.org>.
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 <ma...@gmail.com>
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/
>