Hazelcast SQL IMap + IMap JOIN

Örnek

Şöyle yaparız. Burada iki tane IMap join'leniyor

CREATE MAPPING client 
TYPE IMap 
OPTIONS (
  'keyFormat' = 'java', 
  'keyJavaClass' = 'java.lang.Long', 
  'valueFormat' = 'java', 
  'valueJavaClass' = 'com.foo.Client' 
)

CREATE MAPPING client2system 
TYPE IMap 
OPTIONS (
  'keyFormat' = 'java', 
  'keyJavaClass' = 'java.lang.Long', 
  'valueFormat' = 'java', 
  'valueJavaClass' = 'com.foo.Client2System' 
)

SELECT c.clientKey 
FROM client c 
JOIN client2system c2s on c2s.clientId = c.clientId
WHERE c2s.systemId = ? 
AND c2s.clientCode = ?