The interpreter log is in another log file, something like
zeppelin-interpreter-{interpreter-name}.log
Steve Fox <steve96....@gmail.com>于2018年10月20日周六 上午3:33写道：
> Additionally, the python 2.7.5 and 3.6.5 environment is good working, but
> the anaconda 3.6.5 is not working.
>
> I'm really hard on what's wrong.
> Please help me!
>
> Thank you very much.
>
>
>
> 2018년 10월 20일 (토) 오전 12:37, Steve Fox <steve96....@gmail.com>님이 작성:
>
>> This is log of zeppelin log (server , interpreter)
>>
>> ----------------------------------------------
>> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>> [server log]
>> INFO [2018-10-19 15:25:22,244] ({qtp2054574951-13}
>> VFSNotebookRepo.java[save]:196) - Saving note:2DVU2DMPM
>> INFO [2018-10-19 15:25:22,248] ({pool-2-thread-3}
>> SchedulerFactory.java[jobStarted]:109) - Job 20181018-023104_253425563
>> started by scheduler
>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter-python:k91159664:-shared_session
>> INFO [2018-10-19 15:25:22,249] ({pool-2-thread-3}
>> Paragraph.java[jobRun]:380) - Run paragraph [paragraph_id:
>> 20181018-023104_253425563, interpreter: python.sql, note_id: 2DVU2DMPM,
>> user: k91159664]
>> WARN [2018-10-19 15:25:22,258] ({pool-2-thread-3}
>> NotebookServer.java[afterStatusChange]:2344) - Job
>> 20181018-023104_253425563 is finished, status: ERROR, exception: null,
>> result: %text java.lang.NullPointerException
>> at
>> org.apache.zeppelin.python.IPythonInterpreter.interpret(IPythonInterpreter.java:331)
>> at
>> org.apache.zeppelin.python.PythonInterpreter.interpret(PythonInterpreter.java:371)
>> at
>> org.apache.zeppelin.python.PythonInterpreter.bootStrapInterpreter(PythonInterpreter.java:557)
>> at
>> org.apache.zeppelin.python.PythonInterpreterPandasSql.open(PythonInterpreterPandasSql.java:73)
>> at
>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.open(LazyOpenInterpreter.java:69)
>> at
>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:617)
>> at org.apache.zeppelin.scheduler.Job.run(Job.java:188)
>> at
>> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:140)
>> 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)
>>
>> INFO [2018-10-19 15:25:22,278] ({pool-2-thread-3}
>> VFSNotebookRepo.java[save]:196) - Saving note:2DVU2DMPM
>> INFO [2018-10-19 15:25:22,280] ({pool-2-thread-3}
>> SchedulerFactory.java[jobFinished]:115) - Job 20181018-023104_253425563
>> finished by scheduler
>> org.apache.zeppelin.interpreter.remote.RemoteInterpreter-python:k91159664:-shared_session
>>
>>
>> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>> [interpreter-python.log]
>> INFO [2018-10-19 15:25:22,250] ({pool-2-thread-7}
>> SchedulerFactory.java[jobStarted]:109) - Job 20181018-023104_253425563
>> started by scheduler interpreter_128873761
>> INFO [2018-10-19 15:25:22,250] ({pool-2-thread-7}
>> PythonInterpreterPandasSql.java[open]:67) - Open Python SQL interpreter
>> instance: org.apache.zeppelin.python.PythonInterpreterPandasSql@7ae7521
>> INFO [2018-10-19 15:25:22,250] ({pool-2-thread-7}
>> PythonInterpreterPandasSql.java[open]:70) - Bootstrap
>> org.apache.zeppelin.python.PythonInterpreterPandasSql@7ae7521
>> interpreter with /python/bootstrap_sql.py
>> ERROR [2018-10-19 15:25:22,251] ({pool-2-thread-7} Job.java[run]:190) -
>> Job failed
>> java.lang.NullPointerException
>> at
>> org.apache.zeppelin.python.IPythonInterpreter.interpret(IPythonInterpreter.java:331)
>> at
>> org.apache.zeppelin.python.PythonInterpreter.interpret(PythonInterpreter.java:371)
>> at
>> org.apache.zeppelin.python.PythonInterpreter.bootStrapInterpreter(PythonInterpreter.java:557)
>> at
>> org.apache.zeppelin.python.PythonInterpreterPandasSql.open(PythonInterpreterPandasSql.java:73)
>> at
>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.open(LazyOpenInterpreter.java:69)
>> at
>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:617)
>> at org.apache.zeppelin.scheduler.Job.run(Job.java:188)
>> at
>> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:140)
>> 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)
>> INFO [2018-10-19 15:25:22,252] ({pool-2-thread-7}
>> SchedulerFactory.java[jobFinished]:115) - Job 20181018-023104_253425563
>> finished by scheduler interpreter_128873761
>>
>>
>>
>>
>>
>> 2018년 10월 19일 (금) 오후 11:50, Steve Fox <steve96....@gmail.com>님이 작성:
>>
>>> Thank you for reply.
>>>
>>> I can only see the server logs of now. Where can I find a full stacktrce?
>>>
>>> Thank you very much.
>>>
>>> 2018년 10월 19일 금요일, Jeff Zhang<zjf...@gmail.com>님이 작성한 메시지:
>>>
>>>>
>>>> Could you paste the full stacktrace ?
>>>>
>>>>
>>>> Steve Fox <steve96....@gmail.com>于2018年10月19日周五 下午9:20写道：
>>>>
>>>>> Hi zeppelin users!
>>>>>
>>>>> I'm trying to sql over pandas dataframe using python interpreter.
>>>>> But below the error message.
>>>>> I do not know why this error occurs.
>>>>>
>>>>> Thank you for your help.
>>>>>
>>>>>
>>>>> =======================================================================================================================
>>>>> *paragraph 1. pandas dataframe*
>>>>> *[code]*
>>>>> %python
>>>>> mport pandas as pd
>>>>> import numpy as np
>>>>> import sys
>>>>>
>>>>> sys.version_info
>>>>> print(sys.version)
>>>>> print(sys.path)
>>>>>
>>>>> s = pd.Series(np.random.randn(100))
>>>>> s.head()
>>>>>
>>>>> df = pd.DataFrame(np.random.randn(110, 4), columns=list(‘ABCD’))
>>>>> df.head()
>>>>>
>>>>>
>>>>> *[result]*
>>>>> A B C D 0 -1.104620 -0.203555 -0.708837 0.811160 1 0.755126 0.060209
>>>>> -0.206536 -0.442819 2 0.056334 0.953871 -1.441647 -0.262722 3 -0.399785
>>>>> 1.195350 0.500972 1.028257 4 -1.738896 0.198309 0.986380 0.042211
>>>>>
>>>>> *paragraph 2. execute query*
>>>>> *[code]*
>>>>> %python.sql
>>>>> select * from df
>>>>>
>>>>> *[result (error msg)]*
>>>>> ```
>>>>> java.lang.NullPointerException
>>>>> at
>>>>> org.apache.zeppelin.python.IPythonInterpreter.interpret(IPythonInterpreter.java:331)
>>>>> at
>>>>> org.apache.zeppelin.python.PythonInterpreter.interpret(PythonInterpreter.java:371)
>>>>> at
>>>>> org.apache.zeppelin.python.PythonInterpreter.bootStrapInterpreter(PythonInterpreter.java:557)
>>>>> at
>>>>> org.apache.zeppelin.python.PythonInterpreterPandasSql.open(PythonInterpreterPandasSql.java:73)
>>>>> at
>>>>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.open(LazyOpenInterpreter.java:69)
>>>>> at
>>>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:617)
>>>>> at org.apache.zeppelin.scheduler.Job.run(Job.java:188) at
>>>>> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:140)
>>>>> 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)
>>>>> ```
>>>>>
>>>>> =======================================================================================================================
>>>>>
>>>>> ** zeppelin version*
>>>>> 0.8.0
>>>>>
>>>>> ** python version*
>>>>> 3.6.5 |Anaconda custom (64-bit)| (default, Apr 29 2018, 16:14:56)
>>>>> [GCC 7.2.0]
>>>>> ['', '/zeppelin/interpreter/python/py4j-0.9.2/src',
>>>>> '/data/anaconda3/lib/python36.zip', '/data/anaconda3/lib/python3.6',
>>>>> '/data/anaconda3/lib/python3.6/lib-dynload',
>>>>> '/data/anaconda3/lib/python3.6/site-packages',
>>>>> '/data/anaconda3/lib/python3.6/site-packages/Mako-1.0.7-py3.6.egg',
>>>>> '/data/anaconda3/lib/python3.6/site-packages/IPython/extensions',
>>>>> '/root/.ipython']
>>>>>
>>>>> Thank you very much.
>>>>>
>>>>
