title: Remove last characters from string in hiveql
body: <p>I need help with Hive, I've tried a lot functions in Hive and I havent been able to do what I need to do.</p>
  
  <p>Look at the following example:
  3231220-9</p>
  
  <p>I just need to keep everything but the '-9' the rest is not needed.</p>
  
  <p>Please help!</p>