[ https://issues.apache.org/jira/browse/NIFI-5901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Thomsen resolved NIFI-5901. -------------------------------- Resolution: Not A Problem Turns out that if you stringify the JSON, it can be inserted correctly into a JSON field in at least Postgres and MySQL. Closing for that reason. The current recommendation is to use two schemas. One that has a full sub record representation and the second which replaces that with a string. > Write JSON record in database > ----------------------------- > > Key: NIFI-5901 > URL: https://issues.apache.org/jira/browse/NIFI-5901 > Project: Apache NiFi > Issue Type: Improvement > Affects Versions: 1.8.0 > Reporter: Flo Rance > Assignee: Mike Thomsen > Priority: Minor > Time Spent: 4h 10m > Remaining Estimate: 0h > > It would be good to be able to store a whole json record in databases that > implement it (e.g. postgresql). This would require to define the field in the > shema as json/jsonb and then let PutDatabaseRecord inserts the json value in > the json/jsonb field. > At the moment, it's possible to store a json/jsonb through Postgresql JDBC > using the Java sql type 'OTHER': > Object data = "\{...}"; // the JSON document > PreparedStatement.setObject(1, data, java.sql.Types.OTHER); -- This message was sent by Atlassian Jira (v8.20.10#820010)