This example omits the PARTITION BY clause, so the function determines the correlation values for the overall population and does not group the data by state.
Input
- corr_input, as in Correlation Example 1: Include PARTITION BY Clause
SQL Call
SELECT * FROM CorrelationReduce ( ON CorrelationMap ( ON corr_input USING TargetColumns ('[2:3]', 'employed:gdp', 'employed:unemployed', 'employed:armedforces') KeyName ('keys') ) PARTITION BY keys ) AS dt;
Output
corr | value_col |
---|---|
gdp:gdp | 1 |
gdpdeflator:gdp | 1 |
gdpdeflator:gdpdeflator | 1 |
employed:gdp | 0.983552 |
employed:unemployed | 0.502498 |
employed:armedforces | 0.457307 |