CREATE TABLE `example_array_string` (
  `type` int(11) NOT NULL COMMENT "日志类型",
  `tags` ARRAY<varchar(65533)> NULL COMMENT "",
  tag_string string
) ENGINE=OLAP 
DUPLICATE KEY(`type`)
DISTRIBUTED BY HASH(`type`) BUCKETS 10 
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false",
"compression" = "LZ4"
);

INSERT INTO example_array_string VALUES (2, ['Tag 3', 'Tag 4'], '["element1", "element2", "element3"]');

array转为string:

select array_join(tags,',') from example_array_string;

string转为array:

SELECT CAST(tag_string AS ARRAY<varchar>)  from example_array_string;