RE: Kill-and-Fill Pattern?

PutSQL to support Merged FlowFiles. --Peter From: Toivo Adams [mailto:toivo.ad...@gmail.com] Sent: Sunday, August 28, 2016 7:27 AM To: users@nifi.apache.org Subject: Re: Kill-and-Fill Pattern? hi Could new processor PutAvroSQL help? Processor will use data in Avro format and insert all records

Re: Kill-and-Fill Pattern?

ill and fill a destination SQL table with this source data on an > interval. > > > > My non kill-and-fill pattern is: ExecuteSQL -> Avro To JSON -> JSON To SQL > -> PutSQL. > > > > I’m trying to come up with a good way to delete existing data first before

Re: Kill-and-Fill Pattern?

26, 2016, at 7:45 AM, Peter Wicks (pwicks) <pwi...@micron.com> wrote: I have a source SQL table that I’m reading with a SQL select statement. I want to kill and fill a destination SQL table with this source data on an interval. My non kill-and-fill pattern is: ExecuteSQL -> Avro To

Kill-and-Fill Pattern?

I have a source SQL table that I'm reading with a SQL select statement. I want to kill and fill a destination SQL table with this source data on an interval. My non kill-and-fill pattern is: ExecuteSQL -> Avro To JSON -> JSON To SQL -> PutSQL. I'm trying to come up with a good way