Re: add data to table, sql add ,cache add has different result ,I use ignite 2.6

Hello! As already mentioned, those must be key fields, not value fields. Regards, -- Ilya Kasnacheev вт, 9 июл. 2019 г. в 14:23, okni-67 : > @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 >

Re: add data to table, sql add ,cache add has different result ,I use ignite 2.6

@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 写道： > > Hello! > > I think you should not be using AffinityKey type here but rather your own > custom type

Re: add data to table, sql add ,cache add has different result ,I use ignite 2.6

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

Re: add data to table, sql add ,cache add has different result ,I use ignite 2.6

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