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] [Updated] (HIVE-3863) with the hbase table,INSERT INTO can't append to the hive table
Date Sun, 06 Jan 2013 02:52:12 GMT

     [ 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

Mime
View raw message