pyflink.table.expression.Expression.sum

property Expression.sum: pyflink.table.expression.Expression

Returns the sum of the numeric field across all input values. If all values are null, null is returned.

Example:

>>> tab \
>>>     .group_by(col("a")) \
>>>     .select(col("a"),
>>>             col("b").sum.alias("d"),
>>>             col("b").sum0.alias("e"),
>>>             col("b").min.alias("f"),
>>>             col("b").max.alias("g"),
>>>             col("b").count.alias("h"),
>>>             col("b").avg.alias("i"),
>>>             col("b").stddev_pop.alias("j"),
>>>             col("b").stddev_samp.alias("k"),
>>>             col("b").var_pop.alias("l"),
>>>             col("b").var_samp.alias("m"),
>>>             col("b").collect.alias("n"))

See also

sum, sum0, min, max, count, avg, stddev_pop, stddev_samp, var_pop, var_samp, collect

New in version 1.12.0.