Clickhouse常用查询语句

2023-03-09 · 1 分钟阅读 · Clickhouse

连接 Redis

1./redis-cli -h 1.2.3.6 -p 6379 -a 'xxx' --raw

批量删除

1./redis-cli -h 1.10.8.6 -p 6379 -a 'xxx' scan --pattern 'ad_dimension_analysis:*' | xargs redis-cli -h 1.10.8.6 -p 6379 -a 'xxx' del
2
3redis-cli -h 1.10.8.6 -p 6379 -a 'xxx' -n 0 --scan --pattern "ad_dimension_analysis*" | xargs -L 2000 redis-cli -h 1.10.8.6 -p 6379 -a 'xxx' -n 0 del
4
5./redis-cli -h IP -p PORT -a PASSWORD keys 'key*' | xargs  ./redis-cli -h IP  -p PORT -a PASSWORD del