Skip to content

Instantly share code, notes, and snippets.

@gingerwizard
Created February 8, 2024 11:38
Show Gist options
  • Save gingerwizard/5a9a87a39ba93b422d8640d811e269e9 to your computer and use it in GitHub Desktop.
Save gingerwizard/5a9a87a39ba93b422d8640d811e269e9 to your computer and use it in GitHub Desktop.
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' ','
@tylerhannan
Copy link

This is very elegant.

I tend to do it in a "clickhouse-local" way as follows:

Prior Release: sudo docker run --rm clickhouse/clickhouse-server:24.3 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name" > contributors_24.3.txt

Current Release: sudo docker run --rm clickhouse/clickhouse-server:24.4 clickhouse-local --query "SELECT * FROM system.contributors ORDER BY name" > contributors_24.4.txt

Comparing the two using ClickHouse Local:

./clickhouse local --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"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment