PREHOOK: query: DROP TABLE covar_tab
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE covar_tab
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE covar_tab (a INT, b INT, c INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@covar_tab
PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab
PREHOOK: type: LOAD
PREHOOK: Output: default@covar_tab
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/covar_tab.txt' OVERWRITE
INTO TABLE covar_tab
POSTHOOK: type: LOAD
POSTHOOK: Output: default@covar_tab
PREHOOK: query: DESCRIBE FUNCTION covar_pop
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION covar_pop
POSTHOOK: type: DESCFUNCTION
covar_pop(x,y) - Returns the population covariance of a set of number pairs
PREHOOK: query: DESCRIBE FUNCTION EXTENDED covar_pop
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED covar_pop
POSTHOOK: type: DESCFUNCTION
covar_pop(x,y) - Returns the population covariance of a set of number pairs
The function takes as arguments any pair of numeric types and returns a double.
Any pair with a NULL is ignored. If the function is applied to an empty set, NULL
will be returned. Otherwise, it computes the following:
   (SUM(x*y)-SUM(x)*SUM(y)/COUNT(x,y))/COUNT(x,y)
where neither x nor y is null.
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 1
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-58_968_4806438013320076077/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-25-58_968_4806438013320076077/-mr-10000
NULL
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-02_070_2692729689314573082/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-02_070_2692729689314573082/-mr-10000
NULL
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-05_164_5674819400682657915/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a = 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-05_164_5674819400682657915/-mr-10000
0.0
PREHOOK: query: SELECT a, covar_pop(b, c) FROM covar_tab GROUP BY a ORDER BY a
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-08_179_5503395149806188837/-mr-10000
POSTHOOK: query: SELECT a, covar_pop(b, c) FROM covar_tab GROUP BY a ORDER BY a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-08_179_5503395149806188837/-mr-10000
1	NULL
2	NULL
3	0.0
4	0.0
5	0.0
6	0.0
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-13_878_767643551906327366/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_05-26-13_878_767643551906327366/-mr-10000
3.624999999999999
PREHOOK: query: DROP TABLE covar_tab
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@covar_tab
PREHOOK: Output: default@covar_tab
POSTHOOK: query: DROP TABLE covar_tab
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@covar_tab
POSTHOOK: Output: default@covar_tab