NiFi: ReplaceTextWithMapping processor

[#1]

I have the following insert statements:

1insert into temp1 values (test1, test2)

2insert into temp2 values (test3)

Expected results:

insert into temp1 values (100, 200)

insert into temp2 values (300)

Essentially, I wanted to replace the first query literals test1, test2 with value 100, 200 respectively and for the second query replace test3 with value 300. Can someone help with the mapping file for the above use case?

I tried with the following, but it doesn't have any effect.

Search Value (RegEx) Replacement values

(1)(.*values.*)(.*test1)(.*,)(.*test2) $2 val1 $4 val2

(2)(.*values.*)(.*test1) $2 val3

[#2 · Accepted solution]

I realized PutHiveQL supports parameterized Hive query and I went for that.