title: Exporting Hive Query to a CSV
body: <p>I'm attempting to export a query from <code>Hive</code> to a local <code>CSV</code>. This same error persists, any help would be greatly appreciated!</p>
  <p>Command:</p>
  <pre><code>insert overwrite local directory '/path/to/directory' 
  row format delimited fields terminated by ',' select * from table limit 10;
  </code></pre>
  <p>Error:</p>
  <pre><code>errorMessage:org.apache.spark.sql.catalyst.parser.ParseException:
  `missing 'TABLE' at 'local'
  </code></pre>
  <p>Thank you in advance.</p>