[ https://issues.apache.org/jira/browse/SQOOP-2976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16364122#comment-16364122 ]
Hudson commented on SQOOP-2976: ------------------------------- SUCCESS: Integrated in Jenkins build Sqoop-hadoop200 #1146 (See [https://builds.apache.org/job/Sqoop-hadoop200/1146/]) SQOOP-2976: Flag to expand decimal values to fit AVRO schema (bogi: [https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=f7b460b3f57c1bc81e2e0a1e8c28a331729f4213]) * (delete) src/test/org/apache/sqoop/testutil/ArgumentUtils.java * (edit) src/test/org/apache/sqoop/TestAvroImport.java * (edit) src/test/org/apache/sqoop/metastore/TestMetastoreConfigurationParameters.java * (add) src/test/org/apache/sqoop/manager/sqlserver/SQLServerAvroPaddingImportTest.java * (edit) src/java/org/apache/sqoop/avro/AvroUtil.java * (add) src/test/org/apache/sqoop/manager/hsqldb/TestHsqldbAvroPadding.java * (edit) src/test/org/apache/sqoop/testutil/BaseSqoopTestCase.java * (edit) src/java/org/apache/sqoop/mapreduce/AvroImportMapper.java * (edit) src/java/org/apache/sqoop/config/ConfigurationConstants.java * (add) src/test/org/apache/sqoop/manager/oracle/OracleAvroPaddingImportTest.java * (add) src/test/org/apache/sqoop/testutil/ArgumentArrayBuilder.java * (add) src/test/org/apache/sqoop/testutil/AvroTestUtils.java > 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)