How to export the header of hive table into CSV file?

[#1]

Venkat Please try this :

hive -e 'set hive.cli.print.header=true; select * from your_Table' | sed 's/[\t]/,/g'  > /home/yourfile.csv

Original answer https://stackoverflow.com/questions/17086642/how-to-export-a-hive-table-into-a-csv-file

[#2]

For this command I getting only the header.I want both header and data in the csv file

[#3]

Venkat

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.

hive -e 'set hive.cli.print.header=true; select * from your_Table' | sed 's/[\t]/,/g' > /home/yourfile.csv

Whats the result you are seeing if you just do "select * from your_Table"? Does the table have the data?

[#4]

Sorry @ssharma it is working but when I trying like this

1. hive -e 'set hive.cli.print.header=true; create table test row format delimited fields terminated by '|' as select * from test1'>/home/yourfile.csv in this scenario it only showing the header not the whole data csv file