Nick Crews

`numpy.sum([])` produces 0 as well. So numpy is self-consistent, returning 0s for these aggs. This unfortunately implies that SQL and numpy are never going to be consistent with each other...

@dstala Can you comment on if - a) this feature is wanted by the nocodb team, it just is a matter of implementing it. If a community member submitted a...

You are looking for [`Table.count()`](https://ibis-project.org/reference/expression-tables#ibis.expr.types.relations.Table.count) :). This also works with Ibis.Deferred. Eg ```python t.group_by("x").agg(x=t.count()) t.mutate(t.count().over(ibis.window(group_by=group)) # ps, you don't actually need the ibis.window call, you can just pass directly to...

@cpcloud as a feature request, what if we exposed `ibis._.count()` as `ibis.count()`?

To be clear, `ibis._.count()` should currently work. Just wanted to clarify because you said "WOULD be helpful", which made it sound like you didn't think it currently works. If it's...

Ah, yes, I see. That is because most expressions in ibis know their datatype, eg float64. But deferred's don't by definition, because it is unclear what concrete value you are...

Yes, for that special case (and some others I'm sure) of Deferreds we would know the d-type. But in general for Deferreds, eg ibis._.my_col, we don't. So it would be...

on main, this could possibly be the reproducer you are running into: ```python import ibis t = ibis.memtable({"a": [1, 2, 3], "b": [4, None, 6]}) t.fill_null({"a": ibis._.b}) ``` @MarcoGorelli if...

An alternative, config-less implementation you could consider of exponential increase: start with a small size, say 4, and on each request, double that, until you hit an error, then back...

@alejandrodnm I think I fixed the lint error and the format of the commit message