Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Hive Header line in Select query help?


Copy link to this message
-
Re: Hive Header line in Select query help?
FangKun Cao 2013-06-07, 04:14
There's a issue working on this :
https://issues.apache.org/jira/browse/HIVE-4346
2013/6/7 Nitin Pawar <[EMAIL PROTECTED]>

> 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 <
> [EMAIL PROTECTED]> 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:[EMAIL PROTECTED]]
>> *Envoyé :* jeudi 6 juin 2013 18:31
>>
>> *À :* [EMAIL PROTECTED]
>> *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 <
>> [EMAIL PROTECTED]> 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:[EMAIL PROTECTED]]
>> *Envoyé :* jeudi 6 juin 2013 18:02
>> *À :* [EMAIL PROTECTED]
>> *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 <
>> [EMAIL PROTECTED]> 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