Matt Burgess created NIFI-2262:
----------------------------------
Summary: 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
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)
