[ 
https://issues.apache.org/jira/browse/SQOOP-830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13567992#comment-13567992
 ] 

Hudson commented on SQOOP-830:
------------------------------

Integrated in Sqoop-ant-jdk-1.6-hadoop200 #537 (See 
[https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/537/])
    SQOOP-830: HBase import formatting BigDecimal inconsistently (Revision 
7c5b46fb2860e7401e84542a01a61ef415cbe519)

     Result = SUCCESS
jarcec : 
https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=7c5b46fb2860e7401e84542a01a61ef415cbe519
Files : 
* src/java/org/apache/sqoop/hbase/HBasePutProcessor.java
* src/java/org/apache/sqoop/mapreduce/ImportJobBase.java
* src/test/com/cloudera/sqoop/testutil/BaseSqoopTestCase.java
* src/docs/user/import.txt
* src/test/org/apache/sqoop/TestBigDecimalImport.java
* src/java/org/apache/sqoop/orm/ClassWriter.java
* src/java/org/apache/sqoop/hbase/ToStringPutTransformer.java
* src/test/org/apache/sqoop/TestBigDecimalExport.java
* src/java/org/apache/sqoop/mapreduce/AvroImportMapper.java

                
> HBase import formatting BigDecimal inconsistently
> -------------------------------------------------
>
>                 Key: SQOOP-830
>                 URL: https://issues.apache.org/jira/browse/SQOOP-830
>             Project: Sqoop
>          Issue Type: Bug
>            Reporter: David Robson
>            Assignee: David Robson
>             Fix For: 1.4.3
>
>         Attachments: SQOOP-830.patch, SQOOP-830.patch
>
>
> When importing into HBase the toString() method is called on every field via 
> the ToStringPutTransformer class.
> When the field is mapped as a BigDecimal - as it is with number fields in 
> Oracle - this results in inconsistent formats in HBase.
> For example - create the following in Oracle:
> CREATE TABLE employee(id number primary key, test_number number);
> INSERT INTO employee values(1, 0.000001);
> INSERT INTO employee values(2, 0.0000001);
> COMMIT;
> Then run an import:
> sqoop import --connect jdbc:oracle:thin:@//HOSTNAME/SERVICE --username 
> USERNAME --table EMPLOYEE --password PASSWORD --hbase-table EMPLOYEE 
> --column-family tst --hbase-create-table
> The value for row 1 is "0.000001" while row 2 is "1E-7".

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to