FlinkSQL写入Starrocks为bitmap字段

CREATE TABLE test.score_board_bitmap5(
    id int(11) NOT NULL COMMENT "",
    name varchar(65533) NULL DEFAULT "" COMMENT "",
    `visit_date` datetime NOT NULL COMMENT 'access time',
    passenge bitmap BITMAP_UNION NOT NULL COMMENT ""
)
ENGINE=OLAP
AGGREGATE KEY(id, name, visit_date)
DISTRIBUTED BY HASH(id)
PROPERTIES(
 "replication_num" = "1"
 );

CREATE TABLE score_board16 (
    id INT,
    name STRING,
    passenge_id BIGINT,
    `visit_date` TIMESTAMP
) WITH (
    'connector' = 'starrocks',
    'jdbc-url' = 'jdbc:mysql://127.0.0.1:9030',
    'load-url' = '127.0.0.1:7030',
    'database-name' = 'test',
    'table-name' = 'score_board_bitmap5',
    'username' = 'root',
    'password' = '',
    'sink.properties.columns' = 'id,name,passenge_id,passenge=to_bitmap(passenge_id),visit_date'
); 

INSERT INTO `score_board16` VALUES (7, 'starrocks-update',3,CAST('2020-06-23 01:30:30' AS TIMESTAMP)), (2, 'flink-update',3,CAST('2020-06-23 01:30:30' AS TIMESTAMP));

CREATE TABLE test.score_board_bitmap6(
    id int(11) NOT NULL COMMENT "",
    name varchar(65533) NULL DEFAULT "" COMMENT "",
    visit_date datetime NOT NULL COMMENT 'access time',
    passenge bitmap BITMAP_UNION NOT NULL COMMENT "",
    driver bitmap BITMAP_UNION NOT NULL COMMENT "",
    answer_cnt bigint(20) SUM NULL COMMENT ""
)
ENGINE=OLAP
AGGREGATE KEY(id, name, visit_date)
DISTRIBUTED BY HASH(id)
PROPERTIES(
 "replication_num" = "1"
 );

CREATE TABLE score_board17 (
    id INT,
    name STRING,
    visit_date TIMESTAMP,
    passenge_id BIGINT,
    driver_id BIGINT,
    answer_cnt INT
) WITH (
    'connector' = 'starrocks',
    'jdbc-url' = 'jdbc:mysql://127.0.0.1:9030',
    'load-url' = '127.0.0.1:7030',
    'database-name' = 'test',
    'table-name' = 'score_board_bitmap6',
    'username' = 'root',
    'password' = '',
    'sink.properties.columns' = 'id,name,visit_date,passenge_id,passenge=to_bitmap(passenge_id),driver_id,driver=to_bitmap(driver_id),answer_cnt'
); 

INSERT INTO `score_board17` VALUES (7, 'starrocks-update',CAST('2020-06-23 01:30:30' AS TIMESTAMP),8,9,10), (2, 'flink-update',CAST('2020-06-23 01:30:30' AS TIMESTAMP),3,4,5);