topic Re: Can tHiveinput run multiple queries in Talend Studio

Can tHiveinput run multiple queries

Anonymous — Sat, 16 Nov 2024 04:22:24 GMT

hello everyone, Can tHiveinput run multiple queries because we want to validate 2 result from 2 different tables, thanks in advance.

Re: Can tHiveinput run multiple queries

Anonymous — Wed, 16 Oct 2019 09:05:14 GMT

Hi
It is impossible to execute multiple queries on one tHiveInput, you can use two tHiveinput components to execute each query and store the result to context variable or global variable for used later. eg:
tHiveInput--main--tJavaRow
on tJavaRow:
context.date1=input_row.dateColumnName;

Hope it helps you!

Regards
Shong

Re: Can tHiveinput run multiple queries

Anonymous — Thu, 17 Oct 2019 07:25:33 GMT

hello Shong , thanks for your response, so do i have to use 2 tHiveinput and 2 tJavarow ?

Re: Can tHiveinput run multiple queries

Anonymous — Thu, 17 Oct 2019 10:31:41 GMT

hello , could you please clarify how can i get value , now both value are null value.

And in tJavarow i am writting

context.reference = input_row.reference;
context.reference1 = input_row.reference1;
System.out.println(context.reference);
System.out.println(context.reference1);

Thanks!!

Re: Can tHiveinput run multiple queries

Anonymous — Fri, 18 Oct 2019 05:26:09 GMT

Hi
Change the job like:
tHiveinput--main--tJavaRow1
_onsubjobok
tHiveinput2-main--tJavaRow2--runIf-->other components

Re: Can tHiveinput run multiple queries

Anonymous — Fri, 18 Oct 2019 07:04:10 GMT

thanks Shong , this is correct and i have completed test, but i have to think if there are more than 5 queries need to be validated and execute in other situation , whether there is good method or not. Will post here once any update.