I am trying to do a simple cross join on two tables with non-collocated data (without affinity key),
This non-collocated distributed join always fails with the error message:
"java.sql.SQLException: javax.cache.CacheException: Failed to prepare distributed join query: join condition does not use index "
If I create one of the tables in replicated mode and another one in partitioned mode this Join operation works but documentation mentions that Ignite supports non-collocated joins without any condition.
And we tried with 3 tables and 1 in replicated and other 2 in partitioned then we observed that it failed.
we are running the Join operations with distributedJoins=true.
We observed that if there are N tables in Join operation then (N-1) should be in replicated mode, is our understanding right?
If our understanding is correct then to do Join operation the dimensioning of cluster increases by many folds which can't be used in a production environment.
Ignite with 4 node cluster with native persistence enabled.
create the following tables
Query to be run:
select * from City c, Person p;
SELECT * FROM City AS c CROSS join Person AS p;