[ZEPPELIN-1675] Livy-interpreter: Execution of sql throws null pointer exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.7.0
• Component/s: livy-interpreter

Environment

OS: Linux

• Assignee: Unassigned
• Reporter: Praveen Kanamarlapudi
• Created: 16/Nov/16 21:21
• Updated: 17/Nov/16 18:51
• Resolved: 17/Nov/16 18:51

Description

Livy interpreter is not starting a session when I directly call "%livy.sql" magic. Everytime I have to start a session using scala magic and then I need to run sql using sql magic.

It would be better, if livy.sql magic automatically starts a session for me, even if there is no active livy session.

Steps to reproduce the issue:

1. Restart the livy interpreter.
2. Run a sql as follows

%livy.sql
show tables

In the log we can see an error message as below.

 INFO [2016-11-16 13:05:51,665] ({pool-1-thread-2} RemoteInterpreterServer.java[createInterpreter]:181) - Instantiate interpreter org.apache.zeppelin.livy.LivySparkSQLInterpreter
ERROR [2016-11-16 13:05:51,676] ({pool-1-thread-4} TThreadPoolServer.java[run]:296) - Error occurred during processing of message.
java.lang.NullPointerException
        at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer.getStatus(RemoteInterpreterServer.java:550)
        at org.apache.zeppelin.interpreter.thrift.RemoteInterpreterService$Processor$getStatus.getResult(RemoteInterpreterService.java:1782)
        at org.apache.zeppelin.interpreter.thrift.RemoteInterpreterService$Processor$getStatus.getResult(RemoteInterpreterService.java:1767)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
 INFO [2016-11-16 13:05:51,694] ({pool-1-thread-2} RemoteInterpreterServer.java[createInterpreter]:181) - Instantiate interpreter org.apache.zeppelin.livy.LivySparkInterpreter