Hi,
Field names should be unique.
Currently after executing query both 'plant.name' and 'area.name' will be
just same 'name'
You can use alias to have unique name, like:
SELECT plant.name as pname, area.area_id, area.name as aname
thanks
toivo
2016-04-21 18:51 GMT+03:00 Panos Geo :
> Hello all
t: Re: AvroRuntimeException : Duplicate field name
From: toivo.ad...@gmail.com
To: users@nifi.apache.org
Hi,
Field names should be unique.
Currently after executing query both 'plant.name' and 'area.name' will be just
same 'name'
You can use alias to have unique name, like:
SELEC
difference. It appears as if they are ignored and
> I am getting the same error.
>
> Any other thoughts?
>
> Many thanks,
> Panos
>
>
> --
> Date: Thu, 21 Apr 2016 18:59:33 +0300
> Subject: Re: AvroRuntimeException : Duplica
...
Thanks,Panos
Date: Thu, 21 Apr 2016 19:16:46 +0300
Subject: Re: AvroRuntimeException : Duplicate field name
From: toivo.ad...@gmail.com
To: users@nifi.apache.org
Sorry, I didn't read your email carefully enough.
Alias should work.
Which database you are using?
thanks
toivo
2016-04-21 19:05 GMT+
> Date: Thu, 21 Apr 2016 19:16:46 +0300
>
> Subject: Re: AvroRuntimeException : Duplicate field name
> From: toivo.ad...@gmail.com
> To: users@nifi.apache.org
>
> Sorry, I didn't read your email carefully enough.
>
> Alias should work.
> Which database y
rough NiFi) SQL statement execution in MariaDB works correctly.
I would appreciate any help with this.
Many thanks in advance,Panos
Date: Thu, 21 Apr 2016 19:36:22 +0300
Subject: Re: AvroRuntimeException : Duplicate field name
From: toivo.ad...@gmail.com
To: users@nifi.apache.org
It seems ExecuteSQ
RE plant.plant_id=area.plant_id;"
>
> Aliases in the SQL statement are ignored by the SQL execute processor.
> Direct (i.e. no through NiFi) SQL statement execution in MariaDB works
> correctly.
>
> I would appreciate any help with this.
>
> Many thanks in advance,
> Panos
order for this to work.
I hope this helps other people as well.
Best regards,
Panos
Date: Mon, 25 Apr 2016 17:37:36 +0300
Subject: Re: AvroRuntimeException : Duplicate field name
From: toivo.ad...@gmail.com
To: users@nifi.apache.org
Hi Panos,
NiFi inc