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?


+
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