sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sqoop QA bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-1678) Sqoop2: [HDFS Connector] Configurable null values
Date Wed, 10 Dec 2014 17:35:12 GMT

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

Sqoop QA bot commented on SQOOP-1678:
-------------------------------------

Testing file [SQOOP-1678.1.patch|https://issues.apache.org/jira/secure/attachment/12686300/SQOOP-1678.1.patch]
against branch sqoop2 took 0:23:27.895951.

{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/737/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
>
>
> 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)

Mime
View raw message