title: How to deal with no escape commas in string fields when using `store.format`='csv' in drill table
body: <p>When using drill script to convert a set of <code>parquet</code> files to <code>csv</code>, running into problem where some of the fields have commas in them. This causes a problem because drill does not appear to automatically add any escaping <code>"&lt;field&gt;"</code> or <code>'&lt;field&gt;'</code> characters around the fields in the converted files (eg. for string values that look like "Soft-drink, Large").</p>
  
  <p>The script looks like</p>
  
  
  
  <pre><code>/opt/mapr/drill/drill-1.11.0/bin/sqlline \
          -u jdbc:drill:zk=node001:5181,node002:5181,node003:5181 \
          -n $(tail -n+1 $basedir/src/drill-creds.txt | head -1) \
          -p $(tail -n+2 $basedir/src/drill-creds.txt | head -1) \
          --run=$sqldir
  </code></pre>
  
  <p>where the sql being run by drill looks like</p>
  
  <pre class="lang-sql prettyprint-override"><code>alter session set `store.format`='csv';
  create table dfs.myworkspace.`/path/to/csv/destination` as 
  select .... 
  from dfs.myworkspace.`/path/to/origin/files`
  </code></pre>
  
  <p>Does anyone have any common ways they work around this? Is there a way to add escaping characters to the converted csv files (tried checking the docs (<a href="https://drill.apache.org/docs/create-table-as-ctas/" rel="nofollow noreferrer">https://drill.apache.org/docs/create-table-as-ctas/</a>), but could find nothing related)?</p>