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] > <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>
