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.

NiFi: ReplaceTextWithMapping processor

Solved Go to solution

NiFi: ReplaceTextWithMapping processor

Rising Star

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

Accepted Solutions
Highlighted

Re: NiFi: ReplaceTextWithMapping processor

Rising Star

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

1 REPLY 1
Highlighted

Re: NiFi: ReplaceTextWithMapping processor

Rising Star

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