how to set reducers hive on thive row

[sakura99]

Hi all, so recently I am transferring data from oracle to hive.

When I test the query, it takes almost 2.5 hours to query.

My questions are:

1. Where to put reducers / parameter on thiverow properly?

(the example given below)

set.mapred.reduce.task=99;

set.hive.exec.reducers.max=99;

2.How much the amount I have to set to get maximum running query value 

for almost only 5-10 minutes?

Any other ideas to solve this problem, much be appreciated!

[Anonymous]

Hello @hallo sakura​,

You can check below help document for tHiveRow:

https://help.talend.com/r/en-US/7.3/hive/thiverow-standard-properties

You can set Mappers & Reducers in the component in "Set Resource Manager" configuration.