Grokbase Groups Hive user July 2011
FAQ
Hi,
I wanted to find out if there is a way to get column headers in the results for the queries.

-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.

Search Discussions

  • Igor Tatarinov at Jul 21, 2011 at 8:16 pm
    set hive.cli.print.header=true;

    should work.

    igor
    decide.com

    On Thu, Jul 21, 2011 at 12:57 PM, Ayon Sinha wrote:

    Hi,
    I wanted to find out if there is a way to get column headers in the results
    for the queries.

    -Ayon
    See My Photos on Flickr <http://www.flickr.com/photos/ayonsinha/>
    Also check out my Blog for answers to commonly asked questions.<http://dailyadvisor.blogspot.com>
  • Ayon Sinha at Jul 21, 2011 at 9:07 pm
    Works for select but while changing DB it give NPE:

    hive> use userstore
    ;
    OK
    Exception in thread "main" java.lang.NullPointerException
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:176)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:186)


    -Ayon
    See My Photos on Flickr
    Also check out my Blog for answers to commonly asked questions.



    ________________________________
    From: Igor Tatarinov <igor@decide.com>
    To: user@hive.apache.org; Ayon Sinha <ayonsinha@yahoo.com>
    Sent: Thursday, July 21, 2011 1:16 PM
    Subject: Re: Is there a way to have column headers in results


    set hive.cli.print.header=true;

    should work.

    igor
    decide.com




    On Thu, Jul 21, 2011 at 12:57 PM, Ayon Sinha wrote:

    Hi,
    I wanted to find out if there is a way to get column headers in the results for the queries.

    -Ayon
    See My Photos on Flickr
    Also check out my Blog for answers to commonly asked questions.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedJul 21, '11 at 7:58p
activeJul 21, '11 at 9:07p
posts3
users2
websitehive.apache.org

2 users in discussion

Ayon Sinha: 2 posts Igor Tatarinov: 1 post

People

Translate

site design / logo © 2022 Grokbase