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 ;)*