Nandakishore Arvapaly created ZEPPELIN-2793: -----------------------------------------------
Summary: Error - java.lang.ClassNotFoundException: org.apache.zeppelin.jdbc.JDBCInterpreter Key: ZEPPELIN-2793 URL: https://issues.apache.org/jira/browse/ZEPPELIN-2793 Project: Zeppelin Issue Type: Bug Components: Interpreters, zeppelin-interpreter Affects Versions: 0.7.2 Reporter: Nandakishore Arvapaly My usecase includes reading data from Redshift cluster through Zeppelin. So when I create a redshift interpreter by specifying all required Redshift credentials and url and by placing Redshift jar in /jdbc/ directory, I could able to connect to redshift. But when I create a new redshift interpreter through REST API POST and use it to new notebook, I get below error. java.lang.ClassNotFoundException: org.apache.zeppelin.jdbc.JDBCInterpreter java.lang.ClassNotFoundException: org.apache.zeppelin.jdbc.JDBCInterpreter at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:814) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at org.apache.zeppelin.interpreter.InterpreterFactory.createRepl(InterpreterFactory.java:258) at org.apache.zeppelin.interpreter.InterpreterFactory.createInterpretersForNote(InterpreterFactory.java:206) at org.apache.zeppelin.interpreter.InterpreterFactory.createOrGetInterpreterList(InterpreterFactory.java:332) at org.apache.zeppelin.interpreter.InterpreterFactory.getInterpreter(InterpreterFactory.java:395) at org.apache.zeppelin.notebook.Note.run(Note.java:600) at org.apache.zeppelin.socket.NotebookServer.persistAndExecuteSingleParagraph(NotebookServer.java:1641) at org.apache.zeppelin.socket.NotebookServer.runParagraph(NotebookServer.java:1615) at org.apache.zeppelin.socket.NotebookServer.onMessage(NotebookServer.java:265) at org.apache.zeppelin.socket.NotebookSocket.onWebSocketText(NotebookSocket.java:59) at org.eclipse.jetty.websocket.common.events.JettyListenerEventDriver.onTextMessage(JettyListenerEventDriver.java:128) at org.eclipse.jetty.websocket.common.message.SimpleTextMessage.messageComplete(SimpleTextMessage.java:69) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.appendMessage(AbstractEventDriver.java:65) at org.eclipse.jetty.websocket.common.events.JettyListenerEventDriver.onTextFrame(JettyListenerEventDriver.java:122) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:161) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:309) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:214) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:220) at org.eclipse.jetty.websocket.common.Parser.parse(Parser.java:258) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.readParse(AbstractWebSocketConnection.java:632) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:480) at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:748) ___________________________________________________ I used CURL command to create new interpreter. And the JSON file has following contents. { "name": "redshift1", "group": "jdbc", "properties": { "default.password": "redshift-password", "zeppelin.jdbc.auth.type": "", "common.max_count": "1000", "zeppelin.jdbc.principal": "", "default.user": "redshift-user", "default.driver": "com.amazon.redshift.jdbc42.Driver", "default.url": "jdbc url", "zeppelin.jdbc.keytab.location": "", "zeppelin.jdbc.concurrent.use": "true", "zeppelin.jdbc.concurrent.max_connection": "10", "zeppelin.interpreter.output.limit": "102400" }, "interpreterGroup": [{ "name": "sql", "class": "org.apache.zeppelin.jdbc.JDBCInterpreter", "defaultInterpreter": false, "editor": { "language": "sql", "editOnDblClick": false } } ], "dependencies": [ { "groupArtifactVersion": "com.amazonaws:aws-java-sdk-redshift:1.11.51", "local": false }, { "groupArtifactVersion": "/home/ec2-user/zeppelin-0.7.2-bin-all/interpreter/jdbc/RedshiftJDBC42-1.2.1.1001.jar", "local": false } ] } Please let me know where i'm doing it wrong. -- This message was sent by Atlassian JIRA (v6.4.14#64029)