Clickhouse
Isay_me
天道酬勤
展开
-
clickhouse 报 Code: 43, e.displayText() = DB::Exception: Illegal types Decimal(20, 4) and Float64
今天周末,比昨天多睡了一个多小时。步入正题:selectcase when x.fnl_price is null then a.RTL_MKT_VAL * 0.35 else a.RTL_MKT_VAL * x.fnl_price end as AGENT_COSTfrom ck a left join bala x on a.id =x.id----注:此处的 x.fnl_price 是decimal 类型 此处的a.RTL_MKT_VAL...原创 2020-12-06 13:16:59 · 8856 阅读 · 0 评论 -
click house Code: 47, e.displayText() = DB::Exception: Missing columns:
周六,早十点起床,毕竟劳动了一周了,偶尔偷个小懒!步入正题!----注---/*这只是我随便写的表名,大概意思往下看*/--------select case when b.val is null then a.val when b.val <= 0 then a.val else a.val / a.qty end as RTL_VAL from 表1 a left join 表2 b on a.id = b.id原创 2020-12-05 19:03:03 · 12069 阅读 · 4 评论