@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] > <mailto:[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] >> <mailto:[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] >> <mailto:[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> >
