title: Right characters from hive string
body: <p>In hive there are no commands for getting the Left and Right part of a string.</p>
  
  <p>For Left it is not hard to find a workaround:</p>
  
  <pre><code>SELECT SUBSTR('abcdefgh',1,2);
  ab
  </code></pre>
  
  <p>What is the most elegant way to extract the two right hand side characters of the string?</p>