Re: Adding new fields to QueryEntity
Vova, New fields can be added dynamically - just add field A to your business object, update application logic and restart the app. No manual update of QueryEntity required. Make A field an index field with DDL in runtime if needed. A restart of the data/server nodes is avoided. I considered the approach above. Sounds feasible, right? Denis On Monday, May 22, 2017, fatality <fatih.teki...@gmail.com> wrote: > I guess that means both create index and QueryEntity change needed? > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Adding-new-fields-to-QueryEntity-tp13043p13052.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
Re: Adding new fields to QueryEntity
I guess that means both create index and QueryEntity change needed? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Adding-new-fields-to-QueryEntity-tp13043p13052.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Adding new fields to QueryEntity
Denis, I think the question not about new indexes, but about new fields. The answer is - you must change QueryEntity manually still. сб, 20 мая 2017 г. в 16:25, Denis Magda <dma...@gridgain.com>: > Hi, > > You need to use CREATE index command in runtime to achieve that: > https://apacheignite.readme.io/docs/distributed-ddl > > Denis > > > On Saturday, May 20, 2017, fatality <fatih.teki...@gmail.com> wrote: > >> Hi >> >> I am wondering if it is possible to add new fields for sql queries to >> BinaryObject caches. >> >> For example imagine I already have BinaryObjects that has fields X,Y,Z in >> my >> cache. And later I wanted to add one more field which is 'W'. Is it going >> to >> be possible to just adding this field to new BinaryObjects to do sql >> queries >> on 'W' as in below 'Step1' or do I have to do more? >> >> Imagining something like below Step1 should be enough to start querying on >> the existing cache with fields X,Y,Z so that I can make a query like >> "select >> X,W from BinaryTest where W=32" >> >> cfg.setQueryEntities(new ArrayList() {{ >>QueryEntity e = new QueryEntity(); >>e.setKeyType("java.lang.Integer"); >>e.setValueType("BinaryTest"); >>e.setFields(new LinkedHashMap<String, String>(){{ >>put("X", "java.lang.String"); >>put("Y", "java.lang.String"); >>put("Z", "java.lang.String"); >>put("W", "java.lang.String"); //Step1 >> }}); >> >> >> >> >> -- >> View this message in context: >> http://apache-ignite-users.70518.x6.nabble.com/Adding-new-fields-to-QueryEntity-tp13043.html >> Sent from the Apache Ignite Users mailing list archive at Nabble.com. >> >
Re: Adding new fields to QueryEntity
Hi, You need to use CREATE index command in runtime to achieve that: https://apacheignite.readme.io/docs/distributed-ddl Denis On Saturday, May 20, 2017, fatality <fatih.teki...@gmail.com> wrote: > Hi > > I am wondering if it is possible to add new fields for sql queries to > BinaryObject caches. > > For example imagine I already have BinaryObjects that has fields X,Y,Z in > my > cache. And later I wanted to add one more field which is 'W'. Is it going > to > be possible to just adding this field to new BinaryObjects to do sql > queries > on 'W' as in below 'Step1' or do I have to do more? > > Imagining something like below Step1 should be enough to start querying on > the existing cache with fields X,Y,Z so that I can make a query like > "select > X,W from BinaryTest where W=32" > > cfg.setQueryEntities(new ArrayList() {{ >QueryEntity e = new QueryEntity(); >e.setKeyType("java.lang.Integer"); >e.setValueType("BinaryTest"); >e.setFields(new LinkedHashMap<String, String>(){{ >put("X", "java.lang.String"); >put("Y", "java.lang.String"); >put("Z", "java.lang.String"); >put("W", "java.lang.String"); //Step1 > }}); > > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Adding-new-fields-to-QueryEntity-tp13043.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
Adding new fields to QueryEntity
Hi I am wondering if it is possible to add new fields for sql queries to BinaryObject caches. For example imagine I already have BinaryObjects that has fields X,Y,Z in my cache. And later I wanted to add one more field which is 'W'. Is it going to be possible to just adding this field to new BinaryObjects to do sql queries on 'W' as in below 'Step1' or do I have to do more? Imagining something like below Step1 should be enough to start querying on the existing cache with fields X,Y,Z so that I can make a query like "select X,W from BinaryTest where W=32" cfg.setQueryEntities(new ArrayList() {{ QueryEntity e = new QueryEntity(); e.setKeyType("java.lang.Integer"); e.setValueType("BinaryTest"); e.setFields(new LinkedHashMap<String, String>(){{ put("X", "java.lang.String"); put("Y", "java.lang.String"); put("Z", "java.lang.String"); put("W", "java.lang.String"); //Step1 }}); -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Adding-new-fields-to-QueryEntity-tp13043.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.