Paul Gibeault created NIFI-2829: ----------------------------------- Summary: PutSQL assumes all Date and Time values are provided in Epoch Key: NIFI-2829 URL: https://issues.apache.org/jira/browse/NIFI-2829 Project: Apache NiFi Issue Type: Bug Components: Core Framework Affects Versions: 1.0.0 Reporter: Paul Gibeault Fix For: 1.1.0
This bug is the same as NIFI-2576 only extended to data types DATE and TIME. https://issues.apache.org/jira/browse/NIFI-2576 When PutSQL sees a DATE or TIME data type it assumes that it's being provided as a Long in Epoch format. This doesn't make much sense since the Query Database tools that return Avro return DATES and TIME values as strings; and thus following the Avro->JSON->JSON To SQL Route leads to DATE and TIME fields as being strings. -- This message was sent by Atlassian JIRA (v6.3.4#6332)