Hi, I guess it should be like this: SELECT t._val from (select _val, EntityId FROM materials ) as t where t.EntityId='123'
On Fri, Jan 22, 2021 at 8:10 AM siva <[email protected]> wrote: > Hi, > I have .Net Ignite client and server app Ignite v2.9.1. > > I am using SqlFieldsQuery using thin client to query ignite. > > here is the query what i am trying: > > SELECT t._val from (select _val FROM materials ) as t where EntityId='123' > > exception msg: > > Failed to parse query. Column "ENTITYID" not found; SQL statement: > SELECT t._val from (select _val FROM materials ) as t where EntityId='123' > [42122-197] > > How to solve above exception.Please Any help? > > Thanks. > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
