[ https://issues.apache.org/jira/browse/HIVE-1263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13017584#comment-13017584 ]
Adam Kramer commented on HIVE-1263: ----------------------------------- Closing in favor of HIVE-306 > Is it time for INSERT APPEND? > ----------------------------- > > Key: HIVE-1263 > URL: https://issues.apache.org/jira/browse/HIVE-1263 > Project: 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. For more information on JIRA, see: http://www.atlassian.com/software/jira