CORR_MATRIX() error

9.2.1
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/NewFeatures/9.2/9.2.1/MachineLearning.htm?tocpath=Vertica 9.2.x New Features and Changes|New and Changed in Vertica 9.2.1|_____7

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

The complete use case is for many columns (hour_0, hour_1,...,hour23). That was just a simplified example.
I just noticed there were 2 replies...so it's a 9.2.1 feature. Understood, and thanks!

I have this error too:
Vertica 9.3
variant1. SELECT corr_matrix(prescr_amount,total_pat_flow,target_pat_flow) OVER() FROM Baikal_Progressa_table;
ERROR: Function corr_matrix(float, float, float) does not exist, or permission is denied for corr_matrix(float, float, float)

variant2.
SELECT corr_matrix("prescr_amount","total_pat_flow","target_pat_flow") OVER() FROM Baikal_Progressa_table;
ERROR: Function corr_matrix(float, float, float) does not exist, or permission is denied for corr_matrix(float, float, float)

variant3.
SELECT corr_matrix('prescr_amount', 'total_pat_flow', 'target_pat_flow') OVER() FROM Baikal_Progressa_table;
ERROR: Function corr_matrix(unknown, unknown, unknown) does not exist, or permission is denied for corr_matrix(unknown, unknown, unknown)

Where my mistake??

Your first option should run.
SELECT CORR_MATRIX(Sepal_Length, Sepal_Width, Petal_Length, Petal_Width) OVER() FROM iris;
Perhaps it's a problem with the function. You might need to reinstall the packages associated with that function (probably the machine learning package). https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/InstallationGuide/Upgrade/PostUpgrade/UpgradingandReinstallingPackages.htm?zoom_highlight=uninstall package

Thanks!
What is the name of the machine learning package? Where can I see it?

All of the Vertica packages are located under /opt/vertica/packages.
You can reinstall the MachineLearning package like this:

[dbadmin@localhost packages]$ admintools -t list_packages
             Package Description
                 AWS Amazon Web Services Package
        ComplexTypes Functions for Complex Types
     MachineLearning In-dataBase Machine Learning package.
       ParquetExport Functions that support Parquet Export
      SparkConnector Spark connector for reading from and writing into Vertica
       TFIntegration Using Tensorflow models in Vertica
          VFunctions Vertica functions
         approximate Probabilistic/Approximate Aggregation Functions
           flextable Flexible Tables Data Load and Query
                hcat Java/HCatalog data load and query
               kafka Kafka streaming load and export
           logsearch Common Advanced text search functions
               place Geospatial Data Query
            txtindex Common string-manipulation functions
       voltagesecure Voltage SecureData functions

[dbadmin@localhost packages]$ admintools -t install_package -d  verticademos -P MachineLearning --force-reinstall
Installing package MachineLearning...
...Success!

Thanks. I'll tryT

It works!!