title: AWS Athena - how to escape characters like ',' which are present in quotes
body: <p>I have a table in Athena with three columns created with below template</p>
  <pre><code>Resources:
      TempDataMasterTable:
         Type: AWS::Glue::Table
         Properties:
           DatabaseName: &quot;temp_db&quot;
           CatalogId: !Ref AWS::AccountId
           TableInput:
             Name: &quot;temp_table&quot;
             Description: &quot;Master table&quot;
             TableType: EXTERNAL_TABLE
             Parameters: { &quot;classification&quot; : &quot;csv&quot;, &quot;compressionType&quot; : &quot;none&quot;, &quot;typeOfData&quot;: &quot;file&quot; }
             StorageDescriptor:
               Location: s3://temp-location/temp-folder/
               InputFormat: 'org.apache.hadoop.mapred.TextInputFormat'
               OutputFormat: 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
               SerdeInfo:
                 Parameters:
                   serialization.format: ','
                   field.delim: ','
                   SerializationLibrary: 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
               Columns:
               - {&quot;Name&quot;: &quot;name&quot;, &quot;Type&quot;: &quot;string&quot;}
               - {&quot;Name&quot;: &quot;address&quot;, &quot;Type&quot;: &quot;string&quot;}
               - {&quot;Name&quot;: &quot;desig&quot;, &quot;Type&quot;: &quot;string&quot;}
  </code></pre>
  <p>So basically columns are delimited by ',' but in my column 2 - address it is possible to have ',' for e.g one of the values in underlying csv has &quot;housenumber,street,city&quot; when we view the data in Athena the table is not being parsed correctly as street in the column 2 is being rendered as third column because of ',' being the delimiter.</p>
  <p>Is there a way to escape the ',' which are given in quotes ?</p>