zjp-CN
zjp-CN
### Code ```Rust pub struct Scroll(L); pub trait Bound {} impl Scroll { // happens to be the same name with methods in ATraitSomewhere pub fn f(&self) -> usize {...
v0.4.0 删除所有异步代码(async http client,每次更新数据不超过 2s),但自此之后需要 1 分钟才能完成日线更新。 需要基准测试确认原因。
完善文档
- 库文档:[docs.rs/rustdx](https://docs.rs/rustdx) - cmd 文档:[README](https://github.com/zjp-CN/rustdx/blob/main/rustdx-cmd/README.md) 【注】此项目为个人非盈利维护,文档尽量做到完善。
截止 2022-10-21 ```sql # src: https://gist.github.com/sanchezzzhak/511fd140e8809857f8f1d84ddb937015?permalink_comment_id=3159885#gistcomment-3159885 select concat(database, '.', table) as table, formatReadableSize(sum(bytes)) as size, sum(rows) as rows, max(modification_time) as latest_modification, sum(bytes) as bytes_size, any(engine) as engine, formatReadableSize(sum(primary_key_bytes_in_memory)) as primary_keys_size...
```SQL -- 计算复权数据 DROP TABLE IF EXISTS rustdx.qfq_x; CREATE TABLE rustdx.qfq_x ( -- 前复权系数 code FixedString(6), x Float64, PRIMARY KEY(code) ) ENGINE = MergeTree AS WITH qfq AS ( SELECT...
[ReplacingMergeTree](https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/replacingmergetree) 来防止(删除)重复数据。由于异步调度和删除(而且发生在未知时刻),需要使用 OPTIMIZE 语句 ( #24 ) 尽快(但依然无法保证立即)删除重复数据。
https://clickhouse.com/docs/en/sql-reference/statements/optimize/