Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
tianqiwang
Contributor
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.

1 Reply
Hemanth458
Contributor III
Contributor III

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