Re: Exception in Spark-sql insertIntoJDBC command

2016-01-13 Thread RichG
Hi All, I am having the same issue in Spark 1.5.1. I've tried through Scala and Python and neither the 'append' or 'overwrite' mode allow me to insert rows from a dataframe into an existing MS SQL Server 2012 table. When the table doesn't exist, this works fine and creates the table with the rows

Re: Exception in Spark-sql insertIntoJDBC command

2015-12-08 Thread kali.tumm...@gmail.com
Hi All, I have the same error in spark 1.5 is there any solution to get around with this ? I also tried using sourcedf.write.mode("append") but still no luck . val sourcedfmode=sourcedf.write.mode("append") sourcedfmode.jdbc(TargetDBinfo.url,TargetDBinfo.table,targetprops) Thanks Sri -- Vie