首页 文章

无法从SparkR创建的DataFrame中检索数据

提问于
浏览
6

我有以下简单的 SparkR 程序,即创建 SparkR DataFrame 并从中检索/收集数据 .

Sys.setenv(HADOOP_CONF_DIR = "/etc/hadoop/conf.cloudera.yarn")
Sys.setenv(SPARK_HOME = "/home/user/Downloads/spark-1.6.1-bin-hadoop2.6")
.libPaths(c(file.path(Sys.getenv("SPARK_HOME"), "R", "lib"), .libPaths()))
library(SparkR)
sc <- sparkR.init(master="yarn-client",sparkEnvir = list(spark.shuffle.service.enabled=TRUE,spark.dynamicAllocation.enabled=TRUE,spark.dynamicAllocation.initialExecutors="40"))
hiveContext <- sparkRHive.init(sc)

n = 1000
x = data.frame(id = 1:n, val = rnorm(n))
xs <- createDataFrame(hiveContext, x)

xs

head(xs)
collect(xs)

我能够成功创建它并查看信息,但任何与获取数据相关的操作都会抛出错误 .

16/07/25 16:33:59 WARN TaskSetManager:阶段17.0中丢失的任务0.3(TID 86,wlos06.nrm.minn.seagate.com):java.net.SocketTimeoutException:接受在java.net.PlainSocketImpl超时位于java.net.ServerSocket.impl上的java.net.ServerSocket.implAccept(ServerSocket.java:530)的java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398)中的.socketAccept(Native Method)(ServerSocket.java:498) )org.apache.apache.api.r.RRDD $ .createRWorker(RRDD.scala:432)位于org.apache.spark的org.apache.spark.api.r.BaseRRDD.compute(RRDD.scala:63)位于org.apache.spark.rdd.MapPartitionsRDD.compute的org.apache.spark.rdd.RDD.iterator(RDD.scala:270)的.rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)(MapPartitionsRDD.scala:38) )位于org.apache.spark.rdd.MapPartitionsRDD的org.apache.spark.rdd.RDD.compartOdReadCheck(RDD.scala:306)org.apache.spark.rdd.RDD.iterator(RDD.scala:270) . 在org.apache.spar的org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)计算(MapPartitionsRDD.scala:38) k.rdd.RDD.iterator(RDD.scala:270)atg.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38)atg.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala: 306)org.apache.spark.rdd.RDD.iterator(RDD.scala:270)at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:66)at org.apache.spark.scheduler.Task .run(Task.scala:89)位于java的java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)的org.apache.spark.executor.Executor $ TaskRunner.run(Executor.scala:214) . util.concurrent.ThreadPoolExecutor $ Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:745)16/07/25 16:33:59 ERROR TaskSetManager:阶段17.0中的任务0失败4次; aborting job 16/07/25 16:33:59错误RBackendHandler:org.apache.spark.sql.api.r.SQLUtils上的dfToCols失败invokeJava中的错误(isStatic = TRUE,className,methodName,...):org . apache.spark.SparkException:作业因阶段失败而中止:阶段17.0中的任务0失败4次,最近失败:阶段17.0中丢失任务0.3(TID 86,wlos06.nrm.minn.seagate.com):java.net .SocketTimeoutException:在Java.net.Server.Socket.implAccept(ServerSocket.java:530)的java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398)的java.net.PlainSocketImpl.socketAccept(Native Method)接受超时位于org.apache.apark.api.r.BaseRRDD.compute的org.apache.spark.api.r.RRDD $ .createRWorker(RRDD.scala:432)的.net.ServerSocket.accept(ServerSocket.java:498) RRDD.scala:63)位于org.apache.spark的org.apache.spark.rdd.RDd.compartOdReadCheck(RDD.scala:306)org.apache.spark.rdd.RDD.iterator(RDD.scala:270)org.apache.spark org.apache.spark中的.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38) . 位于org.apache.spark.rdd.MapPartitionsRDD.compute(MapPar)的org.apache.spark.rdd.RDD.iterator(RDD.scala:270)的rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)

如果我通过sparkR命令行执行它,如下所示,它将被执行 .

~/Downloads/spark-1.6.1-bin-hadoop2.6/bin/sparkR --master yarn-client

但是当我通过R和sparkR.init((master =“yarn-client”)执行它时,它会抛出错误 .

有人可以帮助解决这些错误吗?

1 回答

  • 6

    添加此行有所不同:

    Sys.setenv("SPARKR_SUBMIT_ARGS"="--master yarn-client sparkr-shell")
    

    这是完整的代码:

    Sys.setenv(HADOOP_CONF_DIR = "/etc/hadoop/conf.cloudera.yarn")
    Sys.setenv(SPARK_HOME = "/home/user/Downloads/spark-1.6.1-bin-hadoop2.6")
    .libPaths(c(file.path(Sys.getenv("SPARK_HOME"), "R", "lib"), .libPaths()))
    library(SparkR)
    Sys.setenv("SPARKR_SUBMIT_ARGS"="--master yarn-client sparkr-shell")
    sc <- sparkR.init(sparkEnvir = list(spark.shuffle.service.enabled=TRUE,spark.dynamicAllocation.enabled=TRUE,spark.dynamicAllocation.initialExecutors="40"))
    hiveContext <- sparkRHive.init(sc)
    
    n = 1000
    x = data.frame(id = 1:n, val = rnorm(n))
    xs <- createDataFrame(hiveContext, x)
    
    xs
    
    head(xs)
    collect(xs)
    

相关问题