Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- val sqlContext = new org.apache.spark.sql.SQLContext(sc)
- val jdbcSqlConnStr = "jdbc:sqlserver://HostIP:1433;databaseName=DBName;user=UserName;password=PWD;"
- val jdbcDbTable = "dbo.Table"
- val jdbcDF = sqlContext.read.format("jdbc").option("url",jdbcSqlConnStr).option("dbtable",jdbcDbTable).load()
- jdbcDF.write.format("com.databricks.spark.csv").save("D:\Spark\2")
Add Comment
Please, Sign In to add comment