Ignite does not perform as expected

[Justin Ji]

when I run a SQL query with the two indexes, but ignite does not perform as
expected, it only uses dpId does not use devId, I explain the SQL:

SELECT
    __Z0.ID AS __C0_0,
    __Z0.GMTCREATE AS __C0_1,
    __Z0.GMTMODIFIED AS __C0_2,
    __Z0.DEVID AS __C0_3,
    __Z0.DPID AS __C0_4,
    __Z0.CODE AS __C0_5,
    __Z0.NAME AS __C0_6,
    __Z0.CUSTOMNAME AS __C0_7,
    __Z0.MODE AS __C0_8,
    __Z0.TYPE AS __C0_9,
    __Z0.VALUE AS __C0_10,
    __Z0.RAWVALUE AS __C0_11,
    __Z0.TIME AS __C0_12,
    __Z0.STATUS AS __C0_13,
    __Z0.UUID AS __C0_14
FROM "data_point".T_DATA_POINT __Z0
    /* "data_point".IDX_DPID: DPID = 1 */
WHERE (__Z0.DEVID = '00200008005459000a70')
    AND (__Z0.DPID = 1)

When I only use devId as query condition:
SELECT
    __Z0.ID AS __C0_0,
    __Z0.GMTCREATE AS __C0_1,
    __Z0.GMTMODIFIED AS __C0_2,
    __Z0.DEVID AS __C0_3,
    __Z0.DPID AS __C0_4,
    __Z0.CODE AS __C0_5,
    __Z0.NAME AS __C0_6,
    __Z0.CUSTOMNAME AS __C0_7,
    __Z0.MODE AS __C0_8,
    __Z0.TYPE AS __C0_9,
    __Z0.VALUE AS __C0_10,
    __Z0.RAWVALUE AS __C0_11,
    __Z0.TIME AS __C0_12,
    __Z0.STATUS AS __C0_13,
    __Z0.UUID AS __C0_14
FROM "data_point".T_DATA_POINT __Z0
    /* "data_point".IDX_DEVID: DEVID = '00200008005459000a70' */
WHERE __Z0.DEVID = '00200008005459000a70'

It is very strange, so can anyone tell me how to use devId and dpId as query
index?




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/