Skip to main content
Question

How to find not up-to-date projection

  • Sep 13, 2024 5:31 PM UTC
  • 3 replies
  • 25 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
  • Sep 16, 2024 10:34 PM UTC

@SruthiA can you look it out


SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • Sep 19, 2024 10:13 PM UTC

Could you please open a support case?


scherepanov
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • Sep 22, 2024 12:53 PM UTC

I missed column is_up_to_date in projection systems table.