【详述】目前有个utc+7的数据，希望把时区字段改成utc+8写入
【背景】
CREATE ROUTINE LOAD xx on xx
COLUMNS TERMINATED BY “|”,
COLUMNS (
xx
)
PROPERTIES (
"max_error_number"="1000",
"max_batch_interval" = "30",
"desired_concurrent_number"="10",
"max_batch_rows" = "3000000",
"timezone" = "Asia/Shanghai",
"discard_unknown_fields" = "true",
"auto_fill_missing_fields" = "true",
"strict_mode" = "false",
"format" = "csv",
"json_root" = "",
"jsonpaths" = "",
"partial_update" = "false",
"strip_outer_array" = "false",
"compute_node_selector" = "routine_load",
"sink_with_broker_name" = "",
"skip_utf8_check" = "true"
)
FROM KAFKA
(
"kafka_broker_list"= "",
"kafka_topic" = "",
"property.kafka_default_offsets" = "OFFSET_END",
"property.group.id" = "",
"property.client.id" = "",
"property.timezone" = "Asia/Saigon" -- 这里改时区和 +01:00 都不行
);
【StarRocks版本】例如：2.5