[
https://issues.apache.org/jira/browse/SQOOP-830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13567379#comment-13567379
]
David Robson commented on SQOOP-830:
------------------------------------
Hi Jarcec,
I have updated the patch as per your comments.
I added some unit tests - while doing so I changed BaseSqoopTestCase to accept
null for values as I did not want to create any rows in the table.
I added a new section to the documentation "Additional Import Configuration
Properties" - this doesn't seem quite ideal either - but I'm guessing the
documentation will have to have a lot of work done for Sqoop2 so I thought that
will probably do for now. Obviously there is a lot of undocumented parameters
like you mentioned - we could add these into the same section and create a
similar section for export parameters and common ones. Or perhaps join them
together?
Anyway I thought doing too much work on the structure of the documentation was
beyond this change so that's what I came up with.
Let me know what you think.
Thanks,
David
> 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
> 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
