https://community.cloudera.com/t5/Support-Questions/hive-REGEXP-REPLACE-seems-to-cuts-large-string-containing/m-p/235718#M197531 <P>Hi have a large numbers of xml files stores in hbase, the files containing binary data like pdf. word etc.</P><P>The column contents holds content of the xml file. </P><P>I want to replace the binary value from the xml tag DokumentFilIndhold with the value "Content Removed"</P><PRE> REGEXP_REPLACE(contents,"(?s)&lt;ns0:DokumentFilIndhold[^&gt;]*&gt;.*?&lt;/ns0:DokumentFilIndhold&gt;", "Content Removed")</PRE><P>The regular expression seems to work exactly as expected when i test it with <A href="https://regexr.com/" target="_blank">https://regexr.com/</A> </P><P>But when i run the query on my data it cuts of the contents. So its no longer a valid xml file. </P><P>Does the function REGEXP_REPLACE have some limitations or is it my expression that's wrong the value is up to 65000 chars. </P><P>Its Urgent for me to find a solution, so any idea will be very well recieved. </P><P> </P> Sat, 10 Nov 2018 18:41:28 GMT simon_jespersen 2018-11-10T18:41:28Z