AnsweredAssumed Answered

NULL updates are not pulled into Hbase whenever incremental load happens in sqoop

Question asked by selvakumar7 on Jan 18, 2017
Latest reply on Jan 18, 2017 by MichaelSegel

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.

 

Can someone help me to resolve this issue?

 

Thanks,

Selva

Outcomes