Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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