Fwd: Errors using Zeppelin REST API

[Ekta Nandwani <ma...@gmail.com>]

Hello everyone,

I have got some trouble using the REST API of Zeppelin. I have a PHP
application via which I am creating a paragraph in a notebook and later in
the same script trying to run that paragraph.

The new paragraph created has this text:
"%sql select date_time from table_name"

Now the paragraph is successfully created and also the running that
paragraph returns : {"status":"OK"}


But this error pops up when the job is run from the PHP application

org.codehaus.janino.JaninoRuntimeException: Class 'org.apache.spark.sql.
catalyst.expressions.codegen.GeneratedClass' was loaded through a different
loader
at org.codehaus.janino.SimpleCompiler$1.getDelegate(SimpleCompiler.java:356)
at org.codehaus.janino.SimpleCompiler$1.accept(SimpleCompiler.java:301)
at org.codehaus.janino.UnitCompiler.getType(UnitCompiler.java:5660)
at org.codehaus.janino.UnitCompiler.access$1200(UnitCompiler.java:206)
at org.codehaus.janino.UnitCompiler$30.getSuperclass2(UnitCompiler.
java:8933)
at org.codehaus.janino.IClass.getSuperclass(IClass.java:404)
at org.codehaus.janino.IClass.findMemberType(IClass.java:765)
at org.codehaus.janino.IClass.findMemberType(IClass.java:732)
at org.codehaus.janino.UnitCompiler.findMemberType(UnitCompiler.java:10948)
at org.codehaus.janino.UnitCompiler.getReferenceType(UnitCompiler.java:5876)
at org.codehaus.janino.UnitCompiler.getReferenceType(UnitCompiler.java:5751)
at org.codehaus.janino.UnitCompiler.getType2(UnitCompiler.java:5732)
at org.codehaus.janino.UnitCompiler.access$13200(UnitCompiler.java:206)
at org.codehaus.janino.UnitCompiler$18.visitReferenceType(
UnitCompiler.java:5668)
at org.codehaus.janino.UnitCompiler$18.visitReferenceType(
UnitCompiler.java:5660)
at org.codehaus.janino.Java$ReferenceType.accept(Java.java:3356)
at org.codehaus.janino.UnitCompiler.getType(UnitCompiler.java:5660)
at org.codehaus.janino.UnitCompiler.getType2(UnitCompiler.java:6007)
at org.codehaus.janino.UnitCompiler.access$13000(UnitCompiler.java:206)
at org.codehaus.janino.UnitCompiler$18.visitArrayType(UnitCompiler.
java:5666)
at org.codehaus.janino.UnitCompiler$18.visitArrayType(UnitCompiler.
java:5660)
at org.codehaus.janino.Java$ArrayType.accept(Java.java:3425)
at org.codehaus.janino.UnitCompiler.getType(UnitCompiler.java:5660)
at org.codehaus.janino.UnitCompiler.access$1200(UnitCompiler.java:206)
at org.codehaus.janino.UnitCompiler$32.getParameterTypes2(
UnitCompiler.java:9326)
at org.codehaus.janino.IClass$IInvocable.getParameterTypes(IClass.java:853)
at org.codehaus.janino.IClass$IMethod.getDescriptor2(IClass.java:1084)
at org.codehaus.janino.IClass$IInvocable.getDescriptor(IClass.java:865)
at org.codehaus.janino.IClass.getIMethods(IClass.java:211)
at org.codehaus.janino.IClass.getIMethods(IClass.java:200)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:439)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:420)
at org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:206)
at org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclara
tion(UnitCompiler.java:374)
at org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclara
tion(UnitCompiler.java:369)
at org.codehaus.janino.Java$AbstractPackageMemberClassDecl
aration.accept(Java.java:1309)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:369)
at org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:345)
at org.codehaus.janino.SimpleCompiler.compileToClassLoader(
SimpleCompiler.java:396)
at org.codehaus.janino.ClassBodyEvaluator.compileToClass(
ClassBodyEvaluator.java:311)
at org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:229)
at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:196)
at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:91)
at org.apache.spark.sql.catalyst.expressions.codegen.
CodeGenerator$.org$apache$spark$sql$catalyst$expressions$codegen$
CodeGenerator$$doCompile(CodeGenerator.scala:935)
at org.apache.spark.sql.catalyst.expressions.codegen.
CodeGenerator$$anon$1.load(CodeGenerator.scala:998)
at org.apache.spark.sql.catalyst.expressions.codegen.
CodeGenerator$$anon$1.load(CodeGenerator.scala:995)
at org.spark_project.guava.cache.LocalCache$LoadingValueReference.
loadFuture(LocalCache.java:3599)
at org.spark_project.guava.cache.LocalCache$Segment.loadSync(
LocalCache.java:2379)
at org.spark_project.guava.cache.LocalCache$Segment.
lockedGetOrLoad(LocalCache.java:2342)
at org.spark_project.guava.cache.LocalCache$Segment.get(
LocalCache.java:2257)
at org.spark_project.guava.cache.LocalCache.get(LocalCache.java:4000)
at org.spark_project.guava.cache.LocalCache.getOrLoad(LocalCache.java:4004)
at org.spark_project.guava.cache.LocalCache$LocalLoadingCache.
get(LocalCache.java:4874)
at org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator$.compile(
CodeGenerator.scala:890)
at org.apache.spark.sql.catalyst.expressions.codegen.
GenerateOrdering$.create(GenerateOrdering.scala:155)
at org.apache.spark.sql.catalyst.expressions.codegen.
GenerateOrdering$.create(GenerateOrdering.scala:43)
at org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator.generate(
CodeGenerator.scala:874)
at org.apache.spark.sql.catalyst.expressions.codegen.
LazilyGeneratedOrdering.<init>(GenerateOrdering.scala:169)
at org.apache.spark.sql.catalyst.expressions.codegen.
LazilyGeneratedOrdering.<init>(GenerateOrdering.scala:166)
at org.apache.spark.sql.execution.TakeOrderedAndProjectExec.
executeCollect(limit.scala:132)
at org.apache.spark.sql.Dataset$$anonfun$org$apache$spark$sql$
Dataset$$execute$1$1.apply(Dataset.scala:2371)
at org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(
SQLExecution.scala:57)
at org.apache.spark.sql.Dataset.withNewExecutionId(Dataset.scala:2765)
at org.apache.spark.sql.Dataset.org$apache$spark$sql$Dataset$$
execute$1(Dataset.scala:2370)
at org.apache.spark.sql.Dataset.org$apache$spark$sql$Dataset$$
collect(Dataset.scala:2377)
at org.apache.spark.sql.Dataset$$anonfun$head$1.apply(Dataset.scala:2113)
at org.apache.spark.sql.Dataset$$anonfun$head$1.apply(Dataset.scala:2112)
at org.apache.spark.sql.Dataset.withTypedCallback(Dataset.scala:2795)
at org.apache.spark.sql.Dataset.head(Dataset.scala:2112)
at org.apache.spark.sql.Dataset.take(Dataset.scala:2327)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.zeppelin.spark.ZeppelinContext.showDF(
ZeppelinContext.java:235)
at org.apache.zeppelin.spark.SparkSqlInterpreter.interpret(
SparkSqlInterpreter.java:130)
at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(
LazyOpenInterpreter.java:95)
at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$
InterpretJob.jobRun(RemoteInterpreterServer.java:490)
at org.apache.zeppelin.scheduler.Job.run(Job.java:175)
at org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:139)
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:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
ERROR



However the pressing the "run" button for the same paragraph which I
created from PHP aplication gives the correct output that is a selected
column from the table.


Kindly help me resolving this error.



-- 
Regards,
Ekta