Hello! As already mentioned, those must be key fields, not value fields.
Regards, -- Ilya Kasnacheev вт, 9 июл. 2019 г. в 14:23, okni-67 <[email protected]>: > @ilya.kasnacheev > The id=6 and id=5 use cache insert , you can see the id and cityId also > have value blow，but in the dbeaver the value can’t see > > > 在 2019年7月9日，下午6:17，Ilya Kasnacheev <[email protected]>写道： > > > Hello! > > I think you should not be using AffinityKey type here but rather your own > custom type (similar with value) and name its fields "id" and "city_id". > > I don't think you can change names of fields when using AffinityKey. > > Regards, > -- > Ilya Kasnacheev > > > вт, 9 июл. 2019 г. в 07:09, okni-67 <[email protected]>: > >> >> City_id is defined in the key, key never show in the value? How can I >> use sql insert ,insert the key like cache , and how can I use cache insert, >> insert the value like sql ,I want insert use cache or use sql keep the same >> . Can you give me a solution? >> >> 在 2019年7月9日，上午11:46，Andrey Dolmatov <[email protected]> 写道： >> >> Cityid should be part of key builder, not value builder. That's because >> cityid defined in the key >> >> On Tue, Jul 9, 2019, 4:56 AM okni-67 <[email protected]> wrote: >> >>> >>> i created a table below >>> >>> *CREATE* *TABLE* *IF* *NOT* *EXISTS* person ( >>> id *int*, >>> city_id *int*, >>> name *varchar*, >>> age *int*, >>> company *varchar*, >>> *PRIMARY* *KEY* (id, city_id) >>> ) *WITH* >>> "ATOMICITY=ATOMIC,WRITE_SYNCHRONIZATION_MODE=PRIMARY_SYNC,cache_name=PersonCache,template=partitioned,backups=1,affinity_key=city_id, >>> key_type=org.apache.ignite.cache.affinity.AffinityKey, >>> value_type=com.okni.okkong.data.common.entity.Person”; >>> >>> And I use sql below >>> >>> *INSERT* *INTO* person *values*(2,5,'test1',19,'okni’) >>> >>> I can find data like below >>> >>> And. I use ignite cache put binary object like below >>> >>> >>> This problem is in DBeaver my new data id and city_id is null. >>> >>> >>> I use cache can get the cache insert id and city id value, but the sql >>> insert operate data the id is null, like below >>> >>> I want to know why , thanks. >>> >>> >>> >>> <PastedGraphic-1.png><PastedGraphic-1.png><PastedGraphic-1.png> >> <PastedGraphic-1.png> >> >> >> >
