Thomas Scott created SQOOP-2976:
-----------------------------------
Summary: 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
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
(v6.3.4#6332)