title: Hive padding leading zeroes
body: <p>I need the output of a string column in my table as 13 length char, irrespective of whatever length it is, i need to stuff the remaining chars with 0...</p>
  
  <p>I tried to use the following code in my hive query, but failed to get the desired output</p>
  
  <pre><code>right('0000000000000' + ProductID, 13)
  </code></pre>
  
  <p>Any help? Thanks</p>