Spark 2.0 with Zeppelin 0.6.1-SQLContext不可用

Question

我正在Linux服务器上运行Spark2.0和Zeppelin-0.6.1-bin。默认的spark笔记本运行得很好，但当我尝试使用sqlContext在pyspark中创建并运行一个新笔记本时，我得到错误“py4j.py4jException:Method createDataFrame([class java.util.ArrayList,class java.util.ArrayList,null])不存在”

我试着运行一个简单的代码,

%pyspark

wordsDF = sqlContext.createDataFrame([('cat',), ('elephant',), ('rat',), ('rat',), ('cat', )], ['word'])
wordsDF.show()
print type(wordsDF)
wordsDF.printSchema()

我知道这个错误,

Traceback (most recent call last):
  File "/tmp/zeppelin_pyspark-7635635698598314374.py", line 266, in 
    raise Exception(traceback.format_exc())
Exception: Traceback (most recent call last):
  File "/tmp/zeppelin_pyspark-7635635698598314374.py", line 259, in 
    exec(code)
  File "", line 1, in 
  File "/spark/spark-2.0.0-bin-hadoop2.7/python/pyspark/sql/context.py", line 299, in createDataFrame
    return self.sparkSession.createDataFrame(data, schema, samplingRatio)
  File "/spark/spark-2.0.0-bin-hadoop2.7/python/lib/py4j-0.10.1-src.zip/py4j/java_gateway.py", line 933, in __call__
    answer, self.gateway_client, self.target_id, self.name)
  File "/spark/spark-2.0.0-bin-hadoop2.7/python/pyspark/sql/utils.py", line 63, in deco
    return f(*a, **kw)
  File "/spark/spark-2.0.0-bin-hadoop2.7/python/lib/py4j-0.10.1-src.zip/py4j/protocol.py", line 316, in get_return_value
    format(target_id, ".", name, value))
Py4JError: An error occurred while calling o48.createDataFrame. Trace:
py4j.Py4JException: Method createDataFrame([class java.util.ArrayList, class java.util.ArrayList, null]) does not exist
    at py4j.reflection.ReflectionEngine.getMethod(ReflectionEngine.java:318)
    at py4j.reflection.ReflectionEngine.getMethod(ReflectionEngine.java:326)
    at py4j.Gateway.invoke(Gateway.java:272)
    at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:128)
    at py4j.commands.CallCommand.execute(CallCommand.java:79)
    at py4j.GatewayConnection.run(GatewayConnection.java:211)
    at java.lang.Thread.run(Thread.java:745)

当我使用“SQLContext=SQLContext（sc）”尝试相同的代码时，它工作得很好。

我尝试设置解释器“zeppelin.spark.UseHiveContext false”配置，但没有起作用。

显然我一定漏了什么，因为这是一个如此简单的操作。请建议，如果有任何其他配置要设置或我缺少什么。

我用Zeppelin0.6.0测试了同一段代码，它运行良好。

Answer 1

sparksession是Spark 2.0.0的默认入口点，该入口点映射到Zeppelin 0.6.1中的Spark（与Spark shell一样）。您是否尝试过spark.createDataFrame(...)？