[HIVE-14411] selecting Hive on Hbase table may cause FileNotFoundException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 2.2.0
• Component/s: Physical Optimizer
• Target Version/s: 2.2.0
• Assignee: Niklaus Xiao
• Reporter: Rudd Chen
• Created: 03/Aug/16 11:27
• Updated: 26/Jul/17 03:30
• Resolved: 05/Aug/16 02:01

Description

1. create a Hbase table hbase_table
2. create a external Hive table test_table mapping to the hbase table

example:

create 'hbase_t' ,

{NAME=>'cf',COMPRESSION=>'snappy'}

,

{NUMREGIONS=>15,SPLITALGO=>'HexStringSplit'}

create external table hbase_t_hive(key1 string,cf_train string,cf_flight string,cf_wbsw string,cf_wbxw string,cf_bgrz string,cf_bgtf string)
stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
with serdeproperties("hbase.columns.mapping"=":key,cf:train,cf:flight,cf:wbsw,cf:wbxw,cf:bgrz,cf:bgtf") tblproperties("hbase.table.name"="hbase_t");

create table test3 as select * from hbase_t_hive where 1=2;

====

if hive.optimize.null.scan=true, it will return an FileNotFoundException