title: How can I lexicographically sort numbers stored in a string?
body: <p>I have a list of numbers in string format that look like this:</p>
  
  <blockquote>
    <p>1-1<br/> 1-11<br/> 1-12<br/> 1-2<br/> 1-21 <br/> 1-2-31</p>
  </blockquote>
  
  <p>I want to sort it it such that I get the output in the below format.</p>
  
  <blockquote>
    <p>1-1<br/> 1-2<br/> 1-2-31<br/> 1-11<br/> 1-12<br/> 1-21 </p>
  </blockquote>
  
  <p>I have to do this sorting in Hive. How can I  achieve this?</p>