当rrr字段没有值或者null或者nan时赋值为0,否者现实rrr本身 ,case when length(cast (t.rrr as string))=0 or t.rrr is null or cast(t.rrr as string)=‘nan’ then 0 else round(t.rrr,15) end rrr