Karthik Narayanan created NIFI-3064:
---------------------------------------
Summary: Executesql convert to avrò 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: 0.6.1, 0.7.0, 1.0.0
Reporter: Karthik Narayanan
Customer came with some issues in executing query using executesql. He thought
the error was due to biting field in the query. But, upon research i was able
to reproduce the error when i tried this particular query
select A.host as host1,B.host as host from `hosts` A join host2 B on
B.hostid=A.hostid;
in the above query 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)
