Jarek Jarcec Cecho created SQOOP-484:
----------------------------------------
Summary: 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-incubating
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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
