Peter Wicks created NIFI-2591:
---------------------------------
Summary: PutSQL has no handling for Binary data types
Key: NIFI-2591
URL: https://issues.apache.org/jira/browse/NIFI-2591
Project: Apache NiFi
Issue Type: Bug
Components: Core Framework
Reporter: Peter Wicks
PutSQL does not call out binary types for any special treatment, so they end up
being routed through stmt.setObject.
The problem is that upstream processors have formatted the binary data as a
string and the JDBC driver doesn't know what to do with a string going into a
binary field.
Investigation into the AvroToJSON processor shows that if users are trying to
load data exported from a source system as Avro Binary that Avro encodes the
binary data into ASCII (One byte per character).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)