建表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