[SQOOP-830] HBase import formatting BigDecimal inconsistently

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.3
• Assignee: David Robson
• Reporter: David Robson
• Created: 15/Jan/13 23:11
• Updated: 31/Jan/13 19:35
• Resolved: 31/Jan/13 17:28

Description

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".

Issue Links

• links to: Review board