title: Hive load CSV with commas in quoted fields
body: <p>I am trying to load a CSV file into a Hive table like so:</p>
  
  <pre><code>CREATE TABLE mytable
  (
  num1 INT,
  text1 STRING,
  num2 INT,
  text2 STRING
  )
  ROW FORMAT DELIMITED FIELDS TERMINATED BY ",";
  
  LOAD DATA LOCAL INPATH '/data.csv'
  OVERWRITE INTO TABLE mytable;    
  </code></pre>
  
  <p><br />
  The csv is delimited by an comma (,) and looks like this:</p>
  
  <pre><code>1, "some text, with comma in it", 123, "more text"
  </code></pre>
  
  <p>This will return corrupt data since there is a ',' in the first string.<br/>
  Is there a way to set an text delimiter or make Hive ignore the ',' in strings?</p>
  
  <p>I can't change the delimiter of the csv since it gets pulled from an external source.</p>