How to pass tJavaRow output (i.e.sql queries) as a batch to tHiveInput or tHiveRow

[Anonymous]

Hi, 

I have a job design as below. 

tFileInputDelimited -> tFlowtoIterate -> tJavaFlex ->(Iterate) tFileInputDelimited -> tJavaRow 

I am preparing the SQL queries dynamically from a file using the above flow and the till here the flow is working fine. Now, I want to pass the output from tJavaRow as batch(i.e. all the list of queries) to tHiveInput or tHiveRow. 

I tried.. 

..-> tJavaRow -> tForEach -> (OnComponentOk) -> tHiveConnection -> tHiveRow. 

The above flow is not working for me. I am sure, I am doing something wrong here. Please correct or suggest how to proceed further. 

[fdenis]

it's a bit tricky, can you post your actual job with the configuration of your components?

[Anonymous]

@fdenis

Sure. Will do. But let me try to figure out a way, if not i will post the complete information here. 

Btw, I was able to concatenate all the SELECT columns for all the queries and able to write it to tFileOutputDelimited. Hence we can close this thread.