Load csv file to Hive Table
<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>