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: Intermediate data format configurable null values
Date Mon, 10 Nov 2014 22:23:33 GMT

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

Abraham Elmahrek updated SQOOP-1678:
------------------------------------
    Description: 
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 Intermediate Data
Format 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.

  was:
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}


> Sqoop2: Intermediate data format configurable null values
> ---------------------------------------------------------
>
>                 Key: SQOOP-1678
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1678
>             Project: Sqoop
>          Issue Type: Bug
>            Reporter: Abraham Elmahrek
>            Assignee: Abraham Elmahrek
>             Fix For: 1.99.5
>
>
> 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 Intermediate
Data Format 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