Vertica Column Statistics : Profiling Data
I need to fetch -
1- Top 100 Distinct Values for Each Column (Including Min & Max) .
I'm interested in findng out - as a result of Analyze statistics/ Histogram does vertica stored such information any where? If yes then which system table/view?
If such information isn't stored by Default by vertica is there any less tedius way to write such queries to collect statitics/ data profiling on columns ?