clickhouse-sqlalchemy
clickhouse-sqlalchemy copied to clipboard
query.count() with custom modifiers (sample) generates incorrect query
session.query(...).count()
That code generates something like that:
select count(*) from (
select ...
from table
) anon_1
If I trying to use sample, query will look like that:
session.query(...).sample(0.1)
select count(*) from (
select ...
from table
sample 0.1
) anon_1
sample 0.1
The same problem appears with ARRAY JOIN