[
https://issues.apache.org/jira/browse/HIVE-1263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Kramer resolved HIVE-1263.
-------------------------------
Resolution: Duplicate
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
