sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-2976) Flag to expand decimal values to fit AVRO schema
Date Wed, 21 Mar 2018 14:54:00 GMT

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

ASF subversion and git services commented on SQOOP-2976:
--------------------------------------------------------

Commit d57f9fb06b55650adc75cd1972df0024d7e4dba1 in sqoop's branch refs/heads/trunk from [~vasas]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=d57f9fb ]

SQOOP-3293: Document SQOOP-2976

(Fero Szabo by Szabolcs Vasas)


> Flag to expand decimal values to fit AVRO schema
> ------------------------------------------------
>
>                 Key: SQOOP-2976
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2976
>             Project: Sqoop
>          Issue Type: Improvement
>    Affects Versions: 1.4.6
>            Reporter: Thomas Scott
>            Assignee: Fero Szabo
>            Priority: Major
>             Fix For: 1.5.0
>
>         Attachments: SQOOP-2976.patch, SQOOP-2976.patch
>
>
> As per https://issues.apache.org/jira/browse/AVRO-1864 when importing from Oracle (or
any other database that truncates decimals) Sqoop jobs can fail because the scale of the decimal
produced by the database does not match the scale in the AVRO file.
> For instance if the value 3.15 is produced by Oracle and the AVRO decimal scale  is 3
(this can happen even if the Oracle column is defined with scale of 3) then the job will fail.

> Can we have a flag (--pad-decimals) that pads incoming values with zeros to fit the AVRO
schema (e.g. 3.15 becomes 3.150).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message