CORR(expression1, expression2)
Advertisements
Let us now check corr(exp1,exp2) function with the following query.
Query
sampledb> select corr(age,mark) as correlation from mytable;
Result
The above query will generate the following result.
correlation ------------------------------- -0.09637388493048485
The query returns the correlation coefficient value between the two columns age and mark.
apache_tajo_aggregate_and_window_functions.htm
Advertisements