title: Hive: regexp_replace square brackets
body: <p>I need to replace the square brackets around a key:value pair similar to the following.  Any help is much appreciated! </p>
  
  <p>data in 'properties' looks like this:</p>
  
  <pre><code>name: property1
  value: [12345667:97764458]
  
  **code**
  SELECT p.name, regexp_replace(p.value,'[','') AS value
  FROM properties p
  </code></pre>
  
  <p>Solved: Revised code</p>
  
  <pre><code>SELECT p.name, regexp_replace(p.value,'\\[|\\]','') AS value
  FROM properties p;
  </code></pre>