Readthrough does not work with ignite SQL queries from rest apis and as only one cacheName can be passed then how to run Cross-Cache join query f?

Question

I have the use case where I will be querying ignite cache with rest apis using SQL queries. I need to sort, join etc.

I have setup the JdbcCacheStore and if I load data using cache.loadCache(null), everything works. I am able to query using rest apis.

http://host:port/ignite?cmd=qryfldexe&pageSize=10&cacheName=Person&qry=select+firstName%2C+lastName+from+Person

I don't want to load cache when ignite is started. I want it to be populated (readthrough) if cache is not present. If I use, get rest api readthrough works.

http://host:port/ignite?cmd=get&key=getKey&cacheName=partionedCache&destId=8daab5ea-af83-4d91-99b6-77ed2ca06647

But I will be querying using "Sql fields query execute"

http://apacheignite.gridgain.org/docs/rest-api#sql-fields-query-execute

When I tried querying using it http://host:port/ignite?cmd=qryfldexe&pageSize=10&cacheName=Person&qry=select+firstName%2C+lastName+from+Person, readthrough did not work. Cache did not populate.

Also, as the rest api allows to pass only one cacheName, how to run join queries?

Valentin Kulichenko · Accepted Answer · 2016-12-13 19:57:04Z

0

Read-through for queries is not supported because for read-through you need to know set of keys to load in advance, which is not possible with SQL. For SQL you need to load all required data into memory in advance.

answered Dec 13, 2016 at 19:57

Valentin Kulichenko

8,3901 gold badge19 silver badges12 bronze badges

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

2 Comments

Ivan Over a year ago

If read-through is not support SQL queries, what kind of query can use the read-through feature?

Valentin Kulichenko Over a year ago

Read-through from arbitrary store is supported for any key based operation (e.g. get()). Also note that in future versions of Ignite there will be a built-in persistent storage that will allow to execute queries against data stored on disk. But this is not released yet.

Collectives™ on Stack Overflow

Readthrough does not work with ignite SQL queries from rest apis and as only one cacheName can be passed then how to run Cross-Cache join query f?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related