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.

MySQL Update Query with where clause in Nifi

MySQL Update Query with where clause in Nifi

Hi Team,



I'm trying to execute sql update query *update student set maxqueryid=0
where id=1;*.
using ExecuteSQL Processor. It resulted with error saying data manuplation
cannot be done since it accepts only select statements. How do I achieve
this usecase is there any procesor to do this job. Any suggestion would be
appreciated.




Thnaks
Rakesh.

1 REPLY 1
Highlighted

Re: MySQL Update Query with where clause in Nifi

Super Guru
Don't have an account?
Coming from Hortonworks? Activate your account here