hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Hive Header line in Select query help?
Date Thu, 06 Jun 2013 16:01:43 GMT
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

Mime
View raw message