Hello, Write synchronization mode is one of the crucial settings of cache configuration and cannot be changed after a cache has been created. By default, SQL engine uses FULL_SYNC synchronization mode [1] You can choose the required mode by specifying the additional parameter as follows: CREATE TABLE IF NOT EXISTS person ( id int,orgId LONG, name VARCHAR, salary LONG ,PRIMARY KEY (id) ) WITH "TEMPLATE=PARTITIONED,backups=1, affinityKey=id, value_type=MyPerson,WRITE_SYNCHRONIZATION_MODE=PRIMARY_SYNC"
[1] https://apacheignite-sql.readme.io/docs/create-table Thanks! -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/