question Re: How to execute multiple SQL query in NIFI PUT SQL processor at a time? in Archives of Support Questions (Read Only)

How to execute multiple SQL query in NIFI PUT SQL processor at a time?

saminathancs17 — Mon, 30 Jan 2017 18:25:37 GMT

How to execute multiple SQL queries in PutSql processor at a time

Ex: insert into table_a values('test_1'); insert into table_b values('test_2');

Flow:GetFile -> ReplaceText -> PutSQL -> PutFile

In the above flow ReplaceText processor will replace the flow file with above example query.

With this SQL flow file PutSql processor getting triggered and failed with error.

Re: How to execute multiple SQL query in NIFI PUT SQL processor at a time?

MattWho — Mon, 30 Jan 2017 21:21:51 GMT

@Saminathan A

The PutSQL processor expects that each FlowFile contains a single SQL statement and does not support multiple insert statements as you have tried above. You can have the GetFile Processor route its success relationship twice with each success going to its own ReplaceText processor. Each ReplaceText processor is then configured to create either the "table_a" or "table_b" insert statement. The success from both ReplaceText processors could then be routed to the same PutSQL processor.

Thanks,

Matt

Re: How to execute multiple SQL query in NIFI PUT SQL processor at a time?

saminathancs17 — Mon, 30 Jan 2017 21:59:27 GMT

@Matt

Thank you for your clarification.