clickhouse
clickhouse copied to clipboard
Filtering not working properly
While in clickhouse console:
SELECT count()
FROM tracks
WHERE date = '2019-07-09'
┌─count()─┐
│ 4162001 │
└─────────┘
And Rails log shows
DEBUG -- : SELECT count() FROM tracks WHERE date = '2019-07-09'
DEBUG -- : [{"count()"=>0}]
The gem seems to be abandoned, but I'll drop this here anyway as a warning.
I've just made an alternative, very similar to this one:
ClickHouse.connection.select_value(' SELECT count(*) FROM tracks WHERE date = '2019-07-09'')
#=> 0