topic Re: Talend execution pre conditon set in Data Quality

Talend execution pre conditon set

Anonymous — Sat, 16 Nov 2024 04:23:01 GMT

Hello Everyone,

i have a talend job which use tHiveRow to run query , how can i add some validation before run query.

So for example ,

Query Test1= insert into table a select * from table B.

Validation Test2=select max(date) from B.

if the result of Test2='2019-09-05' , then exit running but not throw excepting or error log, if Test2='2019-10-05' , then run query.

i am very novice in talend , please help and thanks so much in advance.

Re: Talend execution pre conditon set

Anonymous — Tue, 15 Oct 2019 04:46:29 GMT

Hi
Use a tHiveInput to query the max date and use runIf trigger to control the tHiveRow execution, eg:
tHiveInput--main--tJavaRow--runIf--tHiveRow

on tJavaRow:
if(TalendDate.compareDate(input_row.dateColumnName, TalendDate.parseDate("yyyy-MM-dd", "2019-10-05"))==0){
context.isContinue=true;
}else{
context.isContinue=false;
}

//Define a context variable isContinue with boolean type.

Set the condition of runIf as:
context.isContinue

Regards
Shong

Re: Talend execution pre conditon set

Anonymous — Wed, 16 Oct 2019 03:44:18 GMT

Thanks so much Shong. Just a note for other new learner , when we are using the TalendDate.compareDate(input_row.dateColumnName, TalendDate.parseDate("yyyy-MM-dd", "2019-10-05") , have to make sure both columns are date type.