Hi , *And for question 2, I think, yes, from my learning, SQL Create Table always create another cache with default naming like SQL_PUBLIC_ . But according to manual, you can override the name by supplying options after "with".*
But For execute a query we should have Ignitecache object which is from cacheconfiguration,so that in cache confiuration we should mention *cacheName * IgniteCache cache = ignite.getOrCreateCache(new CacheConfiguration<>().setSqlSchema("PUBLIC").setName(cacheName)); so if i give same cacheName in cache configuration and in "With" Cluse ,getting exception like same cache alredy created . Where i was missed? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/