【详述】
starrocks 3.2.16
starrocks 3fe 3be 混部
WITH process_alt_fail_tmp1 AS (
SELECT
stat_date,factory,process_name,product_name,phase_name,station,work_qis,start_time,sub_table_name,bin,
leak_rate_sccm,dept_name,floor_no,barcode,insert_time
FROM (
SELECT
ROW_NUMBER() OVER(PARTITION BY t.barcode, t.station ORDER BY t.start_time DESC) AS rn1,
stat_date,factory,process_name,product_name,phase_name,station,work_qis,start_time,sub_table_name,bin,
leak_rate_sccm,dept_name,floor_no,barcode,insert_time
FROM pdata_band.dw_rec_inspection_main t
WHERE t.stat_date = STR_TO_DATE(‘20260114’, ‘%Y%m%d’)
) a
WHERE rn1 = 1
AND work_qis = ‘FAIL’
AND station LIKE ‘ALT%’
AND bin IN (‘C’,‘D’,‘E’)
),
tmp as
(
SELECT
ROW_NUMBER() OVER(PARTITION BY t.stat_date, t1.barcode, t.station, t1.station ORDER BY t1.process_time DESC) AS rn,
t.factory,t.process_name,t.product_name,t.phase_name,
get_json_string(t1.process_info, ‘$.bill_no’) AS billno,
t1.station,
get_json_string(t1.process_info, ‘$.fixture’) AS fixture,
get_json_string(t1.process_info, ‘$.cavity’) AS cavity,
t1.barcode,
STR_TO_DATE(get_json_string(t1.process_info, ‘$.start_time’), ‘%Y-%m-%d %H:%i:%s’) AS starttime,
t.stat_date,
get_json_string(t1.process_info, ‘$.machine_ip’) AS machine_ip,
t.start_time AS istart_time,
t.station AS istart_station,
t.work_qis AS iwork_qis,
t.sub_table_name,
t1.request_id AS requestid,
t1.floor_no,
t.dept_name AS i_dept_name,
t.floor_no AS i_floor_no,
t.bin AS ibin,
t.leak_rate_sccm
FROM process_alt_fail_tmp1 t
INNER JOIN pdata_band.dw_tb_process_info t1
ON t.barcode = t1.barcode
AND t1.stat_date
BETWEEN DATE_SUB(‘20260114’, INTERVAL 15 DAY) AND ‘20260114’
AND STR_TO_DATE(get_json_string(t1.process_info, ‘$.start_time’), ‘%Y-%m-%d %H:%i:%s’) < t.start_time
INNER JOIN pstage_band.dic_alt_station_list t2
ON t1.product_name = t2.product_name
AND LOWER(t1.station) = LOWER(t2.station_name)
AND t2.valid_flag = ‘1’
)
SELECT
factory,process_name,product_name,phase_name,billno,station,fixture,cavity,barcode,starttime,stat_date,machine_ip,
istart_time,istart_station,iwork_qis,sub_table_name,requestid,floor_no,i_dept_name,i_floor_no,ibin,leak_rate_sccm
FROM tmp
–where rn = 1;
帮忙分析一下sql语句，starrocks 3.3.20
注释掉rn=1就不报错，注释去掉就报错，这种怎么规避：
ERROR 1064 (HY000): Expr evaluate meet error: slot_id 58 not found: BE:10006
【业务影响】調度任務失敗
【是否存算分离】存算一体
【StarRocks版本】3.3.20
【集群规模】3fe（1 follower+2observer）+ 3be
【机器信息】
【联系方式】StarRocks社区群20-生鱼片