Implicit casting for decimal arithmetic operations only support integer/float/boolean/null,
只支持整数/浮点/boolean/null
create view dwd.dwd_view_sale_fk_data_new
(dt
)
as
select
a.dt
from (select * from dwd.dwd_metrics_payment_amount where zlock =’ ’ and zzjyfs=‘01’ ) a
我测试现在就一个日期字段创建试图可以查询,但是我关联一个表
create view dwd.dwd_view_sale_fk_data_new
(dt
)
as
select
a.dt
from (select * from dwd.dwd_metrics_payment_amount where zlock =’ ’ and zzjyfs=‘01’ ) a
left JOIN (SELECT lifnr,KTOKK FROM ods.ods_stage_lfa1_sapsr3 WHERE dt = DATE_FORMAT(current_date()-1,’%Y-%m-%d’) and KTOKK=‘Z001’) b ON a.LIFNR = b.lifnr
查询就
select 查询语句可以正常查询出数据
发现在创建视图时,查询的语句where 条件中日期不能是函数动态生成的日期 如:dt = DATE_FORMAT(current_date()-1,’%Y-%m-%d’) ,写成dt=‘2022-05-31’固定日期就可以
我测试下 可能是current_date函数的问题
是的,写成固定日期就可以