1) Is Voltage SecureData the only tool in Vertica used for encryption? A - It is not the only option but the best one because of the following benefits: + The ability to protect data as close to its … (View Post)

The best practice is to schedule via cron the use of DROP_PARTITIONS function to drop old partitions as you do. There might be a gap between the time you drop partitions for this to be reflected in D… (View Post)

Q - Is there a way when one node is down to get the other nodes function optimally? A - Yes, open a support case and investigate the root cause for your performance issue. There are several things su… (View Post)

Q - Will their be data loss if the buddy node also goes down? A - Committed data will not lost. While node 18 is down, if also the buddy node will go down the database is considered unsafe and automa… (View Post)

I've tried something similar to Marco idea for user Mike and it works: \a\t\o | vsqlSELECT distinct 'REVOKE ALL ON ALL TABLES IN SCHEMA ' || object_schema || ' FROM ' || grantee || ';'FROM v_catalog.… (View Post)