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.

PutSQL if Node die

Solved Go to solution
Highlighted

PutSQL if Node die

Contributor

Hi All,

I have the theoretical question.

What happened if PutSQL sent the request to SQL server and exactly in this time Node failed(die/power shutdown).

PutSQL did not receive the answer from the SQL server if rows were inserted or not.

What does happen in this way? Will this rows be sent one more time? or will be sent to fail connection?

Or something else will happen?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: PutSQL if Node die

Master Guru
@Ilya Li

-

Each NiFi processor component must complete its execution before the triggering FlowFile is routed to one of the outbound relationships from the incoming connection.
-

Using you example:
the PutSQL processor would execute based on an incoming Flow or batch of incoming FlowFiles. Should NiFi completely die in the middle of the scheduled execution. Upon NiFi recover the FlowFile or Batch of Flowfiles would still be located on incoming connection to the putSQL processor and the same execution would occur again.

-

Thank you,

Matt

-

When an "Answer" addresses/solves your question, please select "Accept" beneath that answer. This encourages user participation in this forum.

1 REPLY 1

Re: PutSQL if Node die

Master Guru
@Ilya Li

-

Each NiFi processor component must complete its execution before the triggering FlowFile is routed to one of the outbound relationships from the incoming connection.
-

Using you example:
the PutSQL processor would execute based on an incoming Flow or batch of incoming FlowFiles. Should NiFi completely die in the middle of the scheduled execution. Upon NiFi recover the FlowFile or Batch of Flowfiles would still be located on incoming connection to the putSQL processor and the same execution would occur again.

-

Thank you,

Matt

-

When an "Answer" addresses/solves your question, please select "Accept" beneath that answer. This encourages user participation in this forum.