Rakesh, For any update statements, you will need to use PutSQL instead of ExecuteSQL.
Thanks -Mark > On Nov 17, 2017, at 8:31 AM, rakesh <[email protected]> wrote: > > 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. > > > > -- > Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/
