Skip to main content
Question

Error On v_catalog.columns

  • March 27, 2025
  • 2 replies
  • 3 views

jorodriguezr
Forum|alt.badge.img

When i Try to select all the columns from the table:
select * from v_catalog.columns
Print the error:
SQL Error [2282] [VX001]: [Vertica]VJDBC ERROR: Cache lookup failed for attribute 1 of relation 49539602141301826

I notice that the error throws when i try to select the column:

select COLUMN_DEFAULT from v_catalog.columns

SQL Error [2282] [VX001]: [Vertica]VJDBC ERROR: Cache lookup failed for attribute 1 of relation 49539602141301826

¿Where i can find the relation missing to resolve the conflict?

Thanks a lot Regards

2 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • March 28, 2025

please check if any relation is having invalid def?


jorodriguezr
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • March 28, 2025

Hi SruthiA, Thank you very much for your response. I have searched the catalog tables but I still cannot find a way to identify if there is an invalid relationship. Do you have any suggestions? Best Regards