title: How to extract characters to the right of a delimited value in a SELECT statement in Hive
body: <p>I need to extract all the characters to the right of a "/" as part of a select statement.</p>
  
  <pre><code>city
  
  America/Chicago
  
  Europe/London
  </code></pre>
  
  <p>Expected output is </p>
  
  <pre><code>cityname
  
  Chicago
  
  London
  </code></pre>
  
  <p>This is my query which is not working</p>
  
  <pre><code>select substring(city, charindex('/',city) +1, length(city)) as cityname from table;
  </code></pre>