XiaoMi / soar

SQL Optimizer And Rewriter
Apache License 2.0
8.67k stars 1.32k forks source link

建议考虑提高采样性能 #153

Closed saigu closed 5 years ago

saigu commented 5 years ago

Please search the existing issues for relevant feature requests, add upvotes to pre-existing requests.

Feature Description

提高采样性能,目前select * from tablename where random()< factor limit 30000的形式在大表性能很差,是很慢的慢查询,希望能解决

Use Case(s)

千万的表中,大概需要几十秒。。。。。

Any relevant use-cases that you see.

martianzhang commented 5 years ago

在 #174 中,我们新增了-sampling-condition可以通过WHERE条件指定采样算法。