Hello! CREATE TABLE can only create tables in PUBLIC schema so no, you can't create two tables with identical name. But you also don't need to, because table name is not linked to type name when using SQL.
Regards, -- Ilya Kasnacheev вт, 27 нояб. 2018 г. в 14:00, siva <[email protected]>: > Hi, > > I am using SQL API to create tables. > > while creating two tables with different cache names its throwing exception > like table already created. > > Ignite ignite = Ignition.ignite(); > IgniteCache cache = ignite.getOrCreateCache(new > > CacheConfiguration<>().setSqlSchema("PUBLIC").setName("hyderabad").setSqlEscapeAll(true)); > IgniteCache cache1 = ignite.getOrCreateCache(new > > CacheConfiguration<>().setSqlSchema("PUBLIC").setName("bangalore").setSqlEscapeAll(true)); > > cache.query(new SqlFieldsQuery("CREATE Table PersonInfo(id LONG PRIMARY > KEY)")).getAll(); > cache1.query(new SqlFieldsQuery("CREATE Table > PersonInfo(id LONG PRIMARY > KEY, volume double)")).getAll(); > > > Is it possible to create same table names for different caches?If yes where > i have missed? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
