[
https://issues.apache.org/jira/browse/SQOOP-1678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14241838#comment-14241838
]
Sqoop QA bot commented on SQOOP-1678:
-------------------------------------
Testing file
[SQOOP-1678.3.patch|https://issues.apache.org/jira/secure/attachment/12686379/SQOOP-1678.3.patch]
against branch sqoop2 took 0:23:45.031754.
{color:green}Overall:{color} +1 all checks pass
{color:green}SUCCESS:{color} Clean was successful
{color:green}SUCCESS:{color} Patch applied correctly
{color:green}SUCCESS:{color} Patch add/modify test case
{color:green}SUCCESS:{color} Patch compiled
{color:green}SUCCESS:{color} All unit tests passed
{color:green}SUCCESS:{color} All integration tests passed
Console output is available
[here|https://builds.apache.org/job/PreCommit-SQOOP-Build/741/console].
This message is automatically generated.
> Sqoop2: [HDFS Connector] Configurable null values
> -------------------------------------------------
>
> Key: SQOOP-1678
> URL: https://issues.apache.org/jira/browse/SQOOP-1678
> Project: Sqoop
> Issue Type: Improvement
> Components: sqoop2-hdfs-connector
> Affects Versions: 1.99.4
> Reporter: Abraham Elmahrek
> Assignee: Abraham Elmahrek
> Fix For: 1.99.5
>
> Attachments: SQOOP-1678.0.patch, SQOOP-1678.1.patch,
> SQOOP-1678.2.patch, SQOOP-1678.3.patch
>
>
> Jobs should be able to define what the null values look like.
> Simple table:
> {noformat}
> +-------+-------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +-------+-------------+------+-----+---------+-------+
> | id | int(11) | NO | PRI | 0 | |
> | name | varchar(35) | YES | | NULL | |
> +-------+-------------+------+-----+---------+-------+
> {noformat}
> Content:
> {noformat}
> +----+------+
> | id | name |
> +----+------+
> | 1 | |
> | 2 | test |
> +----+------+
> 2 rows in set (0.00 sec)
> {noformat}
> Assuming the above blank "name" is null, then we should be able to tell the
> HDFS connector to choose different representations of NULL. Current default
> is NULL, but a blank value may be preferred instead:
> {noformat}
> 1,NULL
> {noformat}
> or
> {noformat}
> 1,
> {noformat}
> or
> {noformat}
> 1,-
> {noformat}
> etc.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
