Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PutDatabasRecord inserting NULL instead of an empty string
Labels:
- Labels:
-
Apache NiFi
New Contributor
Created ‎01-12-2023 02:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a simple flow QueryDatabaseTableRecord >[CSV flowfile, Apache commons ] > PutDatabasRecord. The problem is that the last processor is trying to insert NULL instead of empty string as in source, which violates not null constraint. Is it possible to change this behaviour without adding additional processor? I want to keep it as simple as possible.
Thanks in advance.
Tomasz
1 REPLY 1
Contributor
Created ‎01-12-2023 02:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can try modifying the Record Reader avro schema to something like this:
{"name": "xxx", "type": "string"], "default": ""}
