How to create schema with thick client in apache ignite

Question

Apache Ignite doesn't support creating schema with DDL yet. So is there any way I can create a new schema in runtime? I tried to add a template cache configuration in a thick client, but schema config doesn't work.

CacheConfigration cfg = new CacheConfigration();
cfg.setName("MyTemplte*");
cfg.setSqlSchema("NEW_SCHEMA");
ignite.addCacheConfigration(cfg);

score 1 · Accepted Answer · answered Dec 14 '21 at 06:10

1

Use ignite.createCache(cfg) or ignite.getOrCreateCache(cfg) to create a new cache with the specified schema.

addCacheConfiguration only creates a template, but does not create any schemas or caches.

See https://ignite.apache.org/docs/latest/SQL/schemas for more details.

answered Dec 14 '21 at 06:10

Pavel Tupitsyn

8,393
3
22
44

Thank you Pavel! It works. – Elinkli Dec 15 '21 at 14:21
@Pavel - is it possible to see the new schema in Gridgain control center under SQL? – Justin Mathew Jul 28 '22 at 23:15

How to create schema with thick client in apache ignite

1 Answers1