Hey Ashu!!1 i have given full permission to hadoop user on new server(A) with user name and password.
it can only read those tables made by this server(A) and desc them, and from other server(B) we cant be able to read tables created by this server(A). regards Vikas Srivastava On Thu, Aug 25, 2011 at 4:02 PM, Vikas Srivastava < vikas.srivast...@one97.net> wrote: > hey ashutosh, > > thanks for reply.. > > the output of that is > > *Failed with exception null > FAILED: Execution Error, return code 1 from org.apache.hado** > op.hive.ql.exec**.DDLTask* > > regards > Vikas Srivastava > > > > > On Thu, Aug 25, 2011 at 4:52 AM, Ashutosh Chauhan <hashut...@apache.org>wrote: > >> 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 ! >>> >>> >> > > > -- > 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 !