我已经找到解决方案。我将sql数据框转换为pandas数据框,然后能够绘制图形。下面是示例代码。
pyspark.sql import Rowfrom pyspark.sql import HiveContextimport pysparkfrom IPython.display import displayimport matplotlibimport matplotlib.pyplot as plt%matplotlib inline sc = pyspark.SparkContext()sqlContext = HiveContext(sc)test_list = [(1, 'hasan'),(2, 'nana'),(3, 'dad'),(4, 'mon')]rdd = sc.parallelize(test_list)people = rdd.map(lambda x: Row(id=int(x[0]), name=x[1]))schemaPeople = sqlContext.createDataframe(people)# Register it as a temp tablesqlContext.registerDataframeAsTable(schemaPeople, "test_table")df1=sqlContext.sql("Select * from test_table")pdf1=df1.toPandas()pdf1.plot(kind='barh',x='name',y='id',colormap='winter_r')


