hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gallardot.Tan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-3863) with the hbase table,INSERT INTO can't append to the hive table
Date Sun, 06 Jan 2013 02:52:12 GMT
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

Mime
View raw message