Can tHiveinput run multiple queries

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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!!

[Anonymous · Accepted solution]

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

[Anonymous]

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.