环境变量识别报错

[AndyZjy]

详情

环境变量在 SQL 中识别时，会报如图的错误

SQL如下：

create table fen_hao_split
    as
    select '202107' as ${tmonth_code},t.project_code,d.ac_code,
    d.disp_code,d.disp_index,
    sum(case when d.isdecr is not null and d.isdecr<>t.isdecr then 0 else m_scale*t.rmb_value end) as ttl_value,
    sum(case when date_format(date_code,'yyyyMM')<concat(substr('202107',1,4),'01') and d.isdecr is not null and d.isdecr<>t.isdecr then 0
            when date_format(date_code,'yyyyMM')<concat(substr('202107',1,4),'01') then m_scale*t.rmb_value end) as jan_value 
    from ods_d_pfa_gl_account_df d 
    left join tmp_ads_fin_pfa_balance_proj_df_00_rt t 
    on substr(t.account_code,1,4) = d.fin_account_code 
    or substr(t.account_code,1,6) = d.fin_account_code 
        or substr(t.account_code,1,8) = d.fin_account_code 
    or substr(t.account_code,1,4)=split(fin_account_code,';')[0]
    where table_type='资产负债表'  and d.year_code=substr('202107',1,4)  and fiscal_period<='202107'
    group by t.project_code,d.ac_code,
            d.disp_code,d.disp_index
    limit 10
;