Qlik Community

QlikView Direct Discovery

Discussion Board for collaboration related to Direct Discovery.

tianqiwang
New Contributor

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

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.

Community Browser