Support Questions
Find answers, ask questions, and share your expertise

Illegal Character in max(id) with Execute SQL Processor

Illegal Character in max(id) with Execute SQL Processor

Hi Team,

I have a nifi flow with Execute SQL Processor. I'm trying to execute "select max(id) from ${dbname}.records where name=${myname}". Processor is showing error message "illegal character in: max(id)". Kindly suggest me to solve this.

Thanks

Rakesh.

1 REPLY 1

Re: Illegal Character in max(id) with Execute SQL Processor

Super Guru
@rakesh chow

Try to keep alias for the max(id) column as id it should work

Execute SQL Query:-

select max(id) id from ${dbname}.records where name=${myname}