Using tHiveRow to execute multiple Hive queries in Talend

0 votes

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.

Apr 14, 2018 in Talend by 93.lynn
• 1,600 points
3,780 views

1 answer to this question.

0 votes

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.

answered Apr 14, 2018 by misc.edu04
• 1,450 points

Related Questions In Talend

0 votes
1 answer

How to generate multiple rows from a single row in Talend?

I think using tJavaFlex, tMap and tFlowToIterate ...READ MORE

answered Apr 18, 2018 in Talend by code.reaper12
• 3,500 points
7,711 views
0 votes
1 answer

In Talend, how to specify multiple conditions as expression

@Palaniswamy, have a look at this discussion ...READ MORE

answered Aug 5, 2019 in Talend by Vardhan
• 13,190 points
7,004 views
0 votes
2 answers
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 11, 2018 in Talend by code.reaper12
• 3,500 points
1,783 views
0 votes
1 answer

Adding third party libraries into the Talend project

You can add the 3rd party libraries ...READ MORE

answered Apr 9, 2018 in Talend by code.reaper12
• 3,500 points
3,821 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

Regarding your first issue, tWaitForFile component provides ...READ MORE

answered Apr 11, 2018 in Talend by geek.erkami
• 2,680 points
2,386 views
0 votes
1 answer

Downloading files using Talend Studio

As per my understanding, I think first ...READ MORE

answered Apr 12, 2018 in Talend by code.reaper12
• 3,500 points
2,305 views
+1 vote
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP