You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "nemon lou (JIRA)" <ji...@apache.org> on 2012/05/05 15:19:48 UTC

[jira] [Issue Comment Edited] (SQOOP-482) import tool for mysql direct mode reports wrong record number

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

nemon lou edited comment on SQOOP-482 at 5/5/12 1:17 PM:
---------------------------------------------------------

Update the JIRA patch
                
      was (Author: nemon):
    Update the JIRA path
                  
> import tool for mysql direct mode reports wrong record number
> -------------------------------------------------------------
>
>                 Key: SQOOP-482
>                 URL: https://issues.apache.org/jira/browse/SQOOP-482
>             Project: Sqoop
>          Issue Type: Bug
>          Components: connectors/mysql
>    Affects Versions: 1.4.1-incubating
>         Environment: hadoop 1.0.0
>            Reporter: nemon lou
>            Priority: Minor
>             Fix For: 1.4.2-incubating
>
>         Attachments: SQOOP-482-1.patch, directmodewrongnumber.patch
>
>
> When run the sqoop import (via mysqldump) task :
> sqoop import --connect jdbc:mysql://[ip]:3306/mysqlslap --table t1    --username root -P  --hive-import --hive-overwrite   --hive-table tTable --verbose --direct -m 1
> The console shows this(part of the log):
>   12/05/02 16:21:16 INFO mapred.JobClient:     Map output records=6000594
>   12/05/02 16:21:16 INFO mapreduce.ImportJobBase: Retrieved 6000594 records.
> However,the real record number in mysql is 1000099.And the number of records in hive is  1000099 ,too.
> So only the console log report the wrong number.

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