sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jiraposter@reviews.apache.org (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-484) Update troubleshooting guide section about MySQL and TINYINT(1) columns
Date Mon, 14 May 2012 04:24:16 GMT

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

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


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

Ship it!


Looks good. Thanks Jarcec.

- Kathleen


On 2012-05-12 14:07:22, Jarek Cecho wrote:
bq.  
bq.  -----------------------------------------------------------
bq.  This is an automatically generated e-mail. To reply, visit:
bq.  https://reviews.apache.org/r/5065/
bq.  -----------------------------------------------------------
bq.  
bq.  (Updated 2012-05-12 14:07:22)
bq.  
bq.  
bq.  Review request for Sqoop and Kathleen Ting.
bq.  
bq.  
bq.  Summary
bq.  -------
bq.  
bq.  I've updated corresponding section in Troubleshooting guide.
bq.  
bq.  
bq.  This addresses bug SQOOP-484.
bq.      https://issues.apache.org/jira/browse/SQOOP-484
bq.  
bq.  
bq.  Diffs
bq.  -----
bq.  
bq.    /src/docs/user/troubleshooting.txt 1336267 
bq.  
bq.  Diff: https://reviews.apache.org/r/5065/diff
bq.  
bq.  
bq.  Testing
bq.  -------
bq.  
bq.  
bq.  Thanks,
bq.  
bq.  Jarek
bq.  
bq.


                
> 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
>
>         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 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