How to copy and convert parquet files to csv
<p>I have access to a hdfs file system and can see parquet files with</p>

<pre><code>hadoop fs -ls /user/foo
</code></pre>

<p>How can I copy those parquet files to my local system and convert them to csv so I can use them?  The files should be simple text files with a number of fields per row.</p>

<p>If there is a table defined over those parquet files in Hive (or if you define such a table yourself), you can run a Hive query on that and save the results into a CSV file. Try something along the lines of:</p>

<pre>
insert overwrite local directory <i>dirname</i>
  row format delimited fields terminated by ','
  select * from <i>tablename</i>;
</pre>

<p>Substitute <em><code>dirname</code></em> and <em><code>tablename</code></em> with actual values. Be aware that any existing content in the specified directory gets deleted. See <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Writingdataintothefilesystemfromqueries" rel="nofollow">Writing data into the filesystem from queries</a> for details.</p>

python hadoop apache-spark pyspark parquet