Search found 2 matches

by saad.nossir
Sun Jul 31, 2016 7:39 am
Forum: Vertica Backup & Recovery
Topic: Vertica Restore error : ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
Replies: 0
Views: 16423

Vertica Restore error : ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible

Hi All, I've tried to backup a schema using vbr.py command , first created the setup conf file then backup successfully and dropped the tables and schema but when trying to do restore on the same machine , vertica version ..etc ,I have got this error ERROR 4757 : SnapshotMemento does not match. Oid ...
by saad.nossir
Sun Jun 19, 2016 10:58 am
Forum: Vertica SQL
Topic: projection_usage table not all tables got query_start_timestamp
Replies: 2
Views: 17378

projection_usage table not all tables got query_start_timestamp

I've been trying to develop a report , got each table name and last query date using below query SELECT anchor_table_id, max( query_start_timestamp ) as last_access FROM v_monitor.projection_usage group by 1 and I've noticed that not all tables got an entry in this table although i've performed a qu...

Go to advanced search