Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- jdbc_url <- "jdbc:mysql://localhost:3306/dashboard?user=<username>&password=<password>"
- df <- sqlContext %>%
- loadDF(source = "jdbc",
- url = jdbc_url,
- driver = "com.mysql.jdbc.Driver",
- dbtable = "db.table_name")
- write.df(df = df,
- path = "NULL",
- source = "jdbc",
- url = jdbc_url,
- driver = "com.mysql.jdbc.Driver",
- dbtable = "db.table_name",
- mode = "append")
- ERROR RBackendHandler: save on 55 failed
- Error in invokeJava(isStatic = FALSE, objId$id, methodName, ...) :
- java.lang.RuntimeException: org.apache.spark.sql.execution.datasources.jdbc.DefaultSource does not allow create table as select.
- at scala.sys.package$.error(package.scala:27)
- at org.apache.spark.sql.execution.datasources.ResolvedDataSource$.apply(ResolvedDataSource.scala:259)
- at org.apache.spark.sql.DataFrameWriter.save(DataFrameWriter.scala:148)
- at org.apache.spark.sql.DataFrame.save(DataFrame.scala:2066)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.apache.spark.api.r.RBackendHandler.handleMethodCall(RBackendHandler.scala:141)
- at org.apache.spark.api.r.RBackendHandler.channelRead0(RBackendHandler.scala:86)
- at org.apache.spark.api.r.RBackendHandler.channelRead0(RBackendHandler.scala:38)
- at io.netty.channel.SimpleChannelIn
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement