Apache zeppelin tutorial, error "sql interpreter not found"

apache-spark-sql apache-zeppelin
thomas legrand picture thomas legrand · Oct 20, 2015 · Viewed 9.4k times · Source

In the "Zeppelin tutorial" notebook, I can't use the %sql interpreter. It will output "sql interpreter not found". But the spark commands work fine, as well as %md and %sh.

Here's the log :

ERROR [2015-10-20 10:13:35,045] ({qtp885851948-51} NotebookServer.java[runParagraph]:615) - Exception from run org.apache.zeppelin.interpreter.InterpreterException: sql interpreter not found at org.apache.zeppelin.notebook.NoteInterpreterLoader.get(NoteInterpreterLoader.java:148) at org.apache.zeppelin.notebook.Note.run(Note.java:282) at org.apache.zeppelin.socket.NotebookServer.runParagraph(NotebookServer.java:613) at org.apache.zeppelin.socket.NotebookServer.onMessage(NotebookServer.java:126) at org.apache.zeppelin.socket.NotebookSocket.onMessage(NotebookSocket.java:56) at org.eclipse.jetty.websocket.WebSocketConnectionRFC6455$WSFrameHandler.onFrame(WebSocketConnectionRFC6455.java:835) at org.eclipse.jetty.websocket.WebSocketParserRFC6455.parseNext(WebSocketParserRFC6455.java:349) at org.eclipse.jetty.websocket.WebSocketConnectionRFC6455.handle(WebSocketConnectionRFC6455.java:225) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:745)

Answer

Merlijn Sebrechts picture Merlijn Sebrechts · Nov 6, 2015

I had the same error. The problem was that the spark interpreter was deselected. At the top of the tutorial page, open the gear icon and make sure "spark %spark..." is blue and click save.

The UI is a bit confusing here. All interpreters are selected (blue) by default. You just have to click "save"

Related questions

Remove Temporary Tables from Apache SQL Spark

I have registertemptable in Apache Spark using Zeppelin below: val hvacText = sc.textFile("...") case class Hvac(date: String, time: String, targettemp: Integer, actualtemp: Integer, buildingID: String) val hvac = hvacText.map(s => s.split(",")).filter(s => s(0) != "Date").map( …

Read More
Reading Avro File in Spark

I have read an avro file into spark RDD and need to conver that into a sql dataframe. how do I do that. This is what I did so far. import org.apache.avro.generic.GenericRecord import org.apache.avro.…

Read More
Scala and Spark UDF function

I made a simple UDF to convert or extract some values from a time field in a temptabl in spark. I register the function but when I call the function using sql it throws a NullPointerException. Below is my function …

Read More