Ok, Spark MSSQL dataType mapping is not right for me, ie. string is Text instead of varchar(MAX) , so how can I override default SQL Mapping?
regards. On Sun, May 1, 2016 at 5:23 AM, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > Well if MSSQL cannot create that column then it is more like compatibility > between Spark and RDBMS. > > What value that column has in MSSQL. Can you create table the table in > MSSQL database or map it in Spark to a valid column before opening JDBC > connection? > > 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 29 April 2016 at 16:16, Andrés Ivaldi <iaiva...@gmail.com> wrote: > >> Hello, Spark is executing a create table sentence (using JDBC) to >> MSSQLServer with a mapping column type like ColName Bit(1) for boolean >> types, This create table cannot be executed on MSSQLServer. >> >> In class JdbcDialect the mapping for Boolean type is Bit(1), so the >> question is, this is a problem of spark or JDBC driver who is not mapping >> right? >> >> Anyway it´s possible to override that mapping in Spark? >> >> Regards >> >> -- >> Ing. Ivaldi Andres >> > > -- Ing. Ivaldi Andres
