Was it working prior to 2.0? Guys, who's familiar with SQL engine, could you take a look?
Best Regards, Igor On Thu, May 18, 2017 at 10:04 PM, pingzing <[email protected]> wrote: > 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. >
