yes, the class path is set
ubuntu@ip-10-20-1-64:~/test/build/zeppelin/bin$ ps aux | grep
RemoteInterpreterServer
ubuntu 2207 3.9 0.5 3802124 93212 pts/0 Sl 13:56 0:00
/usr/local/java/jdk1.8.0_144/bin/java -Dfile.encoding=UTF-8
-Dlog4j.configuration=file:///home/ubuntu/test/build/zeppelin/conf/log4j.properties
-Dzeppelin.log.file=/home/ubuntu/test/build/zeppelin/logs/zeppelin-interpreter-jdbc-jdbc-ubuntu-ip-10-20-1-64.log
-Xms1024m -Xmx1024m -XX:MaxPermSize=512m -cp :/
*home/ubuntu/test/build/zeppelin/interpreter/jdbc/**:/home/ubuntu/test/build/zeppelin/zeppelin-interpreter/target/lib/*::/home/ubuntu/test/build/zeppelin/zeppelin-interpreter/target/classes:/home/ubuntu/test/build/zeppelin/zeppelin-interpreter/target/test-classes:/home/ubuntu/test/build/zeppelin/zeppelin-zengine/target/test-classes
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer 10.20.1.64
34717
ubuntu 2248 0.0 0.0 10472 936 pts/0 S+ 13:57 0:00 grep
--color=auto RemoteInterpreterServer
On Wed, Oct 18, 2017 at 7:05 PM, Jeff Zhang <zjf...@gmail.com> wrote:
>
> 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)
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>
