title: Hive Substring from complex subquery
body: <p>As below substring is developed by Greenplum platform, we have to migrate similar operation to Hive supported. kindly help us.</p>
  <pre><code>select substring(a.dealer_msisdn from char_length(a.dealer_msisdn)-9) as dealer_msisdn
  </code></pre>
  <p>example of msisdn value with above query for greenplum</p>
  <pre><code>select substring('9970050916' from char_length('9970050916')-9) as dealer_msisdn
  </code></pre>
  <p>Please help me similar operation needs to migrate hive.</p>