[NIFI-3064] ExecuteSQL convert to Avro fails when a MySQL query returns two columns with the same name even with different aliases

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0, 0.7.0, 0.6.1
• Fix Version/s: 1.1.0
• Assignee: Karthik Narayanan
• Reporter: Karthik Narayanan
• Created: 18/Nov/16 05:14
• Updated: 22/Nov/16 16:55
• Resolved: 22/Nov/16 16:55

Description

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.

Issue Links

• links to: GitHub Pull Request #1251