[jira] [Assigned] (NIFI-2262) SQL processors fail if column name contains characters illegal for Avro

["Matt Burgess (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-2262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matt Burgess reassigned NIFI-2262:
----------------------------------

    Assignee: Matt Burgess

> SQL processors fail if column name contains characters illegal for Avro
> -----------------------------------------------------------------------
>
>                 Key: NIFI-2262
>                 URL: https://issues.apache.org/jira/browse/NIFI-2262
>             Project: Apache NiFi
>          Issue Type: Bug
>            Reporter: Matt Burgess
>            Assignee: Matt Burgess
>
> For SQL processors that output Avro (ExecuteSQL, QueryDatabaseTable, etc.), if the SQL result set contains columns whose names contain Avro-illegal characters (such as a period), then an error occurs:
> org.apache.avro.SchemaParseException: Illegal character in: user.gender
> These processors should either normalize the names for Avro automatically or have a property indicating whether names should be normalized.
> A workaround for ExecuteSQL in many cases is to alias the columns in the SQL. This approach doesn't currently work in QueryDatabaseTable for incremental fetch (i.e. maximum-value columns)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)