How to trim leading zero in Hive
<p>How to trim leading zero in Hive, I search too much on google but I didn't get any correct thing which is useful for my problem.</p>

<p>If digit is "00000012300234" want result like "12300234"</p>