[HIVE-7179] hive connect to hbase cause select results error

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.12.0
• Component/s: HBase Handler

Environment

Hadoop 1.0.4, HBase 0.94.6.1, Hive 0.12.0

• Assignee: Unassigned
• Reporter: zhengzhuangjie
• Created: 05/Jun/14 08:03
• Updated: 05/Jun/14 08:03

Description

CREATE EXTERNAL TABLE hb_test(key string, `_plat` int, `_uid` int)STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,d:_plat#b,d:_uid#b")TBLPROPERTIES("hbase.table.name" = "test");
insert overwrite local directory '/data/mf/app/data/check' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' select key, `_plat`, `_uid` from hb_test where key>'00604' and key<'00605';

after finish the query, under fold /data/mf/app/data/check output eight files. and each file has the same duplicate data