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.
