You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Gallardot.Tan (JIRA)" <ji...@apache.org> on 2013/01/06 03:52:12 UTC
[jira] [Updated] (HIVE-3863) with the hbase table,INSERT INTO can't
append to the hive table
[ https://issues.apache.org/jira/browse/HIVE-3863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gallardot.Tan updated HIVE-3863:
--------------------------------
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?
was:
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?
> 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 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?
--
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