clickhouse icon indicating copy to clipboard operation
clickhouse copied to clipboard

Filtering not working properly

Open artshpakov opened this issue 6 years ago • 1 comments

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.

artshpakov avatar Jul 09 '19 10:07 artshpakov

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

shlima avatar Nov 09 '19 02:11 shlima