hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matouk IFTISSEN <matouk.iftis...@ysance.com>
Subject Hive header line in Select query help?
Date Wed, 17 Jul 2013 08:02:20 GMT
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 ;)*

Mime
View raw message