FAQ
Hi Matouk,

as your question is not related to Impala, let me kindly point you to
the Hive user list: user@hive.apache.org

They should be able to help you out!

Cheers,

Alex
On Thu, Jun 6, 2013 at 5:59 AM, wrote:
Hello Ivry bady,

I want to khow if there is à way to export header line in select query to
store the result in file from local or HDFS directory?
like this query result :

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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedJun 6, '13 at 4:36p
activeJun 6, '13 at 4:36p
posts1
users1
websitecloudera.com
irc#hadoop

1 user in discussion

Alex Behm: 1 post

People

Translate

site design / logo © 2022 Grokbase