Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> odd header behavior?

Copy link to this message
odd header behavior?
Hi Hive Users,

Please tell me if i am missing something.   I prefer to run hive on a thin
client so i connect to a hive server by specifying a (remote) host and
port. (eg. $ hive -h <host> -p <port>)  However, my sql results are not
coming back with headers - even though i explicitly request such.  To wit,
see below:

[namenode1:10000] hive> set hive.cli.print.header=true;
[namenode1:10000] hive> select * from sprague_test;
1       sprague
2       foo
3       bar

if i log on to the host where hadoop is running and run hive there w/o
specifying a host and port - i do get the headers.  Moreover if i am on the
hadoop host and i run hive with -h and -p as localhost - i don't get the

So whats up with hive.cli.print.header in remote mode?

Nitin Pawar 2012-05-26, 05:59
Stephen Sprague 2012-05-28, 17:10
Edward Capriolo 2012-05-28, 18:42
Stephen Sprague 2012-05-28, 19:08