【详述】问题详细描述
执行update操作报错:1064 (HY000): expr’s type is not same with slot’s backend:10.20.71.255
【背景】做过哪些操作?
【业务影响】
【是否存算分离】否
【StarRocks版本】3.1.5
【联系方式】823458299@qq.com
【附件】
- 建表语句:
create table meta_task_info
(
task_id varchar(128) not null comment ‘taskid’,
project_name varchar(64) not null comment ‘项目名’,
task_date date not null comment ‘任务日期’,
task_type varchar(128) not null comment ‘task类型’,
input_path varchar(256) not null comment ‘输入路径’,
source_type varchar(128) not null comment ‘数据来源类型’,
is_done int not null comment ‘task状态’,
is_load int not null comment ‘是否导入’,
total_num bigint not null comment ‘总帧数’,
output_path varchar(1024) not null comment ‘输出路径’,
done_time datetime not null comment ‘task完成时间’,
load_time datetime not null comment ‘导入时间’,
created_time datetime not null comment ‘创建时间’,
update_time datetime not null comment ‘更新时间’,
remarks varchar(512) not null comment ‘备注’
) ENGINE = olap PRIMARY KEY (task_id)
DISTRIBUTED BY HASH (task_id)
BUCKETS 10 PROPERTIES (“compression” = “ZSTD”); - SQL
update meta_task_info set is_done=1, done_time=‘2023-11-27 11:43:58.317309’, total_num=1, output_path=‘xxxx’, update_time=‘2023-11-27 11:43:58.317309’ where task_id=‘57e1d906c167e4382b71c8c7510703ce’