You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by siva <si...@bizruntime.com> on 2021/01/22 05:09:46 UTC
Column not found using _val and sqlfieldsquery
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/
Re: Column not found using _val and sqlfieldsquery
Posted by Pavel Tupitsyn <pt...@apache.org>.
> is there any specific reason why does not working if i use like this
t._val.EntityId
I think the reason here is that SQL (the standardized language) does not
support this kind of syntax.
Think of it as a flat table, _key and _val are just additional columns.
On Fri, Jan 22, 2021 at 9:04 AM siva <si...@bizruntime.com> wrote:
> Hi ptupitsyn,
>
> yes it is working fine.
>
> I have one query
> is there any specific reason why does not working if i use like this
> t._val.EntityId
>
> SELECT t._val from (select _val FROM materials ) as t where
> t_val.EntityId='123'
>
> Thanks.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
Re: Column not found using _val and sqlfieldsquery
Posted by siva <si...@bizruntime.com>.
Hi ptupitsyn,
yes it is working fine.
I have one query
is there any specific reason why does not working if i use like this
t._val.EntityId
SELECT t._val from (select _val FROM materials ) as t where
t_val.EntityId='123'
Thanks.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: Column not found using _val and sqlfieldsquery
Posted by Pavel Tupitsyn <pt...@apache.org>.
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 <si...@bizruntime.com> 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/
>