Ignite 2.0 issue with Tableau live ODBC connection

classic Classic list List threaded Threaded
5 messages Options
pingzing pingzing
Reply | Threaded
Open this post in threaded view
|

Ignite 2.0 issue with Tableau live ODBC connection

This post has NOT been accepted by the mailing list yet.
Anyone having issue with Tableau live connection.
Got error when refresh data:

Caused by: org.h2.jdbc.JdbcSQLException: Column "__Z0.ID" must be in the GROUP BY list; SQL statement:
SELECT
__Z0.ID AS __C0_0,
1 AS __C0_1
FROM "Cache".XYZ__Z0
GROUP BY 1 [90016-195]
Igor Sapego Igor Sapego
Reply | Threaded
Open this post in threaded view
|

Re: Ignite 2.0 issue with Tableau live ODBC connection

Hi,

First of all, Please properly subscribe to the mailing list so that the community
can receive email notifications for your messages. To subscribe, send empty
email to user-subscribe@ignite.apache.org and follow simple instructions in
the reply.

Query looks weird. What kind of data are you trying to fetch?

Best Regards,
Igor
pingzing pingzing
Reply | Threaded
Open this post in threaded view
|

Re: Ignite 2.0 issue with Tableau live ODBC connection

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

Igor Sapego Igor Sapego
Reply | Threaded
Open this post in threaded view
|

Re: Ignite 2.0 issue with Tableau live ODBC connection

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 <[hidden email]> 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.

pingzing pingzing
Reply | Threaded
Open this post in threaded view
|

Re: Ignite 2.0 issue with Tableau live ODBC connection


Tableau report has "DISTINCT COUNT" field which doesn't work well with ignite. After I removed it, live refresh is OK.