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/
>