Re: Dynamic INSERT OVERWRITE

2021-01-30 Thread Zoltán Borók-Nagy
Thanks for your answer, Ryan. In the short term we'll only have INSERT INTO/OVERWRITE for Icebeg tables in Impala (so the way to go is AppendFiles and ReplacePartitions accordingly). But I agree that a MERGE INTO statement would be super useful. Hopefully we'll add support for it as well in the not

Re: Dynamic INSERT OVERWRITE

2021-01-29 Thread Ryan Blue
Zoltan, The warning is that dynamic overwrites in general aren't recommended. ReplacePartitions is the right operation to use for dynamic overwrite, we just want to steer users away from dynamic overwrites in general. The problem with dynamic overwrite is that its behavior depends on the underlyi