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.
