Right characters from hive string
<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>