Hi all, so, i have to transfer my oracle data to hive, with thiverow.
The problem is, when i want to read the subqueries.
SELECT
NVL(
(
SELECT
MIN(DATE_TIME)AS E_DATE
FROM TEMP.A Z
WHERE REGEXP_EXTRACT(CURR_HC,'([^;]+)',0) = TEMP.AB.CURR_CODE
AND Z.DATE_TIME > TEMP.AB.DATE_TIME
),
(
SELECT
MIN(DATE_TIME)AS E_DATE
FROM TEMP.B Z
WHERE CURR_CODE = TEMP.AB.CURR_CODE
AND Z.DATE_TIME > TEMP.AB.DATE_TIME
)
)AS EXPI_DATE,
how to get it right?
Any ideas or helps aways be appreciated.
