[
https://issues.apache.org/jira/browse/SQOOP-484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14138308#comment-14138308
]
Pratik Khadloya commented on SQOOP-484:
---------------------------------------
Thanks for updating the docs. It is very helpful information.
> Update troubleshooting guide section about MySQL and TINYINT(1) columns
> -----------------------------------------------------------------------
>
> Key: SQOOP-484
> URL: https://issues.apache.org/jira/browse/SQOOP-484
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Jarek Jarcec Cecho
> Assignee: Jarek Jarcec Cecho
> Priority: Trivial
> Fix For: 1.4.2
>
> Attachments: SQOOP-484.patch, SQOOP-484.patch
>
>
> This issue is continuation of JIRA ticket SQOOP-463.
> I've investigated MySQL JDBC connector behavior in case of columns defined as
> TINYINT(1). By default MySQL JDBC connector is converting TINYINT(1) into
> java.sql.Types.BIT, which can be very easily turned off by specifying
> tinyInt1isBit=false in JDBC path. For example
> jdbc:mysql://localhost/test?tinyInt1isBit=false. I would suggest to update
> troubleshooting guide by suggesting users to set this property rather than
> overriding default sqoop type mapping.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
