Re: query on BinaryObject index and table

He Rajesh, Method CacheConfiguration.setIndexedTypes() should only be used for classes with SQL annotations. Since you operate on binary objects, you should use CacheConfiguration.setQueryEntity(), and define QueryEntity with all necessary fields. Also there is a property QueryEntity.tableName

Re: query on BinaryObject index and table

The schema can be changed with ALTER TABLE ADD COLUMN command: https://apacheignite-sql.readme.io/docs/alter-table To my knowledge this is supported for schemas that were initially configured by both DDL and QueryEntity/Annotations. — Denis

Re: query on BinaryObject index and table

Hello Rajesh! Table name can be specified in cache configuration's query entity. If not supplied, by default it is equal to value type name, e.g. BinaryObject :) Also, note that SQL tables have fixed schemas. This means you won't be able to add a random set of fields in BinaryObject and be able

Re: query on BinaryObject index and table

Hi Denis, This is my code: CacheConfiguration cacheCfg = new CacheConfiguration<>(ORG_CACHE); cacheCfg.setAtomicityMode(CacheAtomicityMode.TRANSACTIONAL); cacheCfg.setBackups(1); cacheCfg

Re: query on BinaryObject index and table

> On Jan 20, 2018, at 7:20 PM, Rajesh Kishore wrote: > > Hi, > > I have requirement that my schema is not fixed , so I have to use the > BinaryObject approach instead of fixed POJO > > I am relying on OOTB file system persistence mechanism > > My questions are: > -