starrocks
starrocks copied to clipboard
[Bug]Json array element can not insert into array column
Steps to reproduce the behavior (Required)
CREATE TABLE `test_array` (
`id` int(11) NULL COMMENT "",
`a` ARRAY<varchar(65533)> NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false"
);
- insert into test_array select 2, jsonObject -> '$.categoryMaterial' from test_json limit 1;
- select 2, jsonObject -> '$.categoryMaterial' from test_json limit 1;
Expected behavior (Required)
Real behavior (Required)
StarRocks version (Required)
- 2.3.0
Should be we don't support cast array json to array varchar.