How to set up to date vertica's projection data?

HyeontaeJu

How to set up to date vertica's projection data?
I used the query "SELECT analyze_statistics('[table-name]')
but, when i check the data by using "select * from projection_storage", the data rows count is 0(zero)..
Plz help me.

Hibiki

Have you already inserted the data into the table before creating the projections? If so, please run the following statement.

=> SELECT REFRESH('table name');

or

=> SELECT START_REFRESH();

https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/Projections/UpdatingProjectionsUsingRefresh.htm