title: Splitting a string in SparkSQL
body: <p>I have a file with several lines. For example </p>
  
  <pre><code>A               B       C    
  awer.ttp.net    Code    554
  abcd.ttp.net    Code    747
  asdf.ttp.net    Part    554
  xyz.ttp.net     Part    747
  </code></pre>
  
  <p>I want to make a SparkSQL statement to split just column a of the table and I want a new row added to the table D, with values awe, abcd, asdf, and xyz.</p>