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

Ferenc Szabo updated SQOOP-2976:
--------------------------------
    Attachment: SQOOP-2976.patch

> 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: Ferenc Szabo
>            Priority: Major
>         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)

Reply via email to