Dale McDiarmid

Results 194 comments of Dale McDiarmid

better ```sql WITH ( SELECT sum(count) AS total FROM pypi.pypi_downloads_per_day WHERE project = {package_name:String} AND 1=1 AND 1=1 AND date > {min_date:String}::Date32 AND date {min_date:String}::Date32 AND date downloads )) as...

Include detailed page on projections and how they work.

We should use the click-ui widget.

Renamed to stable packages https://github.com/ClickHouse/clickpy/pull/151

Using the JSON type and trying to think how people will use this when querying logs and traces. I think the following shows some challenges when we get dirty values...

also this seems to be a behavior of the max function, other functions like avg actually do error ``` SELECT json.status AS s, avg(json.rt) FROM t GROUP BY s Query...

Can't test, throws application error on clicking on a package from landing.

https://github.com/ClickHouse/ClickHouse/pull/73098 thanks @alsugiliazova

@lio-p i thought the plan was to update https://clickhouse.com/docs/migrations/postgres/migrations/postgresql