Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
-
Hive header line in Select query help?
Hello Hive user,

I want to know if is there a way to export header line in select query, in
order 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;

known that the set hive.cli.print.header=true; does not work . it works
only in the CLI.

*thanks for your answers ;)*
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB