Hello! Bad news is that I can't say what went wrong here. Maybe people more familiar with our SQL engine will chime in.
Good news is, I have a work-around. It is obvious in your case that blood_group_info is a reference table (i.e. a small constant-size table instead of data table). I recommend switching its cache mode to REPLICATED instead of PARTITIONED and it should join correctly. Can you try that? Regards, -- Ilya Kasnacheev ср, 11 мар. 2020 г. в 13:05, DS <deepika.si...@aline-consulting.com>: > Hello Ilya, > Please find the script in the attachment. > The file also contains the query to run in comments. > > Also, > *we have enabled non-collocated joins check. * > > forDistributedJoins.sql > < > http://apache-ignite-users.70518.x6.nabble.com/file/t2210/forDistributedJoins.sql> > > > Regards > Deepika Singh > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
