sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jiraposter@reviews.apache.org (Commented) (JIRA)" <j...@apache.org>
Subject [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
Date Wed, 21 Mar 2012 06:45:48 GMT

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

jiraposter@reviews.apache.org commented on SQOOP-463:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/4357/#review6167
-----------------------------------------------------------

Ship it!


Thank you for the change Kate!

- Jarek


On 2012-03-21 01:49:19, Kathleen Ting wrote:
bq.  
bq.  -----------------------------------------------------------
bq.  This is an automatically generated e-mail. To reply, visit:
bq.  https://reviews.apache.org/r/4357/
bq.  -----------------------------------------------------------
bq.  
bq.  (Updated 2012-03-21 01:49:19)
bq.  
bq.  
bq.  Review request for Sqoop and Jarek Cecho.
bq.  
bq.  
bq.  Summary
bq.  -------
bq.  
bq.  Updated documentation.
bq.  
bq.  
bq.  This addresses bug SQOOP-463.
bq.      https://issues.apache.org/jira/browse/SQOOP-463
bq.  
bq.  
bq.  Diffs
bq.  -----
bq.  
bq.    ./src/docs/user/troubleshooting.txt 1300726 
bq.  
bq.  Diff: https://reviews.apache.org/r/4357/diff
bq.  
bq.  
bq.  Testing
bq.  -------
bq.  
bq.  Built docs and verified.
bq.  
bq.  
bq.  Thanks,
bq.  
bq.  Kathleen
bq.  
bq.


                
> 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-1.patch, 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

        

Mime
View raw message