0 Replies Latest reply: Nov 1, 2017 4:05 AM by Tianqi Wang RSS

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

    Tianqi Wang

      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.