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

[Anonymous]

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.

[Hemanth458]

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