Create Same Table Name for Different caches Using SQl Api

[siva]

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/