[
https://issues.apache.org/jira/browse/NIFI-3064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15676572#comment-15676572
]
Matt Burgess commented on NIFI-3064:
------------------------------------
Presently there is not a reliable way for ExecuteSQL to know what type of
database is being used. I think if the updated logic is tested on various
popular DBs, such as MySQL, Postgres, and Oracle (and Derby in the unit tests),
it should capture the various behaviors and provide the appropriate values for
column names/aliases.
> ExecuteSQL convert to Avro fails when a MySQL query returns two columns with
> the same name even with different aliases
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: NIFI-3064
> URL: https://issues.apache.org/jira/browse/NIFI-3064
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 1.0.0, 0.7.0, 0.6.1
> Reporter: Karthik Narayanan
> Assignee: Matt Burgess
>
> For the following query:
> select A.host as host1,B.host as host from `hosts` A join host2 B on
> B.hostid=A.hostid;
> A.host and B.host are columns that have same name, but come from different
> tables, and have a different alias name. But looks like Avro conversion is
> ignoring the alias and just looking at the column name. This causes the query
> to fail with this error
> Duplicate Field Name in any.data.hosts ; name type UNION pos:1 and name type
> UNION pos:0.
> I have attached a screenshot for the same.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
