title: Load csv file to Hive Table
body: <p>I have a csv file which has contents like this.</p>
  
  <pre><code>"DepartmentID","Name","GroupName","ModifiedDate"
  "1","Engineering","Research and Development","2008-04-30 00:00:00"
  </code></pre>
  
  <p>I have </p>
  
  <pre><code>create external table if not exists AdventureWorks2014.Department
  ( 
      DepartmentID smallint , 
      Name string ,
     GroupName string, 
      rate_code string, 
      ModifiedDate timestamp 
  )   
  ROW FORMAT DELIMITED FIELDS TERMINATED BY '","' lines terminated by '\n'
  STORED AS TEXTFILE LOCATION 'wasb:///ds/Department' TBLPROPERTIES('skip.header.line.count'='1');`
  </code></pre>
  
  <p>And after loading the data </p>
  
  <pre><code>LOAD DATA INPATH 'wasb:///ds/Department.csv' INTO TABLE AdventureWorks2014.Department;
  </code></pre>
  
  <p>The data is not loaded.</p>
  
  <pre><code>select * from AdventureWorks2014.Department;
  </code></pre>
  
  <p>The above select returns nothing.</p>
  
  <p>I think the double quotes around each fileds is the issue. Is there a way to load the data from such a file to hive tables, Without having to strip out the double quotes?</p>