[HIVE-3863] with the hbase table,INSERT INTO can't append to the hive table

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

Environment

ubuntu 12.04 hadoop 1.0.2 hbase 0.94.1 hive 0.9.0

• Assignee: Unassigned
• Reporter: Hengliang Tan
• Created: 06/Jan/13 02:50
• Updated: 06/Jan/13 02:51

Description

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML
quote the LanguageManual:
"
INSERT OVERWRITE will overwrite any existing data in the table or partition
unless IF NOT EXISTS is provided for a partition (as of Hive 0.9.0)
INSERT INTO will append to the table or partition keeping the existing data in tact. (Note: INSERT INTO syntax is only available starting in version 0.8)

"

my hql like "insert into table hive_table select xx from hbase_table" and "insert overwrite table hive_table select xx from hbase_table"

i want to insert data into the hive table from the hbase table. but INSERT INTO can't append to the table, it overwrite the table.

is it a bug?