set hive.mapred.mode=nonstrict;
DROP TABLE covar_tab;
CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '../../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab;

DESCRIBE FUNCTION covar_pop;
DESCRIBE FUNCTION EXTENDED covar_pop;
SELECT covar_pop(b, c) FROM covar_tab WHERE a < 1;
SELECT covar_pop(b, c) FROM covar_tab WHERE a < 3;
SELECT covar_pop(b, c) FROM covar_tab WHERE a = 3;
SELECT a, covar_pop(b, c) FROM covar_tab GROUP BY a ORDER BY a;
SELECT ROUND(covar_pop(b, c), 5) FROM covar_tab;

DROP TABLE covar_tab;