You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Bill Kehoe <bu...@yahoo.com> on 2015/09/02 20:15:40 UTC
sql interpreter not found
Hoping someone can help.
I've successfully built zeppelin (on CentOS 6.6) and can execute the Scala %spark cell titled "Load Data Into Table" of the Tutorial notebook.
But when I try to execute any of the 3 %sql cells that query the "bank" table, I get "sql interpreter not found" errors.
I've included the relevant snippet of my logs/zeppelin-root-myhost.log file below.
Is there some configuration setting I need to set to get Spark SQL contexts to work?
I'm running in local mode but my host also has a spark 1.4 install (not sure if that has anything to do with the issue).
Stack trace from logs/zeppelin-root-myhost.log:
ERROR [2015-09-02 12:09:07,606] ({qtp1526310589-53} NotebookServer.java[runParagraph]:630) - Exception from runorg.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:278) at org.apache.zeppelin.socket.NotebookServer.runParagraph(NotebookServer.java:628) 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)
Re: sql interpreter not found
Posted by Bill <bu...@yahoo.com>.
I fast forward merged to https://github.com/apache/incubator-zeppelin/pull/270 , ran "mvn install" and all is working now.
I did review the Spark interpreter log after I first hit this issue but could see nothing obvious.
I'll post again if it comes back.
Thanks!
On Friday, September 4, 2015 5:17 AM, Alexander Bezzubov <ab...@nflabs.com> wrote:
Hi,
that is a bit wired, as there is no separate sql interpreter (it is spark one) - you check the interpreter bindings using wrench icon on the right and make sure spark-local is activated and is the first (default) one.
Can you also send spark interpret logs, they should be in a separate file, something like 'logs/zeppelin-interpreter-spark-root-myhost.log' ?
--Kind regards,Alex
On Thu, Sep 3, 2015 at 3:15 AM, Bill Kehoe <bu...@yahoo.com> wrote:
Hoping someone can help.
I've successfully built zeppelin (on CentOS 6.6) and can execute the Scala %spark cell titled "Load Data Into Table" of the Tutorial notebook.
But when I try to execute any of the 3 %sql cells that query the "bank" table, I get "sql interpreter not found" errors.
I've included the relevant snippet of my logs/zeppelin-root-myhost.log file below.
Is there some configuration setting I need to set to get Spark SQL contexts to work?
I'm running in local mode but my host also has a spark 1.4 install (not sure if that has anything to do with the issue).
Stack trace from logs/zeppelin-root-myhost.log:
ERROR [2015-09-02 12:09:07,606] ({qtp1526310589-53} NotebookServer.java[runParagraph]:630) - Exception from runorg.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:278) at org.apache.zeppelin.socket.NotebookServer.runParagraph(NotebookServer.java:628) 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)
--
--
Kind regards,
Alexander.
Re: sql interpreter not found
Posted by Alexander Bezzubov <ab...@nflabs.com>.
Hi,
that is a bit wired, as there is no separate sql interpreter (it is spark
one) - you check the interpreter bindings using wrench icon on the right
and make sure spark-local is activated and is the first (default) one.
Can you also send spark interpret logs, they should be in a separate file,
something like 'logs/zeppelin-interpreter-spark-root-myhost.log' ?
--
Kind regards,
Alex
On Thu, Sep 3, 2015 at 3:15 AM, Bill Kehoe <bu...@yahoo.com> wrote:
> Hoping someone can help.
>
> I've successfully built zeppelin (on CentOS 6.6) and can execute the Scala
> %spark cell titled "Load Data Into Table" of the Tutorial notebook.
>
> But when I try to execute any of the 3 %sql cells that query the "bank"
> table, I get "sql interpreter not found" errors.
>
> I've included the relevant snippet of my logs/zeppelin-root-myhost.log
> file below.
>
> Is there some configuration setting I need to set to get Spark SQL
> contexts to work?
>
> I'm running in local mode but my host also has a spark 1.4 install (not
> sure if that has anything to do with the issue).
>
> Stack trace from logs/zeppelin-root-myhost.log:
>
> ERROR [2015-09-02 12:09:07,606] ({qtp1526310589-53}
> NotebookServer.java[runParagraph]:630) - 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:278)
> at
> org.apache.zeppelin.socket.NotebookServer.runParagraph(NotebookServer.java:628)
> 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)
>
--
--
Kind regards,
Alexander.