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 Plain View
Hive >> mail # user >> odd header behavior?


+
Stephen Sprague 2012-05-26, 02:21
Copy link to this message
-
Re: odd header behavior?
try putting them in a file and execute as -f queryfile

On Sat, May 26, 2012 at 7:51 AM, Stephen Sprague <[EMAIL PROTECTED]> wrote:

> 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
> headers!
>
> So whats up with hive.cli.print.header in remote mode?
>
> Thanks,
> Stephen
>

--
Nitin Pawar
+
Stephen Sprague 2012-05-28, 17:10
+
Edward Capriolo 2012-05-28, 18:42
+
Stephen Sprague 2012-05-28, 19:08
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