Support Questions
Find answers, ask questions, and share your expertise

Some SQL functions (Aggregation functions,group by clause) are not working in zepelline(Hive) ?

Expert Contributor

Hello,

I am new to a zepelline and trying to execute some hive queries using zepelline UI but getting error

Query:

select max(airline_data.dep_delay) from airline_data

Error:

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:295) 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)

2 REPLIES 2

this is the known issue with zepelline https://issues.apache.org/jira/browse/ZEPPELIN-629

encountered a similar issue. trick was to have the interpreter already set and start your statement on the 2nd line, leaving first line null:

https://community.hortonworks.com/questions/22758/zeppelin-hdp-24-sparksql-aggregate-functions-faili...