title: Loading .csv file into HIVE produces a table with a single long row
body: <p>I'm trying to load a .csv file on disk into Hive.</p>
  
  <p>Per this <a href="https://stackoverflow.com/questions/13628658/hive-text-delimiter">answer</a> on StackOverflow, I created the table using the following query:</p>
  
  <pre><code>CREATE TABLE mytable 
  (
  id_number STRING, 
  country STRING
  ) 
  ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
  STORED AS TEXTFILE;
  </code></pre>
  
  <p>I then dumped the data from the file into Hive using the following query:</p>
  
  <pre><code>LOAD DATA LOCAL INPATH /mytable.csv OVERWRITE INTO TABLE mytable;
  </code></pre>
  
  <p>Unfortunately, the result table in hive consisted of a single row, where each element (shown below) is a smashed-together version of a row from the .csv file:</p>
  
  <p>"aDXLS23M\tRussia" </p>
  
  <p>I've been stuck on this for hours and can't figure out how to get hive to recognize the column separators in the .csv file.  Any suggestions?</p>
  
  <p>Thanks in advance.</p>