记 doris - 开发问题与解决系列

查看load 建表语句

show create routine load for load_name;

load 任务异常查看sql

SHOW ROUTINE LOAD for load_ods_spc_location_change

ODBC 和 OLAP 在where 条件日期转字符串查询无数据问题

ods.ods_abnormal_alarm_details 是ODBC 表，查询没数据
要写成a.alarm_date= ‘2024-10-17’

select alarm_date,* 
from ods.ods_abnormal_alarm_details a 
where 1=1  
     AND cast(a.alarm_date AS varchar) = '2024-10-17' 

ods.ods_abnormal_alarm_details 是OLAP 表，查询有数据

select alarm_date,* 
from ods.ods_abnormal_alarm_details a 
where 1=1  
     AND cast(a.alarm_date AS varchar) = '2024-10-17'

不支持多表关联跨表字段聚合计算

SELECT
mat.tenant_id, mat.org_id ,
sum(case when serv.priorservresult in (0,2,4,5) and rel.match_value <= rule.match_value then 1 else NULL end) as numerator
from mat
left join serv
on serv.animal_id = mat.animal_id
and serv.servdate = mat.event_date
and serv.parity = mat.total_parity
left join rel on rel.sow_animal_id =