Apache Pinot Docs
latest
Search…
⌃K

COVAR_POP

This section contains reference documentation for the COVAR_POP function.
Returns the population covariance between of 2 numerical columns.
COVAR_POP(col1, col2) = E[col1 * col2] - E[col1]E[col2]

Signatures

COVAR_POP(col1, col2) -> double

Usage Examples

These examples are based on the Batch Quick Start.
SELECT COVAR_POP(numberOfGames, hits) AS covariance
FROM baseballStats
covariance
2314.249154477403
Last modified 3mo ago