Guest User

Untitled

a guest
Oct 18th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. val sqlContext = new org.apache.spark.sql.SQLContext(sc)
  2. val jdbcSqlConnStr = "jdbc:sqlserver://HostIP:1433;databaseName=DBName;user=UserName;password=PWD;"
  3. val jdbcDbTable = "dbo.Table"
  4. val jdbcDF = sqlContext.read.format("jdbc").option("url",jdbcSqlConnStr).option("dbtable",jdbcDbTable).load()
  5. jdbcDF.write.format("com.databricks.spark.csv").save("D:\Spark\2")
Add Comment
Please, Sign In to add comment