Streaming accelerate AP business by Chengyou Liu from Risingwave信息安全资料信息安全资料信息安全资料.docxVIP

刘成友，RisingWaveLabs，2023.04AdaptedslidesfromNoelKwanRisingWavexClickHouse

刘成友，RisingWaveLabs，2023.04

AdaptedslidesfromNoelKwan

RisingWavexClickHouse

Streaming加速AP业务

AboutMe现就职于RisingWave

AboutMe

现就职于RisingWaveLabs，PerfReliability。主要负责性能测试，系统

测试，QA基础设施

曾就职于PingCAP，EMC从事数据库和存储等基础设施的QA工作

曾在G7担任过风控业务的研发

2

AgendaBatchvs

Agenda

BatchvsStream

RisingWave

RisingWave+ClickHouse

3

Batchvs

BatchvsStream

4

BatchvsStreamIndexnestedLoop(A.x=C.x)Merge–Join(A.x=B.x)IndexScanCEventsDatabaseeverytimeSortSortTableScanATableScanB SELECT*FROMAJOINBONA.