Support Questions

Find answers, ask questions, and share your expertise

Insert Flow file content into a column in DB

avatar
Contributor

I have a flow file whose content is Json, 
I have table with schema
Name Null Type
-------- -------- ------------
SEQ_NUM NOT NULL NUMBER(22)
REQ_PYLD NOT NULL CLOB
CRTE_DT NOT NULL TIMESTAMP(6)
UPDT_DT NOT NULL TIMESTAMP(6)

I want Entire Json to be inserted into REQ_PYLD column 
I am trying to use PutDatabaseRecord with TreeReader but it is not working

Can Someone suggest the correct processor or flow to achieve this in NIfi

2 REPLIES 2

avatar
Community Manager

@Anderosn, Welcome to our community! To help you get the best possible answer, I have tagged in our NiFi experts @cotopaul @SAMSAL @MattWho @steven-matison who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

 



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: