Guest User

Untitled

a guest
Oct 20th, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. spark-shell --driver-class-path D:Sparkjdbcsqljdbc_6.0enujre7sqljdbc41.jar --packages werneckpaiva:spark-to-tableau:0.1.0
  2.  
  3. val sqlContext = new org.apache.spark.sql.SQLContext(sc) import TableauDataFrame._
  4. val jdbcSqlConnStr = "jdbc:sqlserver://IP:1433;databaseName=Dbname;user=UserName;password=Password;"
  5. val jdbcDbTable = "dbo.TableName"
  6. val jdbcDF = sqlContext.read.format("jdbc").option("url",jdbcSqlConnStr).option("dbtable",jdbcDbTable).load()
  7. //To check DF
  8. jdbcDF.show(10)
  9.  
  10. jdbcDF.write.format("tableau").save("D:\Spark\mydata.tde")
  11. error: value TableauDataFrame is not a member of org.apache.spark.sql.DataFrameWriter[org.apache.spark.sql.Row]
  12.  
  13. import TableauDataFrame._
  14. <console>:23: error: not found: value TableauDataFrame
  15. import TableauDataFrame._
Add Comment
Please, Sign In to add comment