title: How to conditionally remove the first two characters from a column
body: <p>I have the below data of some phone records, and I want to remove the first two values from each record as they are a country code. What is the way by which I can do this using Scala, <a href="https://en.wikipedia.org/wiki/Apache_Spark" rel="nofollow noreferrer">Spark</a>, or <a href="https://en.wikipedia.org/wiki/Apache_Hive" rel="nofollow noreferrer">Hive</a>?</p>
  
  <pre><code>phone
  |917799423934|
  |019331224595|
  |  8981251522|
  |917271767899|
  </code></pre>
  
  <p>I'd like the result to be:</p>
  
  <pre><code>phone
  |7799423934|
  |9331224595|
  |8981251522|
  |7271767899|
  </code></pre>
  
  <p>How can we remove the prefix 91,01 from each record or each row of this column?</p>