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.
Have you already inserted the data into the table before creating the projections? If so, please run the following statement.
=> SELECT REFRESH('table name');
=> SELECT START_REFRESH();
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.