Re: will upsert have bad effect on scan performace?

2018-05-21 Thread Todd Lipcon
Hi Andy, An upsert of a row that does not exist is exactly the same as an insert. You can think of upsert as: try { insert the row } catch (Already Exists) { update the row } In reality, the conversion from insert to update is a bit more efficient compared to doing the above yourself (and i

will upsert have bad effect on scan performace?

2018-05-21 Thread Andy Liu
Thanks in advance. hi, i have used java upsert api to load data instead of insert api. will it have a bad effect even though these data were firstly loaded. i do not know compaction mechanism of kudu, will it lead to many compaction, thus lead to bad scan performance. Best regards.