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)

Reply via email to