topic How can I set up Hive parameters in a tHiveRow query? in Talend Studio

How can I set up Hive parameters in a tHiveRow query?

Anonymous — Mon, 22 Aug 2016 22:40:04 GMT

Hi,
I am trying to run the following query in a tHiveRow component:
"SET hive.exec.dynamic.partition=true
SET hive.exec.dynamic.partition.mode=nonstrict
SET hive.optimize.sort.dynamic.partition=true
SET hive.exec.max.dynamic.partitions=2048
SET hive.exec.max.dynamic.partitions.pernode=300
INSERT OVERWRITE TABLE table_test PARTITION (date) SELECT * FROM (SELECT tmp.id,opw.desc, opw.nm, opw.groupnm, tmp.date
AS date FROM table_test tmp LEFT JOINmock_table opw ON tmp.date = opw.date AND tmp.id = opw.id) t1"
The job runs ok (no errors) but nothing is inserted in table_test.
Could someone tell me what am I doing wrong?
Thanks in advance.
Facundo.

Re: How can I set up Hive parameters in a tHiveRow query?

Anonymous — Wed, 24 Aug 2016 08:47:22 GMT

Hi,
Could you please check out "Die on error" option on tHiveRow component to see if there is any error message printed on console?
Best regards
Sabrina

Re: How can I set up Hive parameters in a tHiveRow query?

Anonymous — Wed, 24 Aug 2016 21:23:28 GMT

"Die on error" is checked and the query runs successfully but the table table_test is empty.
This topic is similar to this other one:

Where I couldn't find an successfully answer.
Please, let me know if there are a way to run that query in on tHiveRow component.
I've found that I can split that query in several queries using a tFixedFlowInput, I tried but I have not been able to set it up correctly. If this way would be a possibility, please let me know how can I implement a tFixedFlowInput and a tHiveRow to process several queries.
Thanks