title: how to read escape character in Athena
body: <p>Hi I have created a table in Athena with following query which will read csv file form S3.  </p>
  
  <pre><code>CREATE EXTERNAL TABLE IF NOT EXISTS axlargetable.AEGIntJnlTblStaging (
    `filename` string,
  )
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
  WITH SERDEPROPERTIES (
     'separatorChar' = ',',
     'quoteChar' = '\"'
     ) 
  LOCATION 's3://ax-large-table/AEGIntJnlTblStaging/'
  TBLPROPERTIES ('has_encrypted_data'='false');
  </code></pre>
  
  <p>But value in filename filed like <code>"\\emdc1fas\HR_UK\ADPFreedom_Employee_20141114_11.04.00.csv"</code></p>
  
  <p>When I read this table my values appears like</p>
  
  <pre><code>"\emdc1fasHR_UKADPFreedom_Employee_20141114_11.04.00.csv"
  </code></pre>
  
  <p>where I missing all the escape character (backslash) from the value. </p>
  
  <p>How can I read the value which will show me the actual value with escape character. </p>
  
  <p>Thanks</p>