[
https://issues.apache.org/jira/browse/NIFI-3064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess updated NIFI-3064:
-------------------------------
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.
was:
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.
> 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)
