[ 
https://issues.apache.org/jira/browse/SPARK-20481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15985716#comment-15985716
 ] 

Xiao Li commented on SPARK-20481:
---------------------------------

We are unable to make a change in this default data type mapping. It can cause 
external behavior changes.

In Spark 2.2., you can manually change it by using the option 
`createTableColumnTypes`. For details, see the following PR: 
https://github.com/apache/spark/pull/16209

> Wrong mapping for BooleanType in Spark SQL
> ------------------------------------------
>
>                 Key: SPARK-20481
>                 URL: https://issues.apache.org/jira/browse/SPARK-20481
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.1.0
>            Reporter: Talat UYARER
>            Priority: Minor
>
> Booleantype is mapping to BIT type on SQL side. 
> https://github.com/apache/spark/blob/a26e3ed5e414d0a350cfe65dd511b154868b9f1d/sql/core/src/main/scala/org/apache/spark/sql/execution/datasources/jdbc/JdbcUtils.scala#L159
> Is there is any specific reason it should be mapping to Boolean 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to