val spark = SparkSession
.builder()
.appName("Oracle")
.master("local[*]")
.getOrCreate()
spark.read
.format("jdbc")
.option("url","jdbc:oracle:thin:@10.2.22.222:orcl")
.option("dbtable","TABLE_NAME")
.option("user","AAA")
.option("password","PWD")
.option("driver","orcle.jdbc.driver.OracleDriver")
.load()
.createOrReplaceTempView("TABLE_NAME")
spark.sql("SELECT * FROM TABLE_NAME ").show()
spark.stop()
sparkSQL 3.2.1查询远程Oracle
最新推荐文章于 2022-06-06 14:06:23 发布