[HIVE-24407] Unable to read data with Hbase snapshot set

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: HBase Handler
• Assignee: Unassigned
• Reporter: Ayush Saxena
• Created: 20/Nov/20 12:17
• Updated: 20/Nov/20 12:17

Description

1. CREATE TABLE foo(rowkey STRING, a STRING ) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,f:c1') TBLPROPERTIES ('hbase.table.name' = 'foo');
2. insert into foo values('row0','0'),('row1','1'),('row2','2');
3. Move To Hbase-shell
4. hbase(main):002:0> snapshot 'foo','testing'
5. set hive.hbase.snapshot.name=testing;
6. select count FROM foo WHERE rowkey = 'row0';

This should return 1, but doesn't