报错FAILED: ODPS-0130161:[11,9] Parse exception – invalid token ‘on’是什么问题呢？语法过不了 。 select ord0.service_id, ord0.serv_id, ord0.order_id, ord0.billing_cycle_id, ca.acct_id from ( select service_id,serv_id,order_id,billing_cycle_id,cust_id from dwd_odm_order_10
where dt =’${bizdate}’ ) ord0
left join ( select acct_id,cust_id,service_id from ods_zipper_cust_acct_10 ) ca
on ca.cust_id = ord0.cust_id and ca.service_id = ord0.service_id