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 <i...@decide.com> To: user@hive.apache.org; Ayon Sinha <ayonsi...@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 <ayonsi...@yahoo.com> 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. >