Re: Apache Ignite Rest API JOIN with multiple Caches

Hi, Try to use qryfldexe: For example, I create next caches: ss1.java It creates two caches with the same structure. Now I am going to execute next command: SELECT * FROM "mycache1".Value V1 join "mycache2".Value V2 on

Re: Apache Ignite Rest API JOIN with multiple Caches

The above solution works fine with Ignite JDBC and however I am trying with Ignite REST API. http://localhost:8080/ignite?cmd=qryfldexe=100=CustomerCache=select+id+from+Customer c+join+ AccountCache.account a+on+where+c.id=a.id I am getting "error": "Schema \"ACCOUNTCACHE\" not found; SQL

Re: Apache Ignite Rest API JOIN with multiple Caches

Hi, Question was answered in https://stackoverflow.com/questions/50950480/join-on-apache-ignite-rest-api/50950777#50950777. BR, Andrei -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Apache Ignite Rest API JOIN with multiple Caches

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