Rakesh,
I believe that the processor is trying to create an Avro schema based on the
names/labels
of the columns that you select. Since parentheses are not valid characters in
Avro, I think
you should be okay if you just provide an alias, such as:
select max(id) AS maxId from ${dbname}.records where name=${myname}
The "AS maxId" I think should address your issue by providing an alternate name
for the column.
Thanks
-Mark
> On Nov 17, 2017, at 7:15 AM, rakesh <[email protected]> wrote:
>
> Hi Team,
>
>
> I have a nifi flow which uses ExecuteSQL Processor and tyring to execute
> *select max(id) from ${dbname}.records where name=${myname}*. I'm facing the
> following error.
> <http://apache-nifi-users-list.2361937.n4.nabble.com/file/t310/MaxIDError.png>
> .Any suggestion would be appreciated.
>
>
> Thanks
> Rakesh.
>
>
>
> --
> Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/
