Hive: writing column headers to local file?

syntax hive
CMaury picture CMaury · Apr 14, 2011 · Viewed 69.4k times · Source

Hive documentation lacking again:

I'd like to write the results of a query to a local file as well as the names of the columns.

Does Hive support this?

Insert overwrite local directory 'tmp/blah.blah' select * from table_name;

Also, separate question: Is StackOverflow the best place to get Hive Help? @Nija, has been very helpful, but I don't to keep bothering them...

Answer

iggy picture iggy · Nov 26, 2011

Try

set hive.cli.print.header=true;

Related questions

Is there a Hive equivalent of SQL "not like"

While Hive supports positive like queries: ex. select * from table_name where column_name like 'root~%'; Hive Does not support negative like queries: ex. select * from table_name where column_name not like 'root~%'; Does anyone know an …

Read More
How to concatenate string variables in Bash

In PHP, strings are concatenated together as follows: $foo = "Hello"; $foo .= " World"; Here, $foo becomes "Hello World". How is this accomplished in Bash?

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More