ClickHouse code style recommends unsigned in every case when you don't need the sign: https://clickhouse.com/docs/development/style
Unsigned is necessary only if you're working with bit fields, bit masks or require explicit modulo n-bit arithmetic.
For all other cases, use signed