Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I am using the excel file to input the data.
Based on the visual recipe, I am transforming the input excel file as per standard format and storing the output in hive table.
The question is I need to regularly need to change my input based on the business date and then upload. These needs to flow and do transformation as per steps provided in the recipe and then it need to insert value into hive final table without overwriting the existing output or drop the existing value in table.
Can you provide me the steps to do the configuration to achieve the above results.
I don't want to add multiple files in the input as I need to upload on regular basis with removing existing file ans upload the new file as per my business case
Thanks for your help.
If we use recipe with csv (hive compatiable) mode in output, the above option get enabled. So that i can able enable and run the flow successfully.
The data gets append instead of overwrite