You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Matt Burgess (JIRA)" <ji...@apache.org> on 2018/08/29 21:07:00 UTC

[jira] [Created] (NIFI-5563) SQL processors may generate Avro-incompatible column names

Matt Burgess created NIFI-5563:
----------------------------------

             Summary: SQL processors may generate Avro-incompatible column names
                 Key: NIFI-5563
                 URL: https://issues.apache.org/jira/browse/NIFI-5563
             Project: Apache NiFi
          Issue Type: Bug
          Components: Extensions
            Reporter: Matt Burgess


Although the "Convert Names for Avro" property in such processors as ExecuteQL replaces non-Avro characters with underscores, it doesn't validate/alter the names to ensure they are Avro compatible. For example, SELECT 1 may give a column name of 1, but Avro names have to start with one of [A-Za-z_]. We need to check for that and prefix an underscore if the name doesn't start with one of those characters. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)