ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Magda <dma...@apache.org>
Subject Re: updating key object field using ignite sql query
Date Thu, 31 Aug 2017 00:54:21 GMT
Hi,

Ignite prevents you to update the key or its field. Look for "Inability to modify a key or
its fields with an UPDATE query” callout at the bottom of this section to find a reasoning
behind this: 
https://apacheignite.readme.io/docs/dml#section-update <https://apacheignite.readme.io/docs/dml#section-update>

As a side note, even if this was allowed, instead of “_key.id” you should have used just
“id”.


—
Denis

> On Aug 30, 2017, at 12:31 AM, kotamrajuyashasvi <kotamrajuyashasvi@gmail.com> wrote:
> 
> Hi
> 
> In my ignite application I am using a cache with an object/POJO as a cache
> key. Now how to update the key fields of cache key using ignite sql queries.
> When I try to update I am getting 'Failed to parse query' error.
> 
> 
> For example my cache stores value in person [fields: id,name,phno] and key
> in personpk [fields:id,phno] POJO classes respectively. Now if I execute the
> query "update person set _key.id = 1 where id=2" I am getting error. I have
> added @QuerySqlField annotations for all fields in person and personpk POJO
> classes.
> 
> 
> 
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/


Mime
View raw message