title: How do I output the results of a HiveQL query to CSV?
body: <p>we would like to put the results of a Hive query to a CSV file. I thought the command should look like this:</p>
  
  <pre><code>insert overwrite directory '/home/output.csv' select books from table;
  </code></pre>
  
  <p>When I run it, it says it completeld successfully but I can never find the file. How do I find this file or should I be extracting the data in a different way?</p>