Hello!
It should be possible to do all four using Cache API:
1. cache.put()
2. cache.invoke()
3. cache.remove()
4. cache.query(new SqlQuery())
Now 5. is problematic with cache API, since doing joins limits you to SQL,
which can't have any specific handling for your JSON.
Regards,
--
Sent
Hi Iliya,
Thanks for the reply. I will follow your suggestions.
Does cache API support full document post and Partial update?
API doc seems confusing.
In my case, a table has all normal columns(int, varchar, char, boolean,
date, timestamp) + a custom column that has JSON data.
My requirement
Hello!
Apache Ignite in SQL mode doesn't have special support for
"destructure-able" datatypes. This means you can put your JSON into VARCHAR
or BLOB and hope that performance will be sufficient.
I would recommend using Cache API instead of SQL for such use cases, where
you can collocate
Hi,
Objective: JSON handling in Apache Ignite
I am using PostgreSQL database and one table has JSONB data type so I can
add any type of key in DB.
How to handle this case in Apache Ignite.
TABLE STRUCTURE(Partial)
app_member_id character varying(64) DEFAULT NULL::character varying,