Now I see the problem - you use SqlQuery, which is deprecated (obsolete)
and has some limitations.
Please use SqlFieldsQuery and list specific columns.
Alternatively, use Ignite LINQ provider [1] to perform strongly-typed SQL
queries, for example:
CommonConstruction.AsCacheQueryable()
.Join(ProjectsRole.AsCacheQueryable(), cc => cc.Uuid, pr => pr.PersonId)
...
[1] https://www.nuget.org/packages/Apache.Ignite.Linq
On Wed, May 26, 2021 at 12:19 PM JP <[email protected]> wrote:
> 1. What if you do "select * from CommonConstruction" - does it work?
>
> yes it is working with sqlquery.
>
> 2. Can you try listing specific columns instead of "*"?
> if i am using specific column then i have to go with sqlfieldsquery
> instead of using sqlquery.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
