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.
>>>>
>>>
