CREATE TABLE ods_bu_seller_medical_warehouse_d_i(
dtc VARCHAR(32) NOT NULL,
warehouse_type VARCHAR(10) NOT NULL,
create_time DATETIME NOT NULL,
id VARCHAR(32) NOT NULL,
uscid VARCHAR(32),
seller_user_id BIGINT DEFAULT NULL,
drug_name VARCHAR(255),
supervise_uscid VARCHAR(32),
synced int
)
PRIMARY KEY (dtc, warehouse_type, create_time)
DISTRIBUTED BY HASH (dtc)
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “LZ4”
) COMMENT = ‘药品管理记录表(明细模型)’;
CREATE TABLE dwd_bu_seller_medical_warehouse_updated_d_i (
dtc VARCHAR(32) NOT NULL COMMENT ‘药品追溯码’ ,
warehouse_type VARCHAR(10) NOT NULL COMMENT ‘仓库状态（入库、领用、销售）’ ,
create_time DATETIME NOT NULL COMMENT ‘创建时间，从业务系统同步’,
drug_name varchar(255) NOT NULL COMMENT ‘药品名称’,
uscid VARCHAR(32) NOT NULL COMMENT ‘销售医药机构统一社会信用代码’,
supervise_uscid VARCHAR(32) NOT NULL COMMENT ‘上级监管机构uscid’,
seller_user_id bigint NOT NULL COMMENT ‘医药机构扫码人主键id，从业务系统同步’
)
PRIMARY KEY (dtc)
DISTRIBUTED BY HASH (dtc)
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “LZ4”
) COMMENT = ‘药品扫码数据表’;
INSERT INTO dwd_bu_seller_medical_warehouse_updated_d_i (
dtc,
warehouse_type,
create_time,
drug_name,
uscid,
supervise_uscid,
seller_user_id
)
SELECT
dtc,
warehouse_type,
create_time,
drug_name,
uscid,
supervise_uscid,
seller_user_id
FROM ods_bu_seller_medical_warehouse_d_i
ON DUPLICATE KEY UPDATE
warehouse_type = VALUES(warehouse_type),
create_time = VALUES(create_time),
drug_name = VALUES(drug_name),
uscid = VALUES(uscid),
supervise_uscid = VALUES(supervise_uscid),
seller_user_id = VALUES(seller_user_id);
这样写不支持么，会有报错
Query 1 ERROR at Line 1: : Getting syntax error at line 19, column 0. Detail message: Unexpected input ‘ON’, the most similar input is {, ‘;’}.
