title: How to export a Hive table into a CSV file?
body: <p>I used this Hive query to export a table into a CSV file.</p>
  
  <pre><code>INSERT OVERWRITE DIRECTORY '/user/data/output/test' select column1, column2 from table1;
  </code></pre>
  
  <p>The file generated '000000_0' does not have comma separator</p>
  
  <p>Is this the right way to generate CSV file? If no, please let me know how can I generate the CSV file?</p>