Re: Load cache data into another POJO with SQL

2020-02-18 Thread Ilya Kasnacheev
Hello! I'm not sure the rest of Ignite community will approve, but you can actually try to write an SQL extension function, which will serve as factory method for MyPojo. https://apacheignite-sql.readme.io/docs/custom-sql-functions This is used in conjunction with Geometry with some success. It

Re: Load cache data into another POJO with SQL

2020-02-13 Thread Evgenii Zhuravlev
Hi, You can implement your own CacheStore and transform data in it: https://apacheignite.readme.io/docs/3rd-party-store#section-custom-cachestore Best Regards, Evgenii чт, 13 февр. 2020 г. в 13:29, Denis Magda : > I doubt that this is supported. > > - > Denis > > > On Thu, Feb 13, 2020 at

Re: Load cache data into another POJO with SQL

2020-02-13 Thread Denis Magda
I doubt that this is supported. - Denis On Thu, Feb 13, 2020 at 11:32 AM Edward Chen wrote: > Hello, > > I am using Ignite SQL, wondering it is possible to load cache data into > another POJO ? just like ORM, sql like this : > > select new MyPojo(p.name, p.age) from myCacheTable as p where

Load cache data into another POJO with SQL

2020-02-13 Thread Edward Chen
Hello, I am using Ignite SQL, wondering it is possible to load cache data into another POJO ?  just like ORM, sql like this : select new MyPojo(p.name, p.age) from myCacheTable as p where p.age > 30 Thanks. Ed