update语句
update
log_theme.log_interface_access_num
set
log_theme.log_interface_access_num.interface_name = log_theme.dim_interface.interface_name
from
log_theme.dim_interface
where
log_theme.log_interface_access_num.interface_id = log_theme.dim_interface.interface_id
and log_theme.log_interface_access_num.interface_name <> log_theme.dim_interface.interface_name;
建表语句
CREATE TABLE log_interface_access_num (
log_day int NULL COMMENT '天',
interface_id varchar(50) NULL COMMENT '服务标识',
access_user_id varchar(50) NULL COMMENT '访问用户',
access_org_id varchar(50) NULL COMMENT '访问用户所属机构',
access_id varchar(50) NULL COMMENT '访问ip',
access_status int NULL COMMENT '状态',
interface_name varchar(400) NULL COMMENT '服务名称',
time_consumption bigint NULL COMMENT '耗时(秒)',
log_year int NULL COMMENT '年',
log_month int NULL COMMENT '月',
access_num int NULL COMMENT '访问数'
) ENGINE=OLAP
UNIQUE KEY(log_day, interface_id, access_user_id, access_org_id, access_id, access_status)
COMMENT '数据服务访问日志'
DISTRIBUTED BY HASH(log_day) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728",
"enable_mow_light_delete" = "false"
);
报错信息SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = column in assignment list is invalid, log_theme.log_interface_access_num.interface_name
在doris 2.1.x版本执行没问题，但是升级到3.0.1之后都不行
