Should You Use ClickHouse as a Main Operational Database?
Percona
JANUARY 14, 2019
2006-01-01 ? 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()?? And the results are (here I’m grouping words for each year): For “programming” subreddit: ??year???words????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
40 
Let's personalize your content