[ 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.