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?
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