I have a table named fact_table I created a projection named p1_fact_table I updated the stats: select analyze_statistics ('schema_name.fact_table') ; I query the projections table to confirm the new projection has stats: select * from projections where has_statistics = false and projection_schema =...

Thanks id10t, thanks Jim. Your help is much appreciated!

Perfect... thank you!

If anyone can help with my Linux flavor question that would be great.

I would like to apply the appropriate patches to my cluster: 3-nodes on Amazon standard AMI select version() ; Vertica Analytic Database v7.1.1-0 I see that several patches are listed on Vertica's customer ftp site. Is there a roll-up patch, or must all of them be applied? I assume they must be appl...