Lesser known features of ClickHouse

Re:Lesser known features of ClickHouse by zX41ZdbW on Monday May 30, 2022 @06:56PM (#31564507)

I recommend to write a follow-up with the topics:

1. clickhouse-git-import tool, what is it and how to use it. 2. ClickHouse as a monitoring agent with the system.asynchronous_log table. 3. Hosting static MergeTree tables on any web server.

[ Parent | on HN ]

Re:Lesser known features of ClickHouse by pradeepchhetri on Tuesday May 31, 2022 @01:35AM (#31566410)

Thank you for your response and going through the blog. I am curious about how to implement

2. ClickHouse as a monitoring agent with the system.asynchronous_log table.

Can you share some links around it.

[ Parent | on HN ]

Re:Lesser known features of ClickHouse by zX41ZdbW on Wednesday June 01, 2022 @03:36AM (#31579145)

About the system.asynchronous_metric_log table.

It's very simple. Every ClickHouse instance, even empty, is collecting system-wide monitoring information. You can query this table directly from Grafana dashboard (for example).

[ Parent | on HN ]

Re:Lesser known features of ClickHouse by pradeepchhetri on Wednesday June 01, 2022 @03:52AM (#31579263)

Good idea, makes sense. Thank you!

[ Parent | on HN ]

Re:Lesser known features of ClickHouse by gauravphoenix on Tuesday May 31, 2022 @06:16PM (#31575606)

>3. Hosting static MergeTree tables on any web server.

Can you share some docs on that? AFAIK CH can use web server hosted data sources but I don't recall CH able to host merge tree tables on HTTP servers.

[ Parent | on HN ]

Re:Lesser known features of ClickHouse by js2 on Tuesday May 31, 2022 @06:27PM (#31575689)

(1) is answered here https://github.com/apache/incubator-devlake/issues/1771

[ Parent | on HN ]