CREATE TABLE users (registertime BIGINT, userid VARCHAR PRIMARY KEY, gender VARCHAR, regionid VARCHAR) WITH (KAFKA_TOPIC = 'users', KEY_FORMAT='KAFKA', PARTITIONS=2, VALUE_FORMAT='JSON');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611069, 'User_2', 'MALE', 'Region_1');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611320, 'User_6', 'FEMALE', 'Region_7');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611396, 'User_2', 'N/A', 'Region_8');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611397, 'User_3', 'N/A', 'Region_2');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611398, 'User_4', 'N/A', 'Region_3');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611399, 'User_5', 'N/A', 'Region_4');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611400, 'User_7', 'N/A', 'Region_5');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611401, 'User_8', 'N/A', 'Region_6');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611402, 'User_9', 'N/A', 'Region_7');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611403, 'User_10', 'N/A', 'Region_8');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611500, 'User_11', 'N/A', 'Region_1');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611501, 'User_12', 'N/A', 'Region_2');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611601, 'User_13', 'N/A', 'Region_3');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611605, 'User_14', 'N/A', 'Region_4');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611800, 'User_15', 'N/A', 'Region_5');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611801, 'User_16', 'N/A', 'Region_6');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611802, 'User_17', 'N/A', 'Region_7');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611900, 'User_18', 'N/A', 'Region_8');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611901, 'User_19', 'N/A', 'Region_1');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611902, 'User_20', 'N/A', 'Region_2');
INSERT INTO users (REGISTERTIME, USERID, GENDER, REGIONID) VALUES(1541439611903, 'User_21', 'N/A', 'Region_3');