我试图通过调用如下预定义的语句来执行所有的联合操作。
`new_records="""select
sor.EMP_ID,
sor.EMP_NAME,
sor.EMP_STATE,
sor.EMP_PH,
'I' as CDC_IND,
TO_DATE(from_unixtime(unix_timestamp())) as EFCT_DT,
cast('9999-12-31' as date) as EXPR_DT
from scd.EMP_SOR sor
left join scd.EMP_HIST_ACTIVE
activ