Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Upsert into postgres

Upsert into postgres

New Contributor

In my flow i am pulling data from a Json, splitting the Json and then inserting that into a postgres table using the putdatabaserecord processor. I have been using the insert statement option and it has been working fine but now I am trying to figure out how to do a INSERT INTO table ON CONFLICT UPDATE statement. I have been trying the option use "statement.type attribute" but I don't have much experience with this processor and I am not really sure how to write my query and set it up. Any help would be appreciated.



Don't have an account?
Coming from Hortonworks? Activate your account here