CODEWITHSUNDEEP
hivehiveqlhue
user3476463
user3476463

Reputation: 4575

Export Hive Query Results

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.

Upvotes: 6

Views: 13734

Answers (2)

Romain
Romain

Reputation: 7082

Having the column header but missing data is a known issue: HUE-544

The workaround is to use Hue 3 or more or switch to HiveServer2 (recommended starting from CDH4.6).

Upvotes: 0

visakh
visakh

Reputation: 2553

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

Upvotes: 5

Related Questions