How can I set up Hive parameters in a tHiveRow query?
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.
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
"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
