doris建表语句 flink插入数据

建表sql 

CREATE TABLE `cs` (
  `int_test` int(11) NULL,
  `BOOLEAN_test` boolean NULL,
  `TINYINT_test` tinyint(4) NULL,
  `SMALLINT_test` smallint(6) NULL,
  `bigint_test` bigint(20) NULL,
  `float_test` float NULL,
  `double_test` double NULL,
  `date_test` date NULL,
  `datetime_test` datetime NULL,
  `decimal_test` DECIMAL(38, 3) NULL,
  `char_test` char(210) NULL,
  `LARGEINT_test` largeint(40) NULL,
  `varchar_test` varchar(255) NULL,
  `STRING_test` varchar(255) NULL,
  `DECIMALV2_test` DECIMAL(18, 3) NULL,
  `ARRAY_test` array<int(11)> NULL,
  `MAP_test` MAP<int(11),int(11)> NULL,
  `JSON_test` json NULL
) ENGINE=OLAP
UNIQUE KEY(`int_test`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`int_test`) BUCKETS 6
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"is_being_synced" = "false",
"storage_format" = "V2",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);

Flinksql

-- 创建CATALOG
CREATE CATALOG `FLINK_CATALOG` WITH('type' = 'generic_in_memory');
-- 创建DATABASE
CREATE DATABASE IF NOT EXISTS `FLINK_CATALOG`.`FLINK_DATABASE`;
--   引用数据表:  [结果表]
--   type: DORIS
--   datasourceName: doris
--   tableName: cs
CREATE TABLE IF NOT EXISTS `FLINK_CATALOG`.`FLINK_DATABASE`.`d_cs16` (
  `int_test` INT,
  `BOOLEAN_test` BOOLEAN,
  `TINYINT_test` TINYINT,
  `SMALLINT_test` SMALLINT,
  `bigint_test` BIGINT,
  `float_test` FLOAT,
  `double_test` DOUBLE,
  `date_test` DATE,
  `datetime_test` TIMESTAMP,
  `decimal_test` DECIMAL(38, 3),
  `char_test` STRING,
  `LARGEINT_test` STRING,
  `varchar_test` STRING,
  `STRING_test` STRING,
  `DECIMALV2_test` DECIMAL(18, 3),
  `ARRAY_test` array < int >,
  `MAP_test` map < int,
  int >,
  `JSON_test` STRING,
  PRIMARY KEY (`int_test`) NOT ENFORCED
) WITH (
  'connector' = 'doris',
  'fenodes' = 'xxx:8030',
  'table.identifier' = 'xxx.cs',
  'sink.label-prefix' = 'xxx',
  'username' = '#{username}',
  'password' = '#{password}'
);
 INSERT INTO  `FLINK_CATALOG`.`FLINK_DATABASE`.`d_cs16` (
    `int_test`,
    `BOOLEAN_test`,
    `TINYINT_test`,
    `SMALLINT_test`,
    `bigint_test`,
    `float_test`,
    `double_test`,
    `date_test`,
    `datetime_test`,
    `decimal_test`,
    `char_test`,
    `LARGEINT_test`,
    `varchar_test`,
    `STRING_test`,
    `DECIMALV2_test`,
    `ARRAY_test`,
    `MAP_test`,
    `JSON_test`
  )
 VALUES  (
    13,
    FALSE,
    cast(1 AS TINYINT),
    cast(11 AS SMALLINT),
    456,
    123.45,
    678.90123,
    cast('2023-10-23' as DATE),
    cast('2023-10-23 14:30:00.123456' as TIMESTAMP),
    cast('12345678912345678.123' as DECIMAL(38, 3)),
    'CharacterData',
    '1234567890',
    'VarcharData',
    'StringData',
    123456789.123,
    Array [1, 2, 3],
    Map [2,-2],
    '{"key1": "value1", "key2": "value2"}'
  );