You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Mengwei Ding (JIRA)" <ji...@apache.org> on 2013/07/10 20:43:49 UTC

[jira] [Commented] (SQOOP-1049) Sqoop2: Record not imported if partition column value is NULL

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

Mengwei Ding commented on SQOOP-1049:
-------------------------------------

This only happens when the values for partition column contain both null and non-null values. When all the values is not null, everything is good. When all the values is null, it could happen another problem, which is recorded by SQOOP-1130 https://issues.apache.org/jira/browse/SQOOP-1130
                
> Sqoop2: Record not imported if partition column value is NULL
> -------------------------------------------------------------
>
>                 Key: SQOOP-1049
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1049
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.99.2
>         Environment: Mysql
>            Reporter: Vasanth kumar RJ
>            Assignee: Mengwei Ding
>             Fix For: 2.0.0
>
>
> In Sqoop2, if the partition column is NULL then record is not imported.
> For table t with id (int) and name columns, insert NULL value for id. where id is partition column. Then perform import from Sqoop2 and now id with NULL value is not imported.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira