[ https://issues.apache.org/jira/browse/SQOOP-2976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16364091#comment-16364091 ]
ASF subversion and git services commented on SQOOP-2976: -------------------------------------------------------- Commit f7b460b3f57c1bc81e2e0a1e8c28a331729f4213 in sqoop's branch refs/heads/trunk from [~BoglarkaEgyed] [ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=f7b460b ] SQOOP-2976: Flag to expand decimal values to fit AVRO schema (Ferenc Szabo via Boglarka Egyed) > 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)