Connector reply error using Direct Query when querying from Apache Ignite DSN

Anonymous — Wed, 01 Nov 2017 08:05:08 GMT

The following is the code in the data load editor:

aaaaa:

DIRECT QUERY

DIMENSION

DAY

MEASURE

bbb

FROM aaaaa

WHERE ccc = '123456';

The following is the log of data load progress:

Started loading data

Connecting to Apache Ignite DSN Connected aaaaa << XXXXXXXX Lines fetched: 0 "aaaaa".DAY

The following error occurred:

Connector reply error: SQL##f - SqlState: HY000, ErrorCode: 0, ErrorMsg: class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query: SELECT DISTINCT DAY FROM "aaaaa" WHERE "ccc" = '123456'

The error occurred here:

Data has not been loaded. Please correct the error and try loading again.

First question: what the error mean?

Second question: why DISTINCT automatically added? Any way to avoid this?

Thanks.

Re: Connector reply error using Direct Query when querying from Apache Ignite DSN

Hemanth458 — Wed, 20 May 2020 12:53:46 GMT

Can you plz share document how you have establish connectivity b/w Qliksense and Apache Ignite

topic Connector reply error using Direct Query when querying from Apache Ignite DSN in QlikView

Connector reply error using Direct Query when querying from Apache Ignite DSN

Re: Connector reply error using Direct Query when querying from Apache Ignite DSN