Re: Optimizing Collocated Join

[joseheitor]

Try this:

SELECT 
    subQuery.coveringId, 
    COUNT(*)
FROM (
    SELECT 
        innerS2.*
    FROM 
        S2CellCovering AS innerS2
    INNER JOIN 
        EventTheta AS innerEvent
    ON innerEvent.parentS2CellId = innerS2.parentS2CellId
    AND innerEvent.s2CellId BETWEEN innerS2.minS2CellId AND
innerS2.maxS2CellId
    AND innerEvent.eventDate BETWEEN '2018-10-02' AND '2018-10-02'
    AND innerEvent.eventHour BETWEEN -1 AND -1
) AS subQuery
WHERE 
    subQuery.coveringId = 166
GROUP BY 
    subQuery.coveringId;




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