Remove 2007 Remove Blockchain Remove Google Remove Programming
article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

To simulate text messages I have used ~3 billion of reddit comments (10 years from 2007 to 2017), downloaded from pushshift.io. As a temporary workaround we can do something like this: SELECT count() FROM rc WHERE (created_utc > ( ( SELECT max(created_utc) FROM rc ) - ((60 * 60) * 24))) AND (subreddit = 'programming') ??count()??