Hive Header line in Select query help?

[Matouk IFTISSEN]

Hello Ivry bady,



I want to know if is  there a way to export headers line in select query to
store the result in file from local or HDFS directory?

 like this query results :



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;



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



*thanks for your answers ;)*

*Matouk*