https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-ReplaceTextWithMapping-processor/m-p/141024#M48164 <P>I have the following insert statements:</P><P style="margin-left: 20px;">1insert into temp1 values (test1, test2)</P><P style="margin-left: 20px;">2insert into temp2 values (test3)</P><P>Expected results:</P><P style="margin-left: 20px;">insert into temp1 values (100, 200)</P><P style="margin-left: 20px;">insert into temp2 values (300)</P><P>Essentially, I wanted to replace the first query literals <U>test1</U>, <U>test2</U> 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?</P><P>I tried with the following, but it doesn't have any effect.</P><P>Search Value (RegEx) Replacement values</P><P><U>(1)(.*values.*)(.*test1)(.*,)(.*test2)</U> <U>$2 val1 $4 val2</U> </P><P><U> (2)(.*values.*)(.*test1)</U> <U>$2 val3</U></P> Wed, 07 Dec 2016 16:06:33 GMT ashsskum 2016-12-07T16:06:33Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-ReplaceTextWithMapping-processor/m-p/141024#M48164 <P>I have the following insert statements:</P><P style="margin-left: 20px;">1insert into temp1 values (test1, test2)</P><P style="margin-left: 20px;">2insert into temp2 values (test3)</P><P>Expected results:</P><P style="margin-left: 20px;">insert into temp1 values (100, 200)</P><P style="margin-left: 20px;">insert into temp2 values (300)</P><P>Essentially, I wanted to replace the first query literals <U>test1</U>, <U>test2</U> 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?</P><P>I tried with the following, but it doesn't have any effect.</P><P>Search Value (RegEx) Replacement values</P><P><U>(1)(.*values.*)(.*test1)(.*,)(.*test2)</U> <U>$2 val1 $4 val2</U> </P><P><U> (2)(.*values.*)(.*test1)</U> <U>$2 val3</U></P> Wed, 07 Dec 2016 16:06:33 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-ReplaceTextWithMapping-processor/m-p/141024#M48164 ashsskum 2016-12-07T16:06:33Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-ReplaceTextWithMapping-processor/m-p/141025#M48165 <P>I realized PutHiveQL supports parameterized Hive query and I went for that.</P> Thu, 08 Dec 2016 14:46:48 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-ReplaceTextWithMapping-processor/m-p/141025#M48165 ashsskum 2016-12-08T14:46:48Z