secuvalorig
SET hive.auto.convert.join=true; USE ${RLOB_DATABASE}; ALTER TABLE ${RLOB_TARGET_TABLE} DROP IF EXISTS PARTITION (SRC_SYSTEM_CODE='${RLOB_SOURCE_SYSTEM_CODE}', ${RLOB_DATE_PARTITION}); INSERT INTO ${RLOB_TARGET_TABLE} PARTITION (SRC_SYSTEM_CODE='${RLOB_SOURCE_SYSTEM_CODE}', ${RLOB_DATE_PARTITION}) ( security_val_orgntn_id, src_key_security_val_orgntn_id, src_key_cred_appl_mpl_id, asset_num, appl_status_dt, appl_num, appl_dt, ca_appl_status_dt, security_orgntn_id, cred_appl_mpl_id, src_key_security_orgntn_id, asset_hex_num, asset_value_amt, appraisal_amt, appraisal_dt, appraisal_type, appraisal_src, carried_forward_ind, src_snapshot_dt, src_load_dt_time, load_dt_time, last_update_user, update_reason, requestor_user, approver_user, batch_id, batch_code ) SELECT DISTINCT IF(stg.APPL_NUM IS NOT NULL, safe_concat('DM_RTL_SLO', '-', ${RLOB_SNAPSHOT_DATE}, '-', security_val.COL_...