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.
