title: remove surrounding quotes from fields while loading data into hive
body: <p>I want to load a table with input data into hive. I have data in the following format. </p>
  
  <pre><code>"153662";"0002241447";"0"
  "153662";"000647036X";"0"
  "153662";"0020434901";"0"
  "153662";"0020973403";"0"
  "153662";"0028604202";"0"
  "153662";"0030437512";"0"
  </code></pre>
  
  <p>I want to load this data into a table with two varchar columns and one int column.But the surrounding double quotes trouble me. I have created the following table.</p>
  
  <pre><code>CREATE EXTERNAL TABLE Table(A varchar(50),B varchar(50),C varchar(50))
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY '\;'
  LINES TERMINATED BY '\n'
  
  STORED AS TEXTFILE
  </code></pre>
  
  <p>but the quotes around the field also become part of field as shown below.</p>
  
  <pre><code>"276725"    "034545104X"    "0"
  "276726"    "0155061224"    "5"
  </code></pre>
  
  <p>I want to ignore them. Also I want the third field to be read as INT. Currently it becomes NULL when I provide third field as INT while making table.</p>