https://community.cloudera.com/t5/Archives-of-Support-Questions/ReplaceText-Processor/m-p/228103#M79952 <P>Hello!<BR />Can't understand whats wrong...<BR />I've got processors group to take data from json to sql.</P><P>When I try to "view as formatted" - I see this:</P><P style="margin-left: 20px;"><EM>Use SplitJson to split file after it use ReplaceText... and he doesn't work correctly. Unable to generate view of data: Unrecognized token 'INSERT': was expecting 'null', 'true', 'false' or NaN at [Source: (BufferedInputStream); line: 1, column: 8"</EM></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77830-replacetext-processor.jpg" style="width: 745px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15233iB104AA4A368BF66E/image-size/medium?v=v2&amp;px=400" role="button" title="77830-replacetext-processor.jpg" alt="77830-replacetext-processor.jpg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77834-after-replacetext.jpg" style="width: 1026px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15234i5324F3203B09ED2A/image-size/medium?v=v2&amp;px=400" role="button" title="77834-after-replacetext.jpg" alt="77834-after-replacetext.jpg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77832-after-splitjson.jpg" style="width: 438px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15235i55239B599C527DBC/image-size/medium?v=v2&amp;px=400" role="button" title="77832-after-splitjson.jpg" alt="77832-after-splitjson.jpg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77831-replacement-value.jpg" style="width: 1295px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15236i328C38F1DABF04C8/image-size/medium?v=v2&amp;px=400" role="button" title="77831-replacement-value.jpg" alt="77831-replacement-value.jpg" /></span></P> Sun, 18 Aug 2019 01:12:50 GMT vscherbakov 2019-08-18T01:12:50Z https://community.cloudera.com/t5/Archives-of-Support-Questions/ReplaceText-Processor/m-p/228103#M79952 <P>Hello!<BR />Can't understand whats wrong...<BR />I've got processors group to take data from json to sql.</P><P>When I try to "view as formatted" - I see this:</P><P style="margin-left: 20px;"><EM>Use SplitJson to split file after it use ReplaceText... and he doesn't work correctly. Unable to generate view of data: Unrecognized token 'INSERT': was expecting 'null', 'true', 'false' or NaN at [Source: (BufferedInputStream); line: 1, column: 8"</EM></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77830-replacetext-processor.jpg" style="width: 745px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15233iB104AA4A368BF66E/image-size/medium?v=v2&amp;px=400" role="button" title="77830-replacetext-processor.jpg" alt="77830-replacetext-processor.jpg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77834-after-replacetext.jpg" style="width: 1026px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15234i5324F3203B09ED2A/image-size/medium?v=v2&amp;px=400" role="button" title="77834-after-replacetext.jpg" alt="77834-after-replacetext.jpg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77832-after-splitjson.jpg" style="width: 438px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15235i55239B599C527DBC/image-size/medium?v=v2&amp;px=400" role="button" title="77832-after-splitjson.jpg" alt="77832-after-splitjson.jpg" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77831-replacement-value.jpg" style="width: 1295px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15236i328C38F1DABF04C8/image-size/medium?v=v2&amp;px=400" role="button" title="77831-replacement-value.jpg" alt="77831-replacement-value.jpg" /></span></P> Sun, 18 Aug 2019 01:12:50 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/ReplaceText-Processor/m-p/228103#M79952 vscherbakov 2019-08-18T01:12:50Z https://community.cloudera.com/t5/Archives-of-Support-Questions/ReplaceText-Processor/m-p/228104#M79953 <A rel="user" href="https://community.cloudera.com/users/83297/vscherbakov.html" nodeid="83297" target="_blank">@Vladislav Shcherbakov</A><P>Before ReplaceText processor use <STRONG>EvaluateJsonPath </STRONG>processor to extract the json values, keep as flowfile attributes. </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="77837-evaluatejsonpath.png" style="width: 1496px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15232iAEBC5E59234A0656/image-size/medium?v=v2&amp;px=400" role="button" title="77837-evaluatejsonpath.png" alt="77837-evaluatejsonpath.png" /></span></P><P>Add all your properties(case sensitive) in this processor and keep the destination as flowfile-attribute then feed the success relationship from EvaluateJsonpath to Replace text processor.</P><P><STRONG><U>Flow:</U></STRONG></P><PRE>---<BR />--- other processors 3.SplitJson<BR />5.EvaluateJsonPath 6.ReplaceText</PRE> Sun, 18 Aug 2019 01:12:25 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/ReplaceText-Processor/m-p/228104#M79953 Shu_ashu 2019-08-18T01:12:25Z