You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Prabhu GS <pp...@gmail.com> on 2016/01/22 09:45:58 UTC
Null pointer exception in Hive interpreter when using aggregate functions
Hi team,
I cloned Zeppelin from https://github.com/apache/incubator-zeppelin.git and
built from source and installed it locally.
I created a table using the Hive interpreter,
%hive
create table test (id int, name string)
Then inserted a few rows successfully into the table.
%hive
select * from test
works fine.
But the below queries(run separately) throw null pointer exceptions:
%hive
select count(*) from test
%hive
select id, count(id) from test group by id
throw the below exception,
java.lang.NullPointerException
at
org.apache.zeppelin.hive.HiveInterpreter.getConnection(HiveInterpreter.java:184)
at
org.apache.zeppelin.hive.HiveInterpreter.getStatement(HiveInterpreter.java:204)
at
org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:233)
at
org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:328)
at
org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93)
at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:302)
at org.apache.zeppelin.scheduler.Job.run(Job.java:171)
at
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Please help me out.
Regards
Re: Null pointer exception in Hive interpreter when using aggregate functions
Posted by Prabhu GS <pp...@gmail.com>.
Thanks,
The commit
https://github.com/vgmartinez/incubator-zeppelin/commit/05fa23f8c5112b4e60d0ff1685565af31e5e8a44
works well.
Regards
Prabhu
On Sat, Jan 23, 2016 at 3:52 AM, Victor Manuel Garcia <
victor.garcia@beeva.com> wrote:
> Hi Vinay,
>
> This bug is fixed in https://github.com/apache/incubator-zeppelin/pull/668
>
> 2016-01-22 23:17 GMT+01:00 Vinay Shukla <vi...@gmail.com>:
>
>> Prabhu,
>>
>> Filed https://issues.apache.org/jira/browse/ZEPPELIN-629 to track this.
>>
>> From looking at the code, it appears the the driver (class) may not be
>> set.
>>
>> Can you post the properties set on the Hive interpreter.
>>
>> Though you also appear to be saying that the Hive interpreter works
>> initially before you run into this problem, can you clarify?
>>
>> Thanks,
>> Vinay
>>
>>
>>
>> On Fri, Jan 22, 2016 at 12:45 AM, Prabhu GS <pp...@gmail.com> wrote:
>>
>>> Hi team,
>>>
>>>
>>> I cloned Zeppelin from https://github.com/apache/incubator-zeppelin.git
>>> and built from source and installed it locally.
>>>
>>> I created a table using the Hive interpreter,
>>>
>>> %hive
>>> create table test (id int, name string)
>>>
>>> Then inserted a few rows successfully into the table.
>>>
>>> %hive
>>> select * from test
>>>
>>> works fine.
>>>
>>> But the below queries(run separately) throw null pointer exceptions:
>>>
>>> %hive
>>> select count(*) from test
>>>
>>>
>>> %hive
>>> select id, count(id) from test group by id
>>>
>>>
>>>
>>> throw the below exception,
>>>
>>>
>>> java.lang.NullPointerException
>>> at
>>> org.apache.zeppelin.hive.HiveInterpreter.getConnection(HiveInterpreter.java:184)
>>> at
>>> org.apache.zeppelin.hive.HiveInterpreter.getStatement(HiveInterpreter.java:204)
>>> at
>>> org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:233)
>>> at
>>> org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:328)
>>> at
>>> org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57)
>>> at
>>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93)
>>> at
>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:302)
>>> at org.apache.zeppelin.scheduler.Job.run(Job.java:171)
>>> at
>>> org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
>>> at
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>> at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
>>> at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>> at java.lang.Thread.run(Thread.java:745)
>>>
>>>
>>> Please help me out.
>>>
>>>
>>> Regards
>>>
>>
>>
>
>
> --
> *Victor Manuel Garcia Martinez*
> *Software Engeenier
> *
>
> *+34 672104297 | victor.garcia@beeva.com <ma...@beeva.com>*
> * | victormanuel.garcia.martinez@bbva.com
> <ma...@bbva.com>*
>
>
>
> <http://www.beeva.com/>
>
>
>
Re: Null pointer exception in Hive interpreter when using aggregate functions
Posted by Victor Manuel Garcia <vi...@beeva.com>.
Hi Vinay,
This bug is fixed in https://github.com/apache/incubator-zeppelin/pull/668
2016-01-22 23:17 GMT+01:00 Vinay Shukla <vi...@gmail.com>:
> Prabhu,
>
> Filed https://issues.apache.org/jira/browse/ZEPPELIN-629 to track this.
>
> From looking at the code, it appears the the driver (class) may not be
> set.
>
> Can you post the properties set on the Hive interpreter.
>
> Though you also appear to be saying that the Hive interpreter works
> initially before you run into this problem, can you clarify?
>
> Thanks,
> Vinay
>
>
>
> On Fri, Jan 22, 2016 at 12:45 AM, Prabhu GS <pp...@gmail.com> wrote:
>
>> Hi team,
>>
>>
>> I cloned Zeppelin from https://github.com/apache/incubator-zeppelin.git
>> and built from source and installed it locally.
>>
>> I created a table using the Hive interpreter,
>>
>> %hive
>> create table test (id int, name string)
>>
>> Then inserted a few rows successfully into the table.
>>
>> %hive
>> select * from test
>>
>> works fine.
>>
>> But the below queries(run separately) throw null pointer exceptions:
>>
>> %hive
>> select count(*) from test
>>
>>
>> %hive
>> select id, count(id) from test group by id
>>
>>
>>
>> throw the below exception,
>>
>>
>> java.lang.NullPointerException
>> at
>> org.apache.zeppelin.hive.HiveInterpreter.getConnection(HiveInterpreter.java:184)
>> at
>> org.apache.zeppelin.hive.HiveInterpreter.getStatement(HiveInterpreter.java:204)
>> at
>> org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:233)
>> at
>> org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:328)
>> at
>> org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57)
>> at
>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93)
>> at
>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:302)
>> at org.apache.zeppelin.scheduler.Job.run(Job.java:171)
>> at
>> org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
>> at
>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
>> at
>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
>> at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>> at java.lang.Thread.run(Thread.java:745)
>>
>>
>> Please help me out.
>>
>>
>> Regards
>>
>
>
--
*Victor Manuel Garcia Martinez*
*Software Engeenier
*
*+34 672104297 | victor.garcia@beeva.com <ma...@beeva.com>*
* | victormanuel.garcia.martinez@bbva.com
<ma...@bbva.com>*
<http://www.beeva.com/>
Re: Null pointer exception in Hive interpreter when using aggregate functions
Posted by Vinay Shukla <vi...@gmail.com>.
Prabhu,
Filed https://issues.apache.org/jira/browse/ZEPPELIN-629 to track this.
>From looking at the code, it appears the the driver (class) may not be set.
Can you post the properties set on the Hive interpreter.
Though you also appear to be saying that the Hive interpreter works
initially before you run into this problem, can you clarify?
Thanks,
Vinay
On Fri, Jan 22, 2016 at 12:45 AM, Prabhu GS <pp...@gmail.com> wrote:
> Hi team,
>
>
> I cloned Zeppelin from https://github.com/apache/incubator-zeppelin.git
> and built from source and installed it locally.
>
> I created a table using the Hive interpreter,
>
> %hive
> create table test (id int, name string)
>
> Then inserted a few rows successfully into the table.
>
> %hive
> select * from test
>
> works fine.
>
> But the below queries(run separately) throw null pointer exceptions:
>
> %hive
> select count(*) from test
>
>
> %hive
> select id, count(id) from test group by id
>
>
>
> throw the below exception,
>
>
> java.lang.NullPointerException
> at
> org.apache.zeppelin.hive.HiveInterpreter.getConnection(HiveInterpreter.java:184)
> at
> org.apache.zeppelin.hive.HiveInterpreter.getStatement(HiveInterpreter.java:204)
> at
> org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:233)
> at
> org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:328)
> at
> org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57)
> at
> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93)
> at
> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:302)
> at org.apache.zeppelin.scheduler.Job.run(Job.java:171)
> at
> org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
>
>
> Please help me out.
>
>
> Regards
>