1. Machine Learning with ClickHouseMachine Learning with ClickHouse Nikolai Kochetov, ClickHouse developer Experimental dataset NYC Taxi and Uber Trips › Where to download: https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page sample data SAMPLE x OFFSET y Must specify an expression for sampling › Optimized by PK › Fixed dataset for fixed sample query › Only for MergeTree 11 / 62 How to sample data SAMPLE x OFFSET y CREATE0 码力 | 64 页 | 1.38 MB | 1 年前3- 0. Machine Learning with ClickHouse Machine Learning with ClickHouse Nikolai Kochetov, ClickHouse developer Experimental dataset NYC Taxi and Uber Trips › Where to download: https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page sample data SAMPLE x OFFSET y Must specify an expression for sampling › Optimized by PK › Fixed dataset for fixed sample query › Only for MergeTree 11 / 62 How to sample data SAMPLE x OFFSET y CREATE0 码力 | 64 页 | 1.38 MB | 1 年前3
ClickHouse: настоящее и будущееsubcolumns • Query nested data naturally Support For Semistructured Data 28 Example: NBA games dataset CREATE TABLE games (data String) ENGINE = MergeTree ORDER BY tuple(); SELECT JSONExtractString(data0 码力 | 32 页 | 2.62 MB | 1 年前3- ClickHouse: настоящее и будущееsubcolumns • Query nested data naturally Support For Semistructured Data 28 Example: NBA games dataset CREATE TABLE games (data String) ENGINE = MergeTree ORDER BY tuple(); SELECT JSONExtractString(data0 码力 | 32 页 | 776.70 KB | 1 年前3
共 4 条
- 1