Dremio Cloud
Dremio Software
 
On this page

    Categories: Aggregate, Window

    VAR_POP

    Returns the population variance of non-NULL records.

    Syntax

    VAR_POP(numeric_expression int64) → double

    • numeric_expression: The set of records to calculate variance for.

    Examples

    VAR_POP example 
    SELECT VAR_POP(pop) FROM "zips.json"
-- 1.5167869917122573E8

    VAR_POP(numeric_expression double) → double

    • numeric_expression: The set of records to calculate variance for.

    Examples

    VAR_POP example 
    SELECT VAR_POP(fare_amount) FROM Samples."samples.dremio.com"."NYC-taxi-trips"
-- 181.26187022731304

    VAR_POP(numeric_expression float) → double

    • numeric_expression: The set of records to calculate variance for.

    Examples

    VAR_POP example 
    SELECT VAR_POP(fare_amount) FROM Samples."samples.dremio.com"."NYC-taxi-trips"
-- 181.26187022731304

    VAR_POP(numeric_expression int32) → double

    • numeric_expression: The set of records to calculate variance for.

    Examples

    VAR_POP example 
    SELECT VAR_POP(pop) FROM "zips.json"
-- 1.5167869917122573E8

    Usage Notes

    For single record inputs, VAR_POP returns 0.