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)

Reply via email to