sqoop-dev mailing list archives

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

     [ https://issues.apache.org/jira/browse/SQOOP-1678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Abraham Elmahrek updated SQOOP-1678:
------------------------------------
    Attachment: SQOOP-1678.2.patch

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