[SQOOP-3125] NULL updates are not pulled into Hbase whenever incremental load happens in sqoop

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.6
• Component/s: connectors/oracle

Environment

MapR Hadoop

• Assignee: Unassigned
• Reporter: Selvakumar
• Created: 18/Jan/17 20:06
• Updated: 07/Apr/17 15:27

Description

Ingesting data from Oracle to HBase using Sqoop and fetching data from HBase using Hive tables using HBaseStorageHandler.

Problem is whenever incremental load happens from Sqoop and if a column is updated with "null",

HBase doesn't gets updated with null value for that cell and when the data is fetched from HBase using Hive table it fetches last updated timestamp record.

So the entire record becomes inconsistent as for all the columns it shows updated value and for the "null" column it shows old value of it as timestamp is not updated.