[ https://issues.apache.org/jira/browse/SQOOP-2976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ferenc Szabo reassigned SQOOP-2976: ----------------------------------- Assignee: Ferenc Szabo > 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 > > 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)