Splitting a string in Pig in a column and then storing it in a row
<p>I have a csv file which contains 4 columns of data but has 250000 rows. </p>

<pre><code>A          B      C     D               
Tom        1      x    Blah Blah Blah
Bob        2      y    Blah &lt;p&gt; Blah
Jane       3      z    Blah, &amp;p *£
Harry      4      a    Blah "p" Blah
</code></pre>

<p>In col 4 I have a string that contains a variety of characters, some code, some special characters, some text. </p>

<p>I would like to take each word in D and combine it with the contents in A and store it in a new row i.e</p>

<pre><code>Tom Blah
Tom Blah
Tom Blah
Bob Blah
Bob &lt;p&gt;
Bob Blah
Jane Blah,
Jane &amp;p
Jane *£
Harry Blah
Harry "p"
Harry Blah
</code></pre>