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