Turns out we can't create multiple tables per cache with SQL DDL, this is a design limitation. The error message is misleading, I'll file a ticket to fix it.
So again, I would advise to use one table per cache approach. To reduce the overhead of creating 1000s of caches, you can leverage Cache Groups feature: https://apacheignite.readme.io/docs/cache-groups So instead of one cache per company, use one cache group per company. Does this work for you? On Wed, Sep 25, 2019 at 10:42 AM Pavel Tupitsyn <[email protected]> wrote: > Yes, you are correct, now I see the problem too. Let me investigate it a > bit and get back to you. > > On Wed, Sep 25, 2019 at 10:37 AM siva <[email protected]> wrote: > >> Hi Pavel, >> ' >> >> actually Lecturer table not exists since the cache created with Student >> query entity only ,if we try to create another table (lets say >> HODepartment) >> with already created cache also same exception is throwing . >> >> >> >> >> Thanks >> siva >> >> >> >> -- >> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >> >
