title: concatenating text to a column in pig
body: <p>I have a day column and a month column and would like to concatenate the year to it and store it in <code>CHARARRAY</code> format with the hyphens.
  so I have: <code>month:CHARARRAY, day:CHARARRAY</code></p>
  
  <p>Meaning, for example, if the day column contains '03' and the month column contains '04', I would like to create a date column that contains: '2014-04-03'</p>
  
  <p>This is my code:</p>
  
  <p><code>CONCAT('2014-',month,'-',day) as date;</code></p>
  
  <p>It doesn't work and I'm not quite sure how to concatenate additional text onto the column.
  I would like to note that I'm not sure converting to date format is an option for me. I would prefer to keep it in <code>CHARARRAY</code> format since I would like to join with another file that has date stored in <code>CHARARRAY</code> format.</p>