Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Hive header line in Select query help?


Copy link to this message
-
Hive header line in Select query help?
Hello Hive user,

I want to know if is there a way to export header line in select query, in
order to store the result in file (from  local or HDFS directory)?
 like this query result :

set hive.cli.print.header=true;

INSERT OVERWRITE LOCAL DIRECTORY 'C:\resultats\alerts_http_500\par_heure'
SELECT  heure_actuelle,nb_erreur_500, pct_erreurs_500 ,
 heure_precedentele, nb_erreur_500, hp.pct_erreurs_500
FROM Ma_table;

known that the set hive.cli.print.header=true; does not work . it works
only in the CLI.

*thanks for your answers ;)*