https://community.cloudera.com/t5/Support-Questions/How-to-export-the-header-of-hive-table-into-CSV-file/m-p/223060#M184925 <P><A href="https://community.hortonworks.com/users/80182/chiranjeevivenkata51.html">Venkat</A></P><P>You should be getting both header and data with this command. I have just added "hive.cli.print.header=true" to print header along with data.</P><PRE>hive -e 'set hive.cli.print.header=true; select * from your_Table' | sed 's/[\t]/,/g' &gt; /home/yourfile.csv</PRE><P>Whats the result you are seeing if you just do "select * from your_Table"? Does the table have the data?</P> Thu, 21 Jun 2018 08:32:57 GMT ssharma 2018-06-21T08:32:57Z