title: How to handle fields enclosed within quotes(CSV) in importing data from S3 into DynamoDB using EMR/Hive
body: <p>I am trying to use EMR/Hive to import data from S3 into DynamoDB. My CSV file has fields which are enclosed within double quotes and separated by comma.
  While creating external table in hive, I am able to specify delimiter as comma but how do I specify that fields are enclosed within quotes?</p>
  
  <p>If I don’t specify, I see that values in DynamoDB are populated within two double quotes ““value”” which seems to be wrong.</p>
  
  <p>I am using following command to create external table. Is there a way to specify that fields are enclosed within double quotes?</p>
  
  <pre><code>CREATE EXTERNAL TABLE emrS3_import_1(col1 string, col2 string, col3 string, col4 string)  ROW FORMAT DELIMITED FIELDS TERMINATED BY '","' LOCATION 's3://emrTest/folder';
  </code></pre>
  
  <p>Any suggestions would be appreciated.
  Thanks
  Jitendra</p>