how hive can read Hbase current and previous versions data?

[#1 · Accepted solution]

As far as I know, Hive can read only the current (most recent) data version in HBase. Only when using HBase API or hbase shell you can also read all versions, or only the ones in a specific time interval.

From the Hive HBase integration document: there is currently no way to access the HBase timestamp attribute, and queries always access data with the latest timestamp.

[#2]

Thanks for replying.

if not hive can impala read all versions in HBase?

[#3]

No, Impala cannot read all versions either. Impala defines tables in HBase using Hive DDL because Impala doesn't support custom SerDe's to define tables, and as we saw Hive doesn't expose HBase timestamps (more detail about Impala and HBase here). So, if you want to access timestamps you have to make them "first class citizens" and include them in your Hbase table key, or among values, if you can ensure unique keys by other means.

[#4]

thank you 🙂

[#5]

Okay, no problems, please consider to accept the answer, to help us manage answered questions. Tnx!

[#6]

currently there is no way available to read all the versions data.