title: Splitting data into multiple columns in Hive
body: <p>How can I split a data string into 3 separate columns in a Hive table?</p>
  
  <p>Example input data: <code>116:151:1</code>.  Split as <code>gid, sid, rid</code>.</p>
  
  <p>Required output:</p>
  
  <pre><code>gid    sid     rid
  116    151     1
  </code></pre>