CREATE TABLE `test1_remote` (

  `id` int(11) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=INNODB;

CREATE TABLE `test1_local` (

  `id` int(11) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=SPIDER DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED COMMENT='host "127.0.0.1",user "spider", password "spider", table "test1_remote"'

 PARTITION BY LIST  COLUMNS(`id`)

(PARTITION `p1` VALUES IN (1) ENGINE = SPIDER,

 PARTITION `p2` VALUES IN (2) ENGINE = SPIDER,

 PARTITION `p3` VALUES IN (3) ENGINE = SPIDER,

 PARTITION `p4` VALUES IN (4) ENGINE = SPIDER);

insert into test1_local values (2);

select * from test1_local;

+------------+

| id |

+------------+

|          2 |

|          2 |

|          2 |

|          2 |

+------------+

4 rows in set (0.001 sec)