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)

Reply via email to