The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.


edited October 7 in General Discussion

I'm trying to use CORR_MATRIX (simplified example, I realize CORR would work for just 2 columns) as follows:
select CORR_MATRIX("hour_7", "drops") OVER () from (
select * from (select apply_one_hot_encoder(* using parameters model_name='test_encoder', drop_first='false') from test) as Q1
) as Q2;

but getting this error:
ERROR 3457: Function CORR_MATRIX(int, int) does not exist, or permission is denied for CORR_MATRIX(int, int)
I'm running
vsql version 09.02.0007, built for Linux64
From JB Favre's vertica docker container
The docs say CORR_MATRIX is a 9.2.x feature, but I can't find details more granular than that.
Any ideas?

Best Answers


  • But as you indicated, just use CORR(), since you're just analyzing two columns.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.