[HIVE-2828] make timestamp accessible in the hbase KeyValue

• Type: Improvement
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: HBase Handler
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 28/Feb/12 00:48
• Updated: 15/Aug/18 14:16
• Resolved: 16/Oct/14 05:02

Description

Originated from HIVE-2781 and not accepted, but I think this could be helpful to someone.

By using special column notation ':timestamp' in HBASE_COLUMNS_MAPPING, user might access timestamp value in hbase KeyValue.

CREATE TABLE hbase_table (key int, value string, time timestamp)
  STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
  WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")

Issue Links

• blocks: HIVE-8267 Exposing hbase cell latest timestamp through hbase columns mappings to hive columns.
• duplicates: HIVE-2306 Hbase's timestamp attribute to be mapped for read or write, and then import data of timestamp to hbase's table from hive
• links to: review board