Vikas, Looks like your metadata is corrupted. Can you paste the output of following: hive> describe formatted aircel_obd;
Ashutosh On Wed, Aug 24, 2011 at 03:46, Vikas Srivastava <vikas.srivast...@one97.net>wrote: > hey thanks for reply, > > i m using hadoop 0.20.2, > and hive: 0.7.0 > > i have install hive on new server and making that use readonly , > > > On Wed, Aug 24, 2011 at 4:05 PM, Chinna <chinna...@huawei.com> wrote: > >> Hi,**** >> >> ** ** >> >> Can u post some more details like which version u r using and what >> sequence of queries u have executed.**** >> >> When I checked the trunk code this exception will come when getCols() >> returns null. Check u r metadata is in good state or not.**** >> >> Thanks**** >> >> Chinna Rao Lalam**** >> >> ---------- Forwarded message ---------- >> From: *Vikas Srivastava* <vikas.srivast...@one97.net> >> Date: Tue, Aug 23, 2011 at 7:26 PM >> Subject: Problem in hive >> To: user@hive.apache.org >> >> >> HI team, >> >> >> i m facing this problem. >> >> show tables is running fine but when i run below query. >> >> hive> select * from aircel_obd; >> FAILED: Hive Internal Error: java.lang.NullPointerException(null) >> java.lang.NullPointerException >> at >> org.apache.hadoop.hive.ql.metadata.Table.checkValidity(Table.java:162) >> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:886) >> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:787) >> at >> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:893) >> at >> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7203) >> at >> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:240) >> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:428) >> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336) >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:901) >> at >> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:253) >> at >> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:210) >> at >> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401) >> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:660) >> 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:156) >> >> >> -- >> With Regards >> Vikas Srivastava >> >> DWH & Analytics Team**** >> >> Mob:+91 9560885900 >> One97 | Let's get talking !**** >> >> ** ** >> >> >> >> >> -- >> With Regards >> Vikas Srivastava >> >> DWH & Analytics Team**** >> >> Mob:+91 9560885900 >> One97 | Let's get talking !**** >> >> ** ** >> > > > > -- > With Regards > Vikas Srivastava > > DWH & Analytics Team > Mob:+91 9560885900 > One97 | Let's get talking ! > >
