[ 
https://issues.apache.org/jira/browse/SPARK-2376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Nicholas Chammas updated SPARK-2376:
------------------------------------

    Description: 
Repro script for PySpark, deployed via {{spark-ec2}} at git revision 
{{9d5ecf8205b924dc8a3c13fed68beb78cc5c7553}}:

{code}
from pyspark.sql import SQLContext
sqlContext = SQLContext(sc)

raw = sc.parallelize([
    """
    {
        "name": "Nick",
        "history": {
            "countries": []
        }
    }
    """
])

profiles = sqlContext.jsonRDD(raw)
profiles.registerAsTable("profiles")
profiles.printSchema()

sqlContext.sql("SELECT name FROM profiles;").collect()     # works fine
sqlContext.sql("SELECT history FROM profiles;").collect()  # raises exception
{code}

Attempting to select the top-level struct that has a nested list value yields 
the following error:

{code}
14/07/06 00:10:26 INFO scheduler.TaskSetManager: Loss was due to 
net.razorvine.pickle.PickleException: couldn't introspect javabean: 
java.lang.IllegalArgumentException: wrong number of arguments [duplicate 3]
14/07/06 00:10:26 ERROR scheduler.TaskSetManager: Task 26.0:15 failed 4 times; 
aborting job
14/07/06 00:10:26 INFO scheduler.TaskSchedulerImpl: Removed TaskSet 26.0, whose 
tasks have all completed, from pool 
14/07/06 00:10:26 INFO scheduler.TaskSchedulerImpl: Cancelling stage 26
14/07/06 00:10:26 INFO scheduler.DAGScheduler: Failed to run collect at 
<stdin>:1
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/root/spark/python/pyspark/rdd.py", line 649, in collect
    bytesInJava = self._jrdd.collect().iterator()
  File "/root/spark/python/lib/py4j-0.8.1-src.zip/py4j/java_gateway.py", line 
537, in __call__
  File "/root/spark/python/lib/py4j-0.8.1-src.zip/py4j/protocol.py", line 300, 
in get_return_value
py4j.protocol.Py4JJavaError: An error occurred while calling o286.collect.
: org.apache.spark.SparkException: Job aborted due to stage failure: Task 
26.0:15 failed 4 times, most recent failure: Exception failure in TID 394 on 
host ip-10-183-59-125.ec2.internal: net.razorvine.pickle.PickleException: 
couldn't introspect javabean: java.lang.IllegalArgumentException: wrong number 
of arguments
        net.razorvine.pickle.Pickler.put_javabean(Pickler.java:603)
        net.razorvine.pickle.Pickler.dispatch(Pickler.java:299)
        net.razorvine.pickle.Pickler.save(Pickler.java:125)
        net.razorvine.pickle.Pickler.put_map(Pickler.java:322)
        net.razorvine.pickle.Pickler.dispatch(Pickler.java:286)
        net.razorvine.pickle.Pickler.save(Pickler.java:125)
        net.razorvine.pickle.Pickler.put_map(Pickler.java:322)
        net.razorvine.pickle.Pickler.dispatch(Pickler.java:286)
        net.razorvine.pickle.Pickler.save(Pickler.java:125)
        net.razorvine.pickle.Pickler.put_arrayOfObjects(Pickler.java:392)
        net.razorvine.pickle.Pickler.dispatch(Pickler.java:195)
        net.razorvine.pickle.Pickler.save(Pickler.java:125)
        net.razorvine.pickle.Pickler.dump(Pickler.java:95)
        net.razorvine.pickle.Pickler.dumps(Pickler.java:80)
        
org.apache.spark.sql.SchemaRDD$$anonfun$javaToPython$1$$anonfun$apply$3.apply(SchemaRDD.scala:385)
        
org.apache.spark.sql.SchemaRDD$$anonfun$javaToPython$1$$anonfun$apply$3.apply(SchemaRDD.scala:385)
        scala.collection.Iterator$$anon$11.next(Iterator.scala:328)
        
org.apache.spark.api.python.PythonRDD$.writeIteratorToStream(PythonRDD.scala:317)
        
org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply$mcV$sp(PythonRDD.scala:203)
        
org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply(PythonRDD.scala:178)
        
org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply(PythonRDD.scala:178)
        org.apache.spark.util.Utils$.logUncaughtExceptions(Utils.scala:1213)
        
org.apache.spark.api.python.PythonRDD$WriterThread.run(PythonRDD.scala:177)
Driver stacktrace:
        at 
org.apache.spark.scheduler.DAGScheduler.org$apache$spark$scheduler$DAGScheduler$$failJobAndIndependentStages(DAGScheduler.scala:1041)
        at 
org.apache.spark.scheduler.DAGScheduler$$anonfun$abortStage$1.apply(DAGScheduler.scala:1025)
        at 
org.apache.spark.scheduler.DAGScheduler$$anonfun$abortStage$1.apply(DAGScheduler.scala:1023)
        at 
scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)
        at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:47)
        at 
org.apache.spark.scheduler.DAGScheduler.abortStage(DAGScheduler.scala:1023)
        at 
org.apache.spark.scheduler.DAGScheduler$$anonfun$handleTaskSetFailed$1.apply(DAGScheduler.scala:631)
        at 
org.apache.spark.scheduler.DAGScheduler$$anonfun$handleTaskSetFailed$1.apply(DAGScheduler.scala:631)
        at scala.Option.foreach(Option.scala:236)
        at 
org.apache.spark.scheduler.DAGScheduler.handleTaskSetFailed(DAGScheduler.scala:631)
        at 
org.apache.spark.scheduler.DAGSchedulerEventProcessActor$$anonfun$receive$2.applyOrElse(DAGScheduler.scala:1226)
        at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498)
        at akka.actor.ActorCell.invoke(ActorCell.scala:456)
        at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237)
        at akka.dispatch.Mailbox.run(Mailbox.scala:219)
        at 
akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386)
        at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
        at 
scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
        at 
scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
        at 
scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
{code}

This error persists regardless of whether the list value is empty or consists 
of base types or structs.

  was:
Repro script for PySpark, deployed via {{spark-ec2}} at git revision 
{{9d5ecf8205b924dc8a3c13fed68beb78cc5c7553}}:

{code}
from pyspark.sql import SQLContext
sqlContext = SQLContext(sc)

raw = sc.parallelize([
    """
    {
        "name": "Nick",
        "history": {
            "countries": []
        }
    }
    """
])

profiles = sqlContext.jsonRDD(raw)
profiles.registerAsTable("profiles")

sqlContext.sql("SELECT name FROM profiles;").collect()     # works fine
sqlContext.sql("SELECT history FROM profiles;").collect()  # raises exception
{code}

Attempting to select the top-level struct that has a nested list value yields 
the following error:

{code}
14/07/06 00:10:26 INFO scheduler.TaskSetManager: Loss was due to 
net.razorvine.pickle.PickleException: couldn't introspect javabean: 
java.lang.IllegalArgumentException: wrong number of arguments [duplicate 3]
14/07/06 00:10:26 ERROR scheduler.TaskSetManager: Task 26.0:15 failed 4 times; 
aborting job
14/07/06 00:10:26 INFO scheduler.TaskSchedulerImpl: Removed TaskSet 26.0, whose 
tasks have all completed, from pool 
14/07/06 00:10:26 INFO scheduler.TaskSchedulerImpl: Cancelling stage 26
14/07/06 00:10:26 INFO scheduler.DAGScheduler: Failed to run collect at 
<stdin>:1
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/root/spark/python/pyspark/rdd.py", line 649, in collect
    bytesInJava = self._jrdd.collect().iterator()
  File "/root/spark/python/lib/py4j-0.8.1-src.zip/py4j/java_gateway.py", line 
537, in __call__
  File "/root/spark/python/lib/py4j-0.8.1-src.zip/py4j/protocol.py", line 300, 
in get_return_value
py4j.protocol.Py4JJavaError: An error occurred while calling o286.collect.
: org.apache.spark.SparkException: Job aborted due to stage failure: Task 
26.0:15 failed 4 times, most recent failure: Exception failure in TID 394 on 
host ip-10-183-59-125.ec2.internal: net.razorvine.pickle.PickleException: 
couldn't introspect javabean: java.lang.IllegalArgumentException: wrong number 
of arguments
        net.razorvine.pickle.Pickler.put_javabean(Pickler.java:603)
        net.razorvine.pickle.Pickler.dispatch(Pickler.java:299)
        net.razorvine.pickle.Pickler.save(Pickler.java:125)
        net.razorvine.pickle.Pickler.put_map(Pickler.java:322)
        net.razorvine.pickle.Pickler.dispatch(Pickler.java:286)
        net.razorvine.pickle.Pickler.save(Pickler.java:125)
        net.razorvine.pickle.Pickler.put_map(Pickler.java:322)
        net.razorvine.pickle.Pickler.dispatch(Pickler.java:286)
        net.razorvine.pickle.Pickler.save(Pickler.java:125)
        net.razorvine.pickle.Pickler.put_arrayOfObjects(Pickler.java:392)
        net.razorvine.pickle.Pickler.dispatch(Pickler.java:195)
        net.razorvine.pickle.Pickler.save(Pickler.java:125)
        net.razorvine.pickle.Pickler.dump(Pickler.java:95)
        net.razorvine.pickle.Pickler.dumps(Pickler.java:80)
        
org.apache.spark.sql.SchemaRDD$$anonfun$javaToPython$1$$anonfun$apply$3.apply(SchemaRDD.scala:385)
        
org.apache.spark.sql.SchemaRDD$$anonfun$javaToPython$1$$anonfun$apply$3.apply(SchemaRDD.scala:385)
        scala.collection.Iterator$$anon$11.next(Iterator.scala:328)
        
org.apache.spark.api.python.PythonRDD$.writeIteratorToStream(PythonRDD.scala:317)
        
org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply$mcV$sp(PythonRDD.scala:203)
        
org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply(PythonRDD.scala:178)
        
org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply(PythonRDD.scala:178)
        org.apache.spark.util.Utils$.logUncaughtExceptions(Utils.scala:1213)
        
org.apache.spark.api.python.PythonRDD$WriterThread.run(PythonRDD.scala:177)
Driver stacktrace:
        at 
org.apache.spark.scheduler.DAGScheduler.org$apache$spark$scheduler$DAGScheduler$$failJobAndIndependentStages(DAGScheduler.scala:1041)
        at 
org.apache.spark.scheduler.DAGScheduler$$anonfun$abortStage$1.apply(DAGScheduler.scala:1025)
        at 
org.apache.spark.scheduler.DAGScheduler$$anonfun$abortStage$1.apply(DAGScheduler.scala:1023)
        at 
scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)
        at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:47)
        at 
org.apache.spark.scheduler.DAGScheduler.abortStage(DAGScheduler.scala:1023)
        at 
org.apache.spark.scheduler.DAGScheduler$$anonfun$handleTaskSetFailed$1.apply(DAGScheduler.scala:631)
        at 
org.apache.spark.scheduler.DAGScheduler$$anonfun$handleTaskSetFailed$1.apply(DAGScheduler.scala:631)
        at scala.Option.foreach(Option.scala:236)
        at 
org.apache.spark.scheduler.DAGScheduler.handleTaskSetFailed(DAGScheduler.scala:631)
        at 
org.apache.spark.scheduler.DAGSchedulerEventProcessActor$$anonfun$receive$2.applyOrElse(DAGScheduler.scala:1226)
        at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498)
        at akka.actor.ActorCell.invoke(ActorCell.scala:456)
        at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237)
        at akka.dispatch.Mailbox.run(Mailbox.scala:219)
        at 
akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386)
        at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
        at 
scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
        at 
scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
        at 
scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
{code}


> Selecting list values inside nested JSON objects raises 
> java.lang.IllegalArgumentException
> ------------------------------------------------------------------------------------------
>
>                 Key: SPARK-2376
>                 URL: https://issues.apache.org/jira/browse/SPARK-2376
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.0.1
>            Reporter: Nicholas Chammas
>
> Repro script for PySpark, deployed via {{spark-ec2}} at git revision 
> {{9d5ecf8205b924dc8a3c13fed68beb78cc5c7553}}:
> {code}
> from pyspark.sql import SQLContext
> sqlContext = SQLContext(sc)
> raw = sc.parallelize([
>     """
>     {
>         "name": "Nick",
>         "history": {
>             "countries": []
>         }
>     }
>     """
> ])
> profiles = sqlContext.jsonRDD(raw)
> profiles.registerAsTable("profiles")
> profiles.printSchema()
> sqlContext.sql("SELECT name FROM profiles;").collect()     # works fine
> sqlContext.sql("SELECT history FROM profiles;").collect()  # raises exception
> {code}
> Attempting to select the top-level struct that has a nested list value yields 
> the following error:
> {code}
> 14/07/06 00:10:26 INFO scheduler.TaskSetManager: Loss was due to 
> net.razorvine.pickle.PickleException: couldn't introspect javabean: 
> java.lang.IllegalArgumentException: wrong number of arguments [duplicate 3]
> 14/07/06 00:10:26 ERROR scheduler.TaskSetManager: Task 26.0:15 failed 4 
> times; aborting job
> 14/07/06 00:10:26 INFO scheduler.TaskSchedulerImpl: Removed TaskSet 26.0, 
> whose tasks have all completed, from pool 
> 14/07/06 00:10:26 INFO scheduler.TaskSchedulerImpl: Cancelling stage 26
> 14/07/06 00:10:26 INFO scheduler.DAGScheduler: Failed to run collect at 
> <stdin>:1
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
>   File "/root/spark/python/pyspark/rdd.py", line 649, in collect
>     bytesInJava = self._jrdd.collect().iterator()
>   File "/root/spark/python/lib/py4j-0.8.1-src.zip/py4j/java_gateway.py", line 
> 537, in __call__
>   File "/root/spark/python/lib/py4j-0.8.1-src.zip/py4j/protocol.py", line 
> 300, in get_return_value
> py4j.protocol.Py4JJavaError: An error occurred while calling o286.collect.
> : org.apache.spark.SparkException: Job aborted due to stage failure: Task 
> 26.0:15 failed 4 times, most recent failure: Exception failure in TID 394 on 
> host ip-10-183-59-125.ec2.internal: net.razorvine.pickle.PickleException: 
> couldn't introspect javabean: java.lang.IllegalArgumentException: wrong 
> number of arguments
>         net.razorvine.pickle.Pickler.put_javabean(Pickler.java:603)
>         net.razorvine.pickle.Pickler.dispatch(Pickler.java:299)
>         net.razorvine.pickle.Pickler.save(Pickler.java:125)
>         net.razorvine.pickle.Pickler.put_map(Pickler.java:322)
>         net.razorvine.pickle.Pickler.dispatch(Pickler.java:286)
>         net.razorvine.pickle.Pickler.save(Pickler.java:125)
>         net.razorvine.pickle.Pickler.put_map(Pickler.java:322)
>         net.razorvine.pickle.Pickler.dispatch(Pickler.java:286)
>         net.razorvine.pickle.Pickler.save(Pickler.java:125)
>         net.razorvine.pickle.Pickler.put_arrayOfObjects(Pickler.java:392)
>         net.razorvine.pickle.Pickler.dispatch(Pickler.java:195)
>         net.razorvine.pickle.Pickler.save(Pickler.java:125)
>         net.razorvine.pickle.Pickler.dump(Pickler.java:95)
>         net.razorvine.pickle.Pickler.dumps(Pickler.java:80)
>         
> org.apache.spark.sql.SchemaRDD$$anonfun$javaToPython$1$$anonfun$apply$3.apply(SchemaRDD.scala:385)
>         
> org.apache.spark.sql.SchemaRDD$$anonfun$javaToPython$1$$anonfun$apply$3.apply(SchemaRDD.scala:385)
>         scala.collection.Iterator$$anon$11.next(Iterator.scala:328)
>         
> org.apache.spark.api.python.PythonRDD$.writeIteratorToStream(PythonRDD.scala:317)
>         
> org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply$mcV$sp(PythonRDD.scala:203)
>         
> org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply(PythonRDD.scala:178)
>         
> org.apache.spark.api.python.PythonRDD$WriterThread$$anonfun$run$1.apply(PythonRDD.scala:178)
>         org.apache.spark.util.Utils$.logUncaughtExceptions(Utils.scala:1213)
>         
> org.apache.spark.api.python.PythonRDD$WriterThread.run(PythonRDD.scala:177)
> Driver stacktrace:
>       at 
> org.apache.spark.scheduler.DAGScheduler.org$apache$spark$scheduler$DAGScheduler$$failJobAndIndependentStages(DAGScheduler.scala:1041)
>       at 
> org.apache.spark.scheduler.DAGScheduler$$anonfun$abortStage$1.apply(DAGScheduler.scala:1025)
>       at 
> org.apache.spark.scheduler.DAGScheduler$$anonfun$abortStage$1.apply(DAGScheduler.scala:1023)
>       at 
> scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)
>       at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:47)
>       at 
> org.apache.spark.scheduler.DAGScheduler.abortStage(DAGScheduler.scala:1023)
>       at 
> org.apache.spark.scheduler.DAGScheduler$$anonfun$handleTaskSetFailed$1.apply(DAGScheduler.scala:631)
>       at 
> org.apache.spark.scheduler.DAGScheduler$$anonfun$handleTaskSetFailed$1.apply(DAGScheduler.scala:631)
>       at scala.Option.foreach(Option.scala:236)
>       at 
> org.apache.spark.scheduler.DAGScheduler.handleTaskSetFailed(DAGScheduler.scala:631)
>       at 
> org.apache.spark.scheduler.DAGSchedulerEventProcessActor$$anonfun$receive$2.applyOrElse(DAGScheduler.scala:1226)
>       at akka.actor.ActorCell.receiveMessage(ActorCell.scala:498)
>       at akka.actor.ActorCell.invoke(ActorCell.scala:456)
>       at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:237)
>       at akka.dispatch.Mailbox.run(Mailbox.scala:219)
>       at 
> akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386)
>       at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
>       at 
> scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
>       at 
> scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
>       at 
> scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
> {code}
> This error persists regardless of whether the list value is empty or consists 
> of base types or structs.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to