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
+
Nitin Pawar 2012-05-26, 05:59
Copy link to this message
-
Re: odd header behavior?
Stephen Sprague 2012-05-28, 17:10
nah. no difference.  okay.  hive certainly shows immense potential but i
think i just have to fact the facts - its very immature at this time.

On Fri, May 25, 2012 at 10:59 PM, Nitin Pawar <[EMAIL PROTECTED]>wrote:

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