[NIFI-3430] PutSQL Errors attempting to coerce date string to timestamp

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Component/s: Extensions
• Labels: convertjsontosql putsql
• Assignee: Unassigned
• Reporter: Nicholas Carenza
• Created: 02/Feb/17 01:16
• Updated: 06/Feb/17 17:35
• Resolved: 06/Feb/17 17:35

Description

I am attempting to write a flat json object to my postgresql database using ConvertJSONToSQL followed by PutSQL. My json has a string date field in ISO 8601 format which postgres can accept as a timestamp. The column in the database is of type 'timestamp without time zone'.

org.apache.nifi.processor.exception.ProcessException: The value of the sql.args.33.value is '2017-02-01T23:12:21+00:00', which cannot be converted to a timestamp

Is PutSQL trying to do some preprocessing here that it should just let the database handle?

select cast('2017-02-01T23:12:21+00:00' as timestamp without time zone);
timestamp
---------------------
2017-02-01 23:12:21
(1 row)

Issue Links

• links to: GitHub Pull Request #1468