Home / Companies / ClickHouse / Blog / Post Details
Content Deep Dive

Git commits and our community

Blog post from ClickHouse

Post Details
Company
Date Published
Author
The ClickHouse team
Word Count
1,011
Company Posts That Month
6
Language
English
Hacker News Points
-
Post removed?
No
Summary

The `git-import` tool is a distributed tool with ClickHouse that extracts information from Git repositories for analytics purposes. It generates three main tables: commits, file changes, and line changes, which can be loaded into ClickHouse or other DBMS. The generated data includes over 7 million rows of commits, 53 million rows of file changes, and 2.7 GB of line changes, providing a wealth of information for analysis. The tool proposes several questions for users to answer, including the reconstruction of the `git blame` command, which is particularly challenging due to ClickHouse's lack of arrayFold or arrayReduce functions. Users are encouraged to solve this query and others using the generated data, with a t-shirt prize offered for the first correct solution. The tool also provides some tips for users to keep in mind when working with the data, including checking out the same commit for comparison and considering file renames that affect change history.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.