Hello! If you had any images in your email, we are not seeing them. Please provide links.
Regards, -- Ilya Kasnacheev сб, 24 апр. 2021 г. в 03:24, William.L <wil...@gmail.com>: > Hi, > > I am trying to understand why my colocated join between two tables/caches > are taking so long compare to the individual table filters. > > ----TABLE1 > > Returns 10000 count -- 0.13s > > ----TABLE2 > > Returns 65000 count -- 0.643s > > > ---- JOIN TABLE1 and TABLE2 > > Returns 650K count -- 7s > > Both analysis_input and analysis_output has index on (cohort_id, user_id, > timestamp). The affinity key is user_id. How do I analyze the performance > further? > > Here's the explain which does not tell me much: > > > > Is Ignite doing the join and filtering at each data node and then sending > the 650K total rows to the reduce before aggregation? If so, is it possible > for Ignite to do the some aggregation at the data node first and then send > the first level aggregation results to the reducer? > > > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
