Export Hive Query Results

hive hiveql hue
user3476463 picture user3476463 · Jun 1, 2014 · Viewed 11.8k times · Source

I'm new to hive and could use some tips.

I'm trying to export query results from hive as a csv. When I try to pipe them out of CLI like:

hive -e 'select * from table'>OutPut.txt

I get a text file that has all the records but doesn't have the column headers. Does anyone have a tip for how to export the query results with the column headers, to a csv file?

If I run the query in hue, and then download the results as a csv I get a csv with the column headers but no records. If anyone has a tip on how to download query results from hue with records and column headers, I would greatly appreciate it too.

Answer

visakh picture visakh · Jun 1, 2014

To export the column headers, you need to set the following in the hiverc file:

set hive.cli.print.header=true;

To get just the headers into a file, you could try the following:

hive -e 'set hive.cli.print.header=true; SELECT * FROM TABLE_NAME LIMIT 0;' > /file_path/file_name.txt

Related questions

No partition predicate found for Alias even when the partition predicate in present in the query

I have a table pos.pos_inv in hdfs which is partitioned by yyyymm. Below is the query: select DATE_ADD(to_date(from_unixtime(unix_timestamp(Inv.actvydt, 'MM/dd/yyyy'))),5), to_date(from_unixtime(unix_timestamp(Inv.actvydt, …

Read More
Hive insert query like SQL

I am new to hive, and want to know if there is anyway to insert data into hive table like we do in SQL. I want to insert my data into hive like INSERT INTO tablename VALUES (value1,value2..) I …

Read More
How to select current date in Hive SQL

How do we get the current system date in Hive? In MySQL we have select now(), can any one please help me to get the query results. I am very new to Hive, is there a proper documentation for Hive …

Read More