其中F_REL_PIN_PERSON_BASE_MID 九百万数据量
F_REL_PIN_PERSON_BASE_MID_TMP 四百万数据量
SELECT I_DNO,
I_DTYPE,
NAME,
GENDER,
CASE
WHEN BIRTH IS NOT NULL AND BIRTH <> '' THEN
BIRTH
ELSE
(SELECT BIRTH
FROM F_REL_PIN_PERSON_BASE_MID B
WHERE BIRTH IS NOT NULL
AND BIRTH <> ''
AND A.I_DNO = B.I_DNO
ORDER BY TABLE_ORDER ASC,
RECORD_TIME DESC FETCH FIRST 1 ROWS ONLY)
END BIRTH,
CASE
WHEN PHONE IS NOT NULL AND PHONE <> '' THEN
PHONE
ELSE
(SELECT PHONE
FROM F_REL_PIN_PERSON_BASE_MID B
WHERE PHONE IS NOT NULL
AND PHONE <> ''
AND A.I_DNO = B.I_DNO
ORDER BY TABLE_ORDER ASC,
RECORD_TIME DESC FETCH FIRST 1 ROWS ONLY)
END PHONE,
CASE
WHEN CELL_PHONE IS NOT NULL AND CELL_PHONE <> '' THEN
CELL_PHONE
ELSE
(SELECT CELL_PHONE
FROM F_REL_PIN_PERSON_BASE_MID B
WHERE CELL_PHONE IS NOT NULL
AND CELL_PHONE <> ''
AND A.I_DNO = B.I_DNO
ORDER BY TABLE_ORDER ASC,
RECORD_TIME DESC FETCH FIRST 1 ROWS ONLY)
END CELL_PHONE,
HOUSEHOLD_TYPE,
AVAILABLY_TAG,
HOUSEHOLD_REGION,
UNIQUE_PERSON_ID,
CURRENT TIMESTAMP AS LOAD_ODS_TIMESTAMP
FROM F_REL_PIN_PERSON_BASE_MID_TMP A
收起