hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matouk IFTISSEN <matouk.iftis...@ysance.com>
Subject RE: Hive Header line in Select query help?
Date Fri, 07 Jun 2013 08:41:41 GMT
It is not yet fixed this issue, thanks.

Any other solutions?



*De :* FangKun Cao [mailto:caofangkun@gmail.com]
*Envoyé :* vendredi 7 juin 2013 06:14
*À :* user@hive.apache.org
*Objet :* Re: Hive Header line in Select query help?



There's a issue working on this :

https://issues.apache.org/jira/browse/HIVE-4346



2013/6/7 Nitin Pawar <nitinpawar432@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.iftissen@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:nitinpawar432@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.iftissen@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:nitinpawar432@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.iftissen@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

Mime
View raw message