Then it might due to jdbc interpreter jar is not in the classpath of
interpreter process.
Try the following command to check the classpath
ps aux | grep RemoteInterpreterServer
chethan kp <chethankputta...@gmail.com>于2017年10月18日周三 下午9:20写道：
> I checked , the package looks fine.
>
>
> created: META-INF/
> inflated: META-INF/MANIFEST.MF
> created: org/
> created: org/apache/
> created: org/apache/zeppelin/
> created: org/apache/zeppelin/jdbc/
> created: org/apache/zeppelin/jdbc/security/
> inflated: META-INF/NOTICE
> inflated: META-INF/LICENSE
> inflated: META-INF/DEPENDENCIES
> inflated: git.properties
> inflated: interpreter-setting.json
> inflated: org/apache/zeppelin/jdbc/SqlCompleter.class
> inflated: org/apache/zeppelin/jdbc/JDBCInterpreter$2.class
> inflated: org/apache/zeppelin/jdbc/JDBCUserConfigurations.class
> inflated: org/apache/zeppelin/jdbc/SqlCompleter$CursorArgument.class
> inflated: org/apache/zeppelin/jdbc/JDBCInterpreter$3.class
> inflated: org/apache/zeppelin/jdbc/security/JDBCSecurityImpl$1.class
> inflated: org/apache/zeppelin/jdbc/security/JDBCSecurityImpl.class
> inflated: org/apache/zeppelin/jdbc/SqlCompleter$1.class
> inflated: org/apache/zeppelin/jdbc/JDBCInterpreter$1.class
> inflated: org/apache/zeppelin/jdbc/JDBCInterpreter.class
> inflated: postgresql-native-driver-sql.keywords
> inflated: ansi.sql.keywords
> created: META-INF/maven/
> created: META-INF/maven/org.apache.zeppelin/
> created: META-INF/maven/org.apache.zeppelin/zeppelin-jdbc/
> inflated: META-INF/maven/org.apache.zeppelin/zeppelin-jdbc/pom.xml
> inflated: META-INF/maven/org.apache.zeppelin/zeppelin-jdbc/pom.properties
>
>
> On Wed, Oct 18, 2017 at 6:32 PM, Jeff Zhang <zjf...@gmail.com> wrote:
>
>>
>> This file might be corrupted. Use command 'jar xvf <jar_file>' to check
>> the file contents.
>>
>>
>> chethan kp <chethankputta...@gmail.com>于2017年10月18日周三 下午8:53写道：
>>
>>> Hi,
>>> I checked *zeppelin-jdbc-0.8.0-**SNAPSHOT.jar* , it is exists in the
>>> path ZEPPELIN_HOME/interpreter/jdbc/zeppelin-jdbc-0.8.0-SNAPSHOT.jar
>>>
>>> is it require to copy this library to some other path?
>>>
>>> On Wed, Oct 18, 2017 at 6:13 PM, Jeff Zhang <zjf...@gmail.com> wrote:
>>>
>>>>
>>>> It is clear the zeppelin jdbc jar is missing. Check the jar under
>>>> ZEPPELIN_HOME/interpreter/jdbc/zeppelin-jdbc-0.8.0-SNAPSHOT.jar
>>>>
>>>>
>>>> chethan kp <chethankputta...@gmail.com>于2017年10月18日周三 下午8:37写道：
>>>>
>>>>> Hi,
>>>>> Below is the interpreter log, look like JDBCInterpreter class not
>>>>> found but I compiled zeppelin 0.8.0 using the steps provide
>>>>>
>>>>>
>>>>>
>>>>> INFO [2017-10-18 11:22:30,817] ({Thread-0}
>>>>> RemoteInterpreterServer.java[run]:199) - Starting remote interpreter
>>>>> server
>>>>> on port 55333
>>>>> INFO [2017-10-18 11:22:31,824] ({Thread-1}
>>>>> RemoteInterpreterUtils.java[registerInterpreter]:155) - callbackHost:
>>>>> 10.20.1.64, callbackPort: 47839, callbackInfo:
>>>>> CallbackInfo(host:10.20.1.64, port:55333)
>>>>> ERROR [2017-10-18 11:22:32,014] ({pool-1-thread-1}
>>>>> RemoteInterpreterServer.java[createInterpreter]:308) -
>>>>> 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
>>>>> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335)
>>>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>>>>> at java.lang.Class.forName0(Native Method)
>>>>> at java.lang.Class.forName(Class.java:264)
>>>>> at
>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer.createInterpreter(RemoteInterpreterServer.java:291)
>>>>> at
>>>>> org.apache.zeppelin.interpreter.thrift.RemoteInterpreterService$Processor$createInterpreter.getResult(RemoteInterpreterService.java:1799)
>>>>> at
>>>>> org.apache.zeppelin.interpreter.thrift.RemoteInterpreterService$Processor$createInterpreter.getResult(RemoteInterpreterService.java:1784)
>>>>> at
>>>>> org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
>>>>> at
>>>>> org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
>>>>> at
>>>>> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285)
>>>>> at
>>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>>>> at
>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>>>>
>>>>> On Wed, Oct 18, 2017 at 5:57 PM, Jeff Zhang <zjf...@gmail.com> wrote:
>>>>>
>>>>>> This is zeppelin server log, there's another interpreter log file.
>>>>>>
>>>>>>
>>>>>>
>>>>>> chethan kp <chethankputta...@gmail.com>于2017年10月18日周三 下午8:25写道：
>>>>>>
>>>>>>> I checked the log,
>>>>>>>
>>>>>>> log also does not contain more info
>>>>>>>
>>>>>>> INFO [2017-10-18 11:22:30,487] ({pool-2-thread-2}
>>>>>>> SchedulerFactory.java[jobStarted]:109) - Job 20171018-112147_1588161382
>>>>>>> started by scheduler
>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter-shared_session
>>>>>>> INFO [2017-10-18 11:22:30,488] ({pool-2-thread-2}
>>>>>>> Paragraph.java[jobRun]:399) - run paragraph 20171018-112147_1588161382
>>>>>>> using phoenix
>>>>>>> RemoteInterpreter_org.apache.zeppelin.jdbc.JDBCInterpreter_shared_session
>>>>>>> INFO [2017-10-18 11:22:30,488] ({pool-2-thread-2}
>>>>>>> ManagedInterpreterGroup.java[getOrCreateInterpreterProcess]:58) - Create
>>>>>>> InterperterProcess for InterpreterGroup: 2CYPJGBD9:shared_process
>>>>>>> INFO [2017-10-18 11:22:30,489] ({pool-2-thread-2}
>>>>>>> ShellScriptLauncher.java[launch]:48) - Launching Interpreter: phoenix
>>>>>>> INFO [2017-10-18 11:22:30,499] ({pool-2-thread-2}
>>>>>>> RemoteInterpreterManagedProcess.java[start]:104) - Choose port 38318 for
>>>>>>> RemoteInterpreterProcess
>>>>>>> INFO [2017-10-18 11:22:30,522] ({pool-2-thread-2}
>>>>>>> RemoteInterpreterManagedProcess.java[start]:111) - Thrift server for
>>>>>>> callback will start. Port: 47839
>>>>>>> INFO [2017-10-18 11:22:30,535] ({pool-2-thread-2}
>>>>>>> RemoteInterpreterManagedProcess.java[start]:186) - Run interpreter
>>>>>>> process
>>>>>>> [/home/ubuntu/node/build/zeppelin/bin/interpreter.sh, -d,
>>>>>>> /home/ubuntu/node/build/zeppelin/interpreter/phoenix, -c, 10.20.1.64,
>>>>>>> -p,
>>>>>>> 47839, -l, /home/ubuntu/node/build/zeppelin/local-repo/2CYPJGBD9, -g,
>>>>>>> phoenix]
>>>>>>> INFO [2017-10-18 11:22:31,844] ({pool-200-thread-1}
>>>>>>> RemoteInterpreterManagedProcess.java[callback]:119) - Registered:
>>>>>>> CallbackInfo(host:10.20.1.64, port:55333)
>>>>>>> INFO [2017-10-18 11:22:31,891] ({pool-2-thread-2}
>>>>>>> RemoteInterpreter.java[call]:163) - Create RemoteInterpreter
>>>>>>> org.apache.zeppelin.jdbc.JDBCInterpreter
>>>>>>> ERROR [2017-10-18 11:22:32,020] ({pool-2-thread-2}
>>>>>>> Job.java[run]:184) - Job failed
>>>>>>> java.lang.RuntimeException: org.apache.thrift.TApplicationException:
>>>>>>> Internal error processing createInterpreter
>>>>>>> at
>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterProcess.callRemoteFunction(RemoteInterpreterProcess.java:145)
>>>>>>> at
>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter.internal_create(RemoteInterpreter.java:160)
>>>>>>> at
>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter.open(RemoteInterpreter.java:129)
>>>>>>> at
>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter.getFormType(RemoteInterpreter.java:287)
>>>>>>> at
>>>>>>> org.apache.zeppelin.notebook.Paragraph.jobRun(Paragraph.java:425)
>>>>>>>
>>>>>>> On Wed, Oct 18, 2017 at 5:24 PM, Jeff Zhang <zjf...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> Please check the interpreter log
>>>>>>>>
>>>>>>>>
>>>>>>>> chethan kp <chethankputta...@gmail.com>于2017年10月18日周三 下午7:41写道：
>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> I tried to install new zeppelin i.e 0.8.0 version, I followed this
>>>>>>>>> <https://zeppelin.apache.org/docs/0.8.0-SNAPSHOT/setup/deployment/flink_and_spark_cluster.html>
>>>>>>>>> link
>>>>>>>>> to install zeppelin .
>>>>>>>>>
>>>>>>>>> I used this command to build
>>>>>>>>>
>>>>>>>>> mvn clean package -DskipTests -Pspark-1.6 -Dflink.version=1.1.3
>>>>>>>>> -Pscala-2.11
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Since I wanted phoenix interpreter, I added interpreter with the
>>>>>>>>> help of guide given in here
>>>>>>>>> <https://zeppelin.apache.org/docs/0.7.0/interpreter/jdbc.html>.
>>>>>>>>>
>>>>>>>>> When I run the the below paragraph I got the below error
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> %phoenix
>>>>>>>>> select * from "mytable"
>>>>>>>>>
>>>>>>>>> org.apache.thrift.TApplicationException: Internal error processing
>>>>>>>>> createInterpreter
>>>>>>>>> at
>>>>>>>>> org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
>>>>>>>>> at
>>>>>>>>> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.interpreter.thrift.RemoteInterpreterService$Client.recv_createInterpreter(RemoteInterpreterService.java:209)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.interpreter.thrift.RemoteInterpreterService$Client.createInterpreter(RemoteInterpreterService.java:192)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter$2.call(RemoteInterpreter.java:164)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter$2.call(RemoteInterpreter.java:160)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterProcess.callRemoteFunction(RemoteInterpreterProcess.java:141)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter.internal_create(RemoteInterpreter.java:160)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter.open(RemoteInterpreter.java:129)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter.getFormType(RemoteInterpreter.java:287)
>>>>>>>>> at org.apache.zeppelin.notebook.Paragraph.jobRun(Paragraph.java:425)
>>>>>>>>> at org.apache.zeppelin.scheduler.Job.run(Job.java:182)
>>>>>>>>> at
>>>>>>>>> org.apache.zeppelin.scheduler.RemoteScheduler$JobRunner.run(RemoteScheduler.java:307)
>>>>>>>>> at
>>>>>>>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>>>>>>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>>>>>>>> at
>>>>>>>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
>>>>>>>>> at
>>>>>>>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
>>>>>>>>> at
>>>>>>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>>>>>>>>> at
>>>>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>>>>>>>>> at java.lang.Thread.run(Thread.java:748)
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>>>
>
