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