Why don't you use a OLAP database that support primary key like StarRocks. That ways you can do updates and upserts.