Gallardot.Tan created HIVE-3863:
-----------------------------------

             Summary: with the hbase table,INSERT INTO can't append to the hive 
table
                 Key: HIVE-3863
                 URL: https://issues.apache.org/jira/browse/HIVE-3863
             Project: Hive
          Issue Type: Bug
          Components: HBase Handler
    Affects Versions: 0.9.0
         Environment: ubuntu 12.04 hadoop 1.0.2 hbase 0.94.1 hive 0.9.0
            Reporter: Gallardot.Tan
            Priority: Minor


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 hive_table select xx from hbase_table" and "insert 
overwrite 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? 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to