Using tHiveRow to execute multiple Hive queries in Talend

Question

How can I execute multiple Hive queries using a single tHiveRow component? I was successful in executing a single query but unable to run multiple queries at once. Please suggest.

Answer 1

In order to execute multiple queries, you can include a tFixedFlowInput component in your job. In its configurations you can specify one string column and select an input table to get a new table with one column. Now, for every new line, Talend will create a Hive statement.

Once this is done, you can connect it to a tHiveRow and in the input column specify:

<flowName>.<columnName>

Hope this helps!

To know more about Talend, join Talend for big data certification training today.

Thanks.