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
area
> WHERE 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 a
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 ExecuteSQL
; --
> 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.
&g
...
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+03:00
: 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:
SELECT plant.name as pname, area.area_id
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