https://community.cloudera.com/t5/Support-Questions/How-to-export-the-header-of-hive-table-into-CSV-file/m-p/223058#M184923 <P><A rel="user" href="https://community.cloudera.com/users/80182/chiranjeevivenkata51.html" nodeid="80182">Venkat</A> Please try this :</P><PRE><CODE>hive -e 'set hive.cli.print.header=true; select * from your_Table' | sed 's/[\t]/,/g' &gt; /home/yourfile.csv</CODE></PRE><P>Original answer <A href="https://stackoverflow.com/questions/17086642/how-to-export-a-hive-table-into-a-csv-file">https://stackoverflow.com/questions/17086642/how-to-export-a-hive-table-into-a-csv-file</A></P> Mon, 18 Jun 2018 12:18:55 GMT ssharma 2018-06-18T12:18:55Z