#clickhouse
2023-07-01
2023-07-03
幾個步驟跑政治獻金資料分析
```$ curl -sL -O https://github.com/g0v/tw_campaign_finance/raw/main/vgplot/data/corporation_contribution.parquet
$ curl https://clickhouse.com/ | sh # needs 2.4GB disk space
$ gem install youplot
$ ./clickhouse local -q "select candidate, sum(income_amount) as income_amount from file('corporation_contribution.parquet') where election_name = '109年立法委員選舉' group by candidate order by income_amount desc limit 20 format CSVWithNames" | uplot bar -d, -H -t "109年立法委員選舉政治獻金排行"```
```$ curl -sL -O https://github.com/g0v/tw_campaign_finance/raw/main/vgplot/data/corporation_contribution.parquet
$ curl https://clickhouse.com/ | sh # needs 2.4GB disk space
$ gem install youplot
$ ./clickhouse local -q "select candidate, sum(income_amount) as income_amount from file('corporation_contribution.parquet') where election_name = '109年立法委員選舉' group by candidate order by income_amount desc limit 20 format CSVWithNames" | uplot bar -d, -H -t "109年立法委員選舉政治獻金排行"```
pm5
幾個步驟跑政治獻金資料分析
```bash
$ curl -sL -O https://github.com/g0v/tw_campaign_finance/raw/main/vgplot/data/corporation_contribution.parquet
$ curl https://clickhouse.com/ | sh # needs 2.4GB disk space
$ gem install youplot
$ ./clickhouse local -q "select candidate, sum(income_amount) as income_amount from file('corporation_contribution.parquet') where election_name = '109年立法委員選舉' group by candidate order by income_amount desc limit 20 format CSVWithNames" | uplot bar -d, -H -t "109年立法委員選舉排行"```
```bash
$ curl -sL -O https://github.com/g0v/tw_campaign_finance/raw/main/vgplot/data/corporation_contribution.parquet
$ curl https://clickhouse.com/ | sh # needs 2.4GB disk space
$ gem install youplot
$ ./clickhouse local -q "select candidate, sum(income_amount) as income_amount from file('corporation_contribution.parquet') where election_name = '109年立法委員選舉' group by candidate order by income_amount desc limit 20 format CSVWithNames" | uplot bar -d, -H -t "109年立法委員選舉排行"```
2023-07-13
Replied to a thread: 2023-06-22 23:37:07
https://www.loom.com/share/e213768457094a3187663a6cff76a61d?sid=33573356-b205-415d-8cac-591b653812de
very neat motherduck demo, with postgres_scanner and loading from s3
very neat motherduck demo, with postgres_scanner and loading from s3
Loom
Hey folks, this is Sung, and in this video, I'm going to give you a demo of MotherDuck and explain why it matters. The problem I'm trying to solve is how to scale DuckDB, a great single-player experience, into a multiplayer experience where your work doesn't just live on your personal computer. MotherDuck is the answer to that problem. I'll show you the surface area for collaboration in Motherduck and how it integrates with different systems. Join me as we explore the evolutionary steps of turning DuckDB into a production-grade cloud solution and broadening its impact beyond just the data team.
2023-07-14
@yihuai0816 has joined the channel
2023-07-25
@chewei has joined the channel
clkao
我明天會在 dbt taipei meetup 介紹 campaign finance dbt project https://www.meetup.com/taipei-dbt-meetup/events/294298229/
clkao 分享的訊息~
我明天會在 dbt taipei meetup 介紹 campaign finance dbt project https://www.meetup.com/taipei-dbt-meetup/events/294298229/
這個 bridge 的訊息有點令人困惑。我在 telegram 乍看以為是 chewei 要去介紹
😵💫
😵💫