You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Vikas Srivastava <vi...@one97.net> on 2011/08/23 15:56:19 UTC
Problem in hive
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 !
Fwd: Problem in hive
Posted by Vikas Srivastava <vi...@one97.net>.
need help on this
---------- Forwarded message ----------
From: Vikas Srivastava <vi...@one97.net>
Date: Thu, Aug 25, 2011 at 6:37 PM
Subject: Re: Problem in hive
To: user@hive.apache.org
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.srivastava@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 <ha...@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.srivastava@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 <ch...@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* <vi...@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 !
--
With Regards
Vikas Srivastava
DWH & Analytics Team
Mob:+91 9560885900
One97 | Let's get talking !
Re: Problem in hive
Posted by Vikas Srivastava <vi...@one97.net>.
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.srivastava@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 <ha...@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.srivastava@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 <ch...@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* <vi...@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 !
Re: Problem in hive
Posted by Vikas Srivastava <vi...@one97.net>.
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 <ha...@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.srivastava@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 <ch...@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* <vi...@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 !
Re: Problem in hive
Posted by Ashutosh Chauhan <ha...@apache.org>.
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
<vi...@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 <ch...@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* <vi...@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 !
>
>
Re: Problem in hive
Posted by Vikas Srivastava <vi...@one97.net>.
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 <ch...@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* <vi...@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 !
Fwd: Problem in hive
Posted by Vikas Srivastava <vi...@one97.net>.
---------- Forwarded message ----------
From: Vikas Srivastava <vi...@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 !