You need to fully qualify your join table and put it in quotes:
"select * from Test1Model as t1, \"Test2Model\".Test2Model t2 where t1.Code
= t2.Code WHERE t1.CountryCode=?"
We generally recommend putting your cache names in upper case to avoid this
issue.
On Tue, 10 Dec 2024 at 09:38, Charlin S <charli...@hotelhub.com> wrote:
> Hi
> var cacheCfgTest1Model = new CacheConfiguration("Test1Model", new
> QueryEntity(typeof(test1Model)));
> var cacheCfgTest2Model = new CacheConfiguration("Test2Model", new
> QueryEntity(typeof(Test2Model)));
> Test1Icache=_ignite.GetOrCreateCache<string, Test1Model>(
> cacheCfgTest1Model);
> Test2Icache=_ignite.GetOrCreateCache<string, Test2Model>(
> cacheCfgTest2Model);
>
> var qry = Test1Icache.Query(new SqlFieldsQuery("select * from Test1Model
> as t1, Test2Model t2 where t1.Code = t2.Code WHERE t1.CountryCode='IND'"
> )).GetAll();
>
> error while executing above line (Test1Icache.Query): *Test2Model* table
> not found
>
> Thanks
> Charlin
>
>
>
> On Tue, 10 Dec 2024 at 14:53, Stephen Darlington <sdarling...@apache.org>
> wrote:
>
>> Please share the code you use to create the cache and the code where
>> you're getting "unknown cache" errors. As a general rule, we can't guess
>> what's happening. We need to see logs and/or code.
>>
>> On Tue, 10 Dec 2024 at 07:06, Ilya Shishkov <shishkovi...@gmail.com>
>> wrote:
>>
>>> > table not found error
>>>
>>> When do you obtain this error?
>>>
>>> > I have created cache through cache api
>>>
>>> Have you specified query entities in the cache?
>>>
>>> пн, 9 дек. 2024 г. в 18:14, Charlin S <charli...@hotelhub.com>:
>>> >
>>> > Hi
>>> > I have created cache through cache api
>>> >
>>> > Thank you
>>> > Charlin
>>> >
>>> > On Mon, 9 Dec, 2024, 8:18 pm Ilya Shishkov, <shishkovi...@gmail.com>
>>> wrote:
>>> >>
>>> >> Hi Charlin,
>>> >>
>>> >> Did you create the tables via DDL or Cache API?
>>> >>
>>> >> пн, 9 дек. 2024 г. в 14:21, Charlin S <charli...@hotelhub.com>:
>>> >> >
>>> >> > Hi All,
>>> >> > I am facing one problem with Ignite 2.16, which was not there in
>>> 2.10(my old Ignite version).
>>> >> > Two cluster nodes(Linux server).,
>>> >> > 1 client node C# application hosted on Windows machine for pushing
>>> data to cache and 1 more client node for C# application which is reading
>>> data from Ignite cache and this service having table not found error for
>>> some cache cache model but cache model exists in grid.
>>> >> >
>>> >> > Thanks & Regards,
>>> >> > Charlin
>>> >> >
>>> >> >
>>> >> >
>>>
>>
