Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- spark-shell --driver-class-path D:Sparkjdbcsqljdbc_6.0enujre7sqljdbc41.jar --packages werneckpaiva:spark-to-tableau:0.1.0
- val sqlContext = new org.apache.spark.sql.SQLContext(sc) import TableauDataFrame._
- val jdbcSqlConnStr = "jdbc:sqlserver://IP:1433;databaseName=Dbname;user=UserName;password=Password;"
- val jdbcDbTable = "dbo.TableName"
- val jdbcDF = sqlContext.read.format("jdbc").option("url",jdbcSqlConnStr).option("dbtable",jdbcDbTable).load()
- //To check DF
- jdbcDF.show(10)
- jdbcDF.write.format("tableau").save("D:\Spark\mydata.tde")
- error: value TableauDataFrame is not a member of org.apache.spark.sql.DataFrameWriter[org.apache.spark.sql.Row]
- import TableauDataFrame._
- <console>:23: error: not found: value TableauDataFrame
- import TableauDataFrame._
Add Comment
Please, Sign In to add comment