HaUniqueMergeTree'男装', 5, 500),('2020-10-29 23:40:00', 10002, 'Beijing', '男装', 2, 200),('2020-10-29 23:40:00', 10003, 'Beijing', '男装', 1, 100);INSERT INTO t2 (event_time, product_id, city, category, amount, revenue) VALUES('2020-10-29 23:50:00', 10002, 'Beijing', '男装', 4, 400),('2020-10-29 23:50:00', 10003, 'Beijing', '男装', 2, 200),('2020-10-29 23:50:00', 10004, 'Beijing', '男装', 1, 100),('2020-10-30...
ByteHouse Unique 表最佳实践'男装', 5, 500),('2020-10-29 23:40:00', 10002, 'Beijing', '男装', 2, 200),('2020-10-29 23:40:00', 10003, 'Beijing', '男装', 1, 100),('2020-10-29 23:50:00', 10002, 'Shanghai', '男装', 4, 400),('2020-10-29 23:50:00', 10003, 'Beijing', '男装', 2, 200),('2020-10-29 23:50:00', 10004, 'Beijing', '男装', 1, 100);-- 写入相同 key 的数据可以实现更新(upsert语义),即如果 key 不存在则插入数据,否则更新这条数据...