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