Duplicated key tables are designed for append-only workloads. If you want data updates, especially in real-time, I would recommend using the primary key table. Keep in mind that StarRocks is an OLAP database with a columnar storage, which functions very differently than MYSQL. Even with primary key, keep the updates a few second apart for stability.
@@gkrv6726You can, but do it in batch. With Dup key tables, do it in really large batches, in primary key tables you can do it with small batches with few seconds intervals in between each
🌟Join StarRocks Community on Slack: try.starrocks.com/join-starrocks-on-slack
Hi Sir, How can we perform ON DUPLUCATE KEY UPDATE in star rock like MYSQL?
Duplicated key tables are designed for append-only workloads. If you want data updates, especially in real-time, I would recommend using the primary key table. Keep in mind that StarRocks is an OLAP database with a columnar storage, which functions very differently than MYSQL. Even with primary key, keep the updates a few second apart for stability.
@@stanshen5207 Thanks sir. So we can't perform the INSERT/UPDATE in single query like mysql (Upsert) and ORACLE (Merge)... isn't?
@@gkrv6726You can, but do it in batch. With Dup key tables, do it in really large batches, in primary key tables you can do it with small batches with few seconds intervals in between each
@@gkrv6726 You can, the syntax supports it (primary key). Just keep the updates a few seconds apart.