Hello,
I have two objects i.e account and customer loaded to apache ignite server. Both objects are loaded with data and each of them stored in its cache. Account object/table is loaded to accountcache and customer object/table is loaded to customercache. I am trying to access both the tables with join using apache ignite rest api. I am unable to use join using rest-api-.2.5.0 version. Cache Structure and table/object -------------------- CustomerCache -> customer AccountCache-> account Below Rest URL works for me. a) http://localhost:8080/ignite?cmd=qryfldexe&pageSize=1000&cacheName=CustomerCache&qry=select+id+from+customer b) http://localhost:8080/ignite?cmd=qryfldexe&pageSize=1000&cacheName=AccountCache&qry=select+id+from+account. I would like to execute join on both CustomerCache.customer and AccountCache.account. However I am unable to do so. Could you please provide join cache/table example using apache ignite rest api? I tried below http://localhost:8080/ignite?cmd=qryfldexe&pageSize=1000&cacheName=CustomerCache&AccountCache&qry=select+id+from+Customer c+join+ account a+on+where+c.id=a.id It throws an error : "error": "Table \"ACCOUNT\" not found; SQL statement:\nselect id from -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/