[Question] Why does the same repository have two different IDs in the clickhouse?

[Peng99999]

Description

When attempting to query the "repo_id" by "repo_name" in the "gh_events" table, I noticed that the same repository has multiple IDs, as shown in the image below. I would like to ask what the reason for this and which ID should be used to represent the “repo_id” for this repository.

[frank-zsy]

In the GitHub events log, one repo ID may have multiple different repo names and one repo name also may have multiple different IDs. The reason is that:

• If I created a repo with name a/b, then deleted the repo and recreated a repo called a/b, then a/b will have two different IDs with same name.
• If I created a repo with name a/b, then changed the name of the repo to a/c, then the ID will have two different repo names. To determine which ID or name to use depends on what you need, in most common scenario you may use the most recent ID or name, you can use argMax to get the ID or name first and use it after.

[Peng99999]

I got it. Thanks !