hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Hammerbacher (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1263) Is it time for INSERT APPEND?
Date Sun, 30 May 2010 03:05:56 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12873361#action_12873361
] 

Jeff Hammerbacher commented on HIVE-1263:
-----------------------------------------

Seems like a dupe of HIVE-306; should one of these be closed?

> Is it time for INSERT APPEND?
> -----------------------------
>
>                 Key: HIVE-1263
>                 URL: https://issues.apache.org/jira/browse/HIVE-1263
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Adam Kramer
>
> It seems to me that for someone who did not want to wipe an existing table but just wanted
to add rows to it, that an INSERT APPEND may be desirable. I would expect that the mechanism
by which this would take place is the whole normal mapreduce step as if an OVERWRITE were
taking place, but the end result would be adding files to the hdfs directory rather than wiping
the directory and replacing it with a new one.
> Or failing that, INSERT APPEND could be syntactic sugar for an INSERT OVERWRITE on the
same table, but with the SELECT statement replaced with the user-specified SELECT and UNION
ALL'd on select * for the existing table...which is my current workaround, but seems like
an inelegant query.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message