wumeng warmerq
warmerq
/ clickhouse-get-tables-size.sql
Created
March 29, 2019 06:25
— forked from sanchezzzhak/clickhouse-get-tables-size.sql
clickhouse get tables size
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT table, | |
| formatReadableSize(sum(bytes)) as size, | |
| min(min_date) as min_date, | |
| max(max_date) as max_date | |
| FROM system.parts | |
| WHERE active | |
| GROUP BY table |
warmerq
/ gist:d9cc06fa8d0c3e20f811cfddc192cdcf
Last active
December 25, 2024 08:47
wm's surfingkeys config
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| api.addSearchAlias('m', '秘塔搜索', 'https://metaso.cn/?q='); | |
| api.map('h', 'E') | |
| api.map('l', 'R') | |
| api.mapkey('yo', 'yank org [[link][title]]', function() { | |
| var org_link = "[[" + document.location.href + "][" + document.title + "]]"; | |
| api.Clipboard.write(org_link); | |
| console.log(org_link); |
warmerq
/ sbt_china_mirror
Created
August 12, 2016 01:36
— forked from manuzhang/sbt_china_mirror
sbt China mirror
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [repositories] | |
| local | |
| oschina: http://maven.oschina.net/content/groups/public/ | |
| oschina-ivy: http://maven.oschina.net/content/groups/public/, [organization]/[module]/(scala_[scalaVersion]/)(sbt_[sbtVersion]/)[revision]/[type]s/[artifact](-[classifier]).[ext] | |
| typesafe: http://repo.typesafe.com/typesafe/ivy-releases/, [organization]/[module]/(scala_[scalaVersion]/)(sbt_[sbtVersion]/)[revision]/[type]s/[artifact](-[classifier]).[ext], bootOnly | |
| #sonatype-oss-releases | |
| #maven-central | |
| #sonatype-oss-snapshots |