You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by Andrés Ivaldi <ia...@gmail.com> on 2016/03/15 20:09:02 UTC
Microsoft SQL dialect issues
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.1444123886508@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
Re: Microsoft SQL dialect issues
Posted by Suresh Thalamati <su...@gmail.com>.
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 <mi...@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 <iaivaldi@gmail.com <ma...@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.1444123886508@Atlassian.JIRA%3E <https://mail-archives.apache.org/mod_mbox/spark-issues/201510.mbox/%3CJIRA.12901078.1443461051000.34556.1444123886508@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
>
Re: Microsoft SQL dialect issues
Posted by Mich Talebzadeh <mi...@gmail.com>.
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
On 15 March 2016 at 19:09, Andrés Ivaldi <ia...@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.1444123886508@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
>