Hi,
Please read my comments:
1)Ignite generally doesn't support changing of the cache configuration
without re-creation of the the cache. But for SQL caches that were
created via QueryEntity or CREATE TABLE you can add and remove the
columns using ALTER TABLE commands:
https://apacheignite-sql.readme.io/docs/alter-table
https://apacheignite.readme.io/docs/cache-queries#query-configuration-using-queryentity
https://apacheignite-sql.readme.io/docs/create-table
2)First of all, you can use the following options:
https://apacheignite.readme.io/docs/3rd-party-store#section-read-through-and-write-through
Read through can load the requested keys from DB
Write through will load all the updates to DB.
In case if you require some cache invalidation or refresh then you can
create some cron job for it.
3)I guess that loadCache is the only to do it. It will filter the values
that have already existed in the cache.
https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/IgniteCache.html#loadCache-org.apache.ignite.lang.IgniteBiPredicate-java.lang.Object...-
4)You can use a different subset of integrations that can do distributed
streaming to Ignite like Spark or Kafka:
https://apacheignite-mix.readme.io/docs/getting-started
BR,
Andrei
2/12/2020 9:11 PM, nithin91 пишет:
Hi
We are doing a a POC on exploring the Ignite in memory capabilities and
building a rest api on
top of it using node express.
Currently as a part of POC, installed Ignite in UNIX and trying to load the
data from Oracle DB
to Ignite Cache using Cache JDBC Pojo Store.
Can someone help me whether the following scenarios can be handled using
Ignite as i couldn't find this in the official documentation.
1. If we want to add/drop/modify a column to the cache, can we
update the
bean file directly
when the node is running or do we need to stop the node and
then again
restart.
It would be really helpful if you can share sample code or
documentation link.
2. How to refresh the ignite cache automatically or schedule
the cache
refresh.
It would be really helpful if you can share sample code or
documentation link.
3. Is incremental refresh allowed? It would be really helpful
if you can
share sample code or
documentation link.
4. Is there any other way to load the caches fast other Cache
JDBC POJO
Store.
It would be really helpful if you can share sample code or
documentation link.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
