title: Hive split a string and insert into table
body: <p>Here my question. I have a long string in a table, now I want to split it, and insert the result from splitting into another table.</p>
  
  <p>for example.</p>
  
  <pre><code>INSERT TABLE table1 
  SELECT 
      split(result, ';')[0],
      split(result, ';')[1],
      ...
  FROM table2
  WHERE ...
  </code></pre>
  
  <p>suppose result is a long string delimited by ';'</p>
  
  <p>My query is not right, How can I fix it?</p>