You should be able to register your own dialect if the default mappings are not working for your scenario.
import org.apache.spark.sql.jdbc JdbcDialects.registerDialect(MyDialect) Please refer to the JdbcDialects to find example of existing default dialect for your database or another database. https://github.com/apache/spark/blob/branch-1.6/sql/core/src/main/scala/org/apache/spark/sql/jdbc/JdbcDialects.scala <https://github.com/apache/spark/blob/branch-1.6/sql/core/src/main/scala/org/apache/spark/sql/jdbc/JdbcDialects.scala> https://github.com/apache/spark/tree/branch-1.6/sql/core/src/main/scala/org/apache/spark/sql/jdbc <https://github.com/apache/spark/tree/branch-1.6/sql/core/src/main/scala/org/apache/spark/sql/jdbc> > On Mar 15, 2016, at 12:41 PM, Mich Talebzadeh <mich.talebza...@gmail.com> > wrote: > > Hi, > > Can you please clarify what you are trying to achieve and I guess you mean > Transact_SQL for MSSQL? > > HTH > > Dr Mich Talebzadeh > > LinkedIn > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw> > > http://talebzadehmich.wordpress.com <http://talebzadehmich.wordpress.com/> > > > On 15 March 2016 at 19:09, Andrés Ivaldi <iaiva...@gmail.com > <mailto:iaiva...@gmail.com>> wrote: > Hello, I'm trying to use MSSQL, storing data on MSSQL but i'm having dialect > problems > I found this > https://mail-archives.apache.org/mod_mbox/spark-issues/201510.mbox/%3cjira.12901078.1443461051000.34556.1444123886...@atlassian.jira%3E > > <https://mail-archives.apache.org/mod_mbox/spark-issues/201510.mbox/%3cjira.12901078.1443461051000.34556.1444123886...@atlassian.jira%3E> > > That is what is happening to me, It's possible to define the dialect? so I > can override the default for SQLServer? > > Regards. > > -- > Ing. Ivaldi Andres >
