Skip to main content
Question

How to find not up-to-date projection

  • September 13, 2024
  • 3 replies
  • 7 views

scherepanov
Forum|alt.badge.img+1

Hi,

Vertica Management Console (v 24.3.0-1) show presence of not up-to-date projection in database. I cannot find it in MC - there is a defect in MC, it cannot show tables for all schema, only for single schema at time, and I have way too many schemas and too little patience to go over all of them. MC link to not up-to-date projections just leads to first schema by alphabetical order.

Checking systems views like projections etc does not show how I can find projections.

Can you share a query used by MC to find not up-to-date projections.

Thank you
Sergey

3 replies

scherepanov
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • September 16, 2024

@SruthiA can you look it out


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • September 19, 2024

Could you please open a support case?


scherepanov
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • September 22, 2024

I missed column is_up_to_date in projection systems table.