There's a issue working on this : https://issues.apache.org/jira/browse/HIVE-4346
2013/6/7 Nitin Pawar <nitinpawar...@gmail.com> > if you do not have hiverc file then you can create one and use it with > --hiveconf along side your hive execution > you also set the same value just before your select query starts > > > On Thu, Jun 6, 2013 at 10:13 PM, Matouk IFTISSEN < > matouk.iftis...@ysance.com> wrote: > >> I use Hortonworks on windows (HDInsight) and I dont’ find the file >> hiverc , where can I fin it? And where I add >> set hive.cli.print.header=true; >> >> Thanks; >> >> *De :* Nitin Pawar [mailto:nitinpawar...@gmail.com] >> *Envoyé :* jeudi 6 juin 2013 18:31 >> >> *À :* user@hive.apache.org >> *Objet :* Re: Hive Header line in Select query help? >> >> >> >> why don't you set the variable in your script or in the hiverc file ? >> then it will work all the time >> >> >> >> On Thu, Jun 6, 2013 at 9:43 PM, Matouk IFTISSEN < >> matouk.iftis...@ysance.com> wrote: >> >> 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 >> >> >> >> >> >> -- >> Nitin Pawar >> > > > > -- > Nitin Pawar > -- Best wishs！ Fangkun.Cao
