Data is very simple, POJO with a couple of QueryField of String/Double.
Initial load to tableau is fine. Using Tableau extract also works.
Refreshing live connection gave below exception from ignite node:
Caused by: org.h2.jdbc.JdbcSQLException: Column "TESTDATA__Z0.ID" must be in
the GROUP BY list; SQL statement:
SELECT
TESTDATA__Z0.ID AS __C0_0,
1 AS __C0_1
FROM "myCache".TESTDATA TESTDATA__Z0
GROUP BY 1 [90016-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.expression.ExpressionColumn.updateAggregate(ExpressionColumn.java:169)
at org.h2.expression.Alias.updateAggregate(Alias.java:87)
at org.h2.command.dml.Select.queryGroup(Select.java:339)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:620)
at
org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:113)
at org.h2.command.Command.executeQuery(Command.java:201)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1219)
... 14 more
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Ignite-2-0-issue-with-Tableau-live-ODBC-connection-tp12986p13011.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
