Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

NiFi: ReplaceTextWithMapping processor

avatar
Expert Contributor

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

1 ACCEPTED SOLUTION

avatar
Expert Contributor

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

View solution in original post

1 REPLY 1

avatar
Expert Contributor

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