Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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
Highlighted

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}
Don't have an account?
Coming from Hortonworks? Activate your account here