| 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; |