SparkSQL(一)

最新推荐文章于 2023-05-15 16:34:00 发布

jerrfy_w

最新推荐文章于 2023-05-15 16:34:00 发布

阅读量166

点赞数

分类专栏： Spark

本文链接：https://blog.csdn.net/wzj_wp/article/details/108282216

版权

http://spark.apache.org/docs/latest/sql-getting-started.html

scala>     val df = spark.read.json("file:///home/wzj/app/spark/examples/src/main/resources/people.json")
df: org.apache.spark.sql.DataFrame = [age: bigint, name: string]                

scala> df.printSchema()
root
 |-- age: long (nullable = true)
 |-- name: string (nullable = true)


scala> df.show()
+----+-------+
| age|   name|
+----+-------+
|null|Michael|
|  30|   Andy|
|  19| Justin|
+----+-------+

scala> df.createTempView("people")
scala> spark.sql("select * from people")


=====报错======

Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.
  at org.datanucleus.stor