You now have until September 15th to submit your use case or success story to the 2022 Dataiku Frontrunner Awards!ENTER YOUR SUBMISSION

How to append or insert record in final hive table

SUSHIL
Level 3
How to append or insert record in final hive table

Hi, 

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

 

0 Kudos
2 Replies
Manuel
Dataiker
Dataiker

Hi,

In the input/output settings of a recipe, you can tick the append box for the output dataset, see attached.

I hope this helps.

0 Kudos
SUSHIL
Level 3
Author

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

0 Kudos