I use a script to query Hive and store results in Local file, but no headers after execution of the select query how to do this? thanks
*De :* Nitin Pawar [mailto:nitinpawar...@gmail.com] *Envoyé :* jeudi 6 juin 2013 18:02 *À :* user@hive.apache.org *Objet :* Re: Hive Header line in Select query help? if you look at the setting it says "hive.cli" that means it is supposed to work on cli only. Which interface you want to use it ? On Thu, Jun 6, 2013 at 9:12 PM, Matouk IFTISSEN <matouk.iftis...@ysance.com> wrote: 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* -- Nitin Pawar
