topic Re: how to call another query based on another query in Talend Studio

how to call another query based on another query

sakura99 — Sat, 16 Nov 2024 00:53:38 GMT

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.

Re: how to call another query based on another query

Anonymous — Tue, 29 Dec 2020 06:43:24 GMT

@hallo sakura , i am trying to understand the problem and hope I can help you. This is a Oracle query, you can execute it in a tOracleInput component, what's the problem? what are your expected result?

Regards

Shong

Re: how to call another query based on another query

sakura99 — Tue, 29 Dec 2020 08:16:14 GMT

Sorry, It has to be executed on thiverow . My task is translating it into hiveql. my problem is with my job design. Is there any way to run thiverow query under another query.

Re: how to call another query based on another query

Prakhar1 — Tue, 29 Dec 2020 14:28:47 GMT

Could you show us your job design and explain problem in detail, not able to get your point