- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Insert Flow file content into a column in DB
- Labels:
-
Apache NiFi
Created on 07-27-2023 05:45 PM - edited 07-27-2023 06:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 07-27-2023 10:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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:
Created 07-28-2023 05:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anderosn,
Similar question was asked before, see if the following posts can help:
If Any of the links work for your case please accept solution.
Thanks
