Skip to content

Instantly share code, notes, and snippets.

@mneedham
Created May 3, 2024 13:16
Show Gist options
  • Save mneedham/167262d22e8ab4023586506b4e82dd67 to your computer and use it in GitHub Desktop.
Save mneedham/167262d22e8ab4023586506b4e82dd67 to your computer and use it in GitHub Desktop.
Latest ClickHouse Contributors
docker run --rm clickhouse/clickhouse-server:24.3 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name" > contributors_24.3.txt
docker run --rm clickhouse/clickhouse-server:24.4 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name" > contributors_24.4.txt
./clickhouse --query "
    SELECT arrayStringConcat(groupArray(line), ', ')
    FROM file('contributors_24.4.txt', LineAsString)
    WHERE line NOT IN (
        SELECT *
        FROM file('contributors_24.3.txt', LineAsString))
    FORMAT TSVRaw"
diff -u <(docker run --rm clickhouse/clickhouse-server:23.12 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name") <(docker run --rm clickhouse/clickhouse-server:24.1 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name") | 
grep -E "^\+" | 
tail -n +2 | 
sed 's/^\+//' | 
tr '\n' ','
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment