报错信息截图
在2.1.2版本执行一段sql报错：
couldn't resolve slot descriptor 56, desc: tuples: Tuple(id=14 slots=[Slot(id=257 type=VARCHAR col=-1, colname=source_system, nullable=1)
执行的sql:
with tmp as (
select
t1.*,left(date_add(t2.max_business_date, interval 1 day),10) as max_business_date
from dw.dwd_property_daily_info t1
join (
select
building_id,
property_code,
min(business_date) as business_date,
max(business_date) as max_business_date
from dw.dwd_property_daily_info
where business_date >= '2024-04-15'
and contract_no is null
group by property_code,building_id
) t2
on t1.building_id = t2.building_id
and t1.business_date >= t2.business_date
and t1.property_code = t2.property_code
)
, tmp2 as (
select
*
from tmp
where max_business_date = business_date
and left(start_date, 10) <= business_date
)select
t1.source_system,
t1.building_id,
t1.property_code,
t1.business_date,
t1.property_name,
t1.type,
t1.is_active,
t1.property_status,
coalesce(t2.contract_no,t1.contract_no) as contract_no,
coalesce(t2.contract_category,t1.contract_category),
coalesce(t2.actual_confirm_date,t1.actual_confirm_date),
coalesce(t2.start_date,t1.start_date),
coalesce(t2.actual_open_date,t1.actual_open_date),
coalesce(t2.actual_end_date,t1.actual_end_date),
coalesce(t2.contract_status, t1.contract_status),
coalesce(t2.contract_status_a,t1.contract_status_a),
coalesce(t2.area_total,t1.area_total),
coalesce(t2.rented_area,t1.rented_area),
coalesce(t2.rental_area,t1.rental_area),
coalesce(t2.opening_area,t1.opening_area),
t1.insertdate,
now()
from (select * from tmp where contract_no is null) t1
left join tmp2 t2
on t1.building_id = t2.building_id
and t1.property_code = t2.property_code
