question Re: zeppelin tutorial, "hive interpreter not found" in Archives of Support Questions (Read Only)

zeppelin tutorial, "hive interpreter not found"

michael_klybor — Mon, 02 May 2016 22:40:04 GMT

I see a green "connected" icon.

I check the zeppelin interpreter page, and hive listed.

I restart it from that page. I can run the hive cli. I check the yarn application list and there is nothing running.

when I try to run simple query from the tutorial

%hive

SELECT * FROM finalresult

I get "hive interpreter not found"

stack trace from the zeppelin log file:

ERROR [2016-05-02 15:27:45,626] ({qtp61918702-31} NotebookServer.java[afterStatusChange]:800) - Error org.apache.zeppelin.interpreter.InterpreterException: hive interpreter not found at org.apache.zeppelin.notebook.NoteInterpreterLoader.get(NoteInterpreterLoader.java:148) at org.apache.zeppelin.notebook.Note.run(Note.java:368) at org.apache.zeppelin.socket.NotebookServer.runParagraph(NotebookServer.java:711) at org.apache.zeppelin.socket.NotebookServer.onMessage(NotebookServer.java:143) 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: zeppelin tutorial, "hive interpreter not found"

nmaillard1 — Mon, 02 May 2016 22:47:17 GMT

can you make sure tt the top of the tutorial page, open the gear icon and make sure "hive %hive..." is blue and click save. If not can you share the description and config of your hive interpreter

Re: zeppelin tutorial, "hive interpreter not found"

michael_klybor — Mon, 02 May 2016 23:16:23 GMT

@nmaillard

thanks. checked as you say and all is as expected. tried again and got the same error. same stack trace.

If this helps, I can run spark from within zeppelin. Problem seems to be only with hive interpreter.

Re: zeppelin tutorial, "hive interpreter not found"

michael_klybor — Tue, 03 May 2016 01:54:32 GMT

solved it. the problem is introduced by copy/paste text from the tutorial page. it must introduce some garbage characters. someone else noted this as a problem with starting one of the other interpreters.

Re: zeppelin tutorial, "hive interpreter not found"

Mariraj — Thu, 12 May 2016 11:02:18 GMT

Thanks for the post. I faced similar issue and thought that something is wrong with the Interpreter settings. But it was due to some issue while copying the commands from the Tutorial site to Zeppelin workbook.

Re: zeppelin tutorial, "hive interpreter not found"

fardin_behboudi — Tue, 17 May 2016 05:43:24 GMT

yes i had this problem also , if you type the code it will run but in copy paste there is a problem ,

how can i ask tutorials support to fix it ? or even mention that you have to type it yourself

Re: zeppelin tutorial, "hive interpreter not found"

Former Member — Thu, 19 May 2016 06:12:06 GMT

@Fardin Behboudi Vaighan there was an issue with the script that we use to post the tutorial. It has been updated so this issue should be resolved. Please let us know if this is not the case. @jmedel

Re: zeppelin tutorial, "hive interpreter not found"

vakana54 — Tue, 14 Jun 2016 19:29:35 GMT

It is working, thanks.

Re: zeppelin tutorial, "hive interpreter not found"

daniel_buskirk — Mon, 17 Apr 2017 11:21:40 GMT

I does seem a little unkind to throw a curveball to people using a tutorial. But the problem seems to be carriage returns that come along for the ride during the copy and paste operation. If you delete 'em, it seems to work fine.