You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@kudu.apache.org by Дмитрий Павлов <dm...@inbox.ru> on 2020/02/03 08:00:04 UTC

Insert vs Upsert

Hi
 
Am I correct to assume that an upsert/update operation takes more resources than an insert in Kudu? 
 
Regards Dmitry

Re[2]: Insert vs Upsert

Posted by Дмитрий Павлов <dm...@inbox.ru>.

Thanks J-D
 
According to your answer i can assume that an update is more expensive but how match in terms of comparing to pure insert?
 
Best Regards, Dmitry
  
>Вторник, 4 февраля 2020, 1:49 +03:00 от Jean-Daniel Cryans <jd...@apache.org>:
> 
>Hi Dmitry,
> 
>It depends if the upsert turns into an insert or an update, and it will share the same characteristics as what it turns into. So if all your upserts turn into inserts, because none of the rows already exist, then it's just like if you had done a pure insert workload.
> 
>Hope this helps,
> 
>J-D   
>On Mon, Feb 3, 2020 at 12:00 AM Дмитрий Павлов < dm.pavlov@inbox.ru > wrote:
>>Hi
>> 
>>Am I correct to assume that an upsert/update operation takes more resources than an insert in Kudu? 
>> 
>>Regards Dmitry  
 
 
--
Дмитрий Павлов

Re: Insert vs Upsert

Posted by Jean-Daniel Cryans <jd...@apache.org>.

Hi Dmitry,

It depends if the upsert turns into an insert or an update, and it will
share the same characteristics as what it turns into. So if all your
upserts turn into inserts, because none of the rows already exist, then
it's just like if you had done a pure insert workload.

Hope this helps,

J-D

On Mon, Feb 3, 2020 at 12:00 AM Дмитрий Павлов <dm...@inbox.ru> wrote:

> Hi
>
> Am I correct to assume that an upsert/update operation takes more
> resources than an insert in Kudu?
>
> Regards Dmitry
>