You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "jiraposter@reviews.apache.org (Commented) (JIRA)" <ji...@apache.org> on 2012/03/14 23:48:47 UTC
[jira] [Commented] (SQOOP-463) Sqoop User Guide's troubleshooting
section should explain how to override the column mapping when importing a
table from MySQL into Hive
[ https://issues.apache.org/jira/browse/SQOOP-463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13229716#comment-13229716 ]
jiraposter@reviews.apache.org commented on SQOOP-463:
-----------------------------------------------------
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/4357/
-----------------------------------------------------------
Review request for Sqoop and Arvind Prabhakar.
Summary
-------
Updated documentation.
This addresses bug SQOOP-463.
https://issues.apache.org/jira/browse/SQOOP-463
Diffs
-----
./src/docs/user/troubleshooting.txt 1300726
Diff: https://reviews.apache.org/r/4357/diff
Testing
-------
Built docs and verified.
Thanks,
Kathleen
> Sqoop User Guide's troubleshooting section should explain how to override the column mapping when importing a table from MySQL into Hive
> ----------------------------------------------------------------------------------------------------------------------------------------
>
> Key: SQOOP-463
> URL: https://issues.apache.org/jira/browse/SQOOP-463
> Project: Sqoop
> Issue Type: Improvement
> Components: docs
> Affects Versions: 1.4.1-incubating
> Reporter: Kathleen Ting
> Assignee: Kathleen Ting
> Attachments: SQOOP-463.patch
>
>
> When importing a table from MySQL into Hive where one of the columns is of datatype TINYINT(1), Sqoop will automatically map this to the Hive datatype boolean. This is because the MySQL JDBC connector maps the TINYINT(1) datatype to java.sql.Types.BIT, which Sqoop by default maps to the Hive type Boolean. Consequently, if you have values such as 1 or 0 in this column, they will fail to parse correctly in Hive, instead appearing as all NULL values.
--
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