Is it possible to perform SQL Query with distributed join over a local cache and a partitioned cache?

Question

I am currently using apache ignite 2.3.0 and the java api. I have a data grid with two nodes and two different caches. One is local and the other partitioned.

Lets say my local cache is on node #1.

I want to perform an SQL query (SqlFieldsQuery) with distributed join so that it returns data from local cache on node #1 and data from partitioned cache on node #2.

Is it possible? Do I need to specify the join in some particular order or activate a specific flag?

All my current tests are not returning any rows from partitioned cache that are not located on same node as local cache.

I tested the same query with distributed join over two different partitioned cache with no affinity and it was able to return data from different nodes properly. Is there a reason why this wouldn't work with local cache too?

Thanks

Have you tried setDistributedJoins(true) on SqlFieldsQuery? — alamar
– alamar, Commented Mar 1, 2018 at 14:02
Yes. IIn my examples, the distributed join flag works between two partitioned caches but not between a local and a partitioned. — ThatChrisGuy
– ThatChrisGuy, Commented Mar 1, 2018 at 15:12

Vladimir Ozerov · Accepted Answer · 2018-03-02 08:13:36Z

2

It is not possible to perform joins (both distributed an co-located) between LOCAL and PARTITIONED caches. The workaround is to use two PARTITIONED caches.

answered Mar 2, 2018 at 8:13

Vladimir Ozerov

462 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dmitriy Over a year ago

You can also run distributed joins between PARTITIONED and REPLICATED caches

Collectives™ on Stack Overflow

Is it possible to perform SQL Query with distributed join over a local cache and a partitioned cache?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related