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?
Nitin Pawar 2013-06-06, 16:01
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