SELECT REGEXP_REPLACE('[110 Companies .co]','\.co'); REGEXP_REPLACE ------------------ [110 Companies ] (1 row) And if you want to delete only the last occurrence of '.co… (View Post)

1) Many health check indications are covered in Vertica Advisor report. As @skamat suggested it is advised to open a support case, create and upload Scrutinize file to Vertica S3 and receive the Advi… (View Post)

* Consider the following example: CREATE USER Mike IDENTIFIED BY 'MikePasword'; CREATE USER vsql -U Mike -w BadPas Will get an error message: vsql: FATAL 3781: Invalid username or password … (View Post)

Data Collector is on by default and retains information for all sessions. A superuser can disable Data Collector at any time. To disable the Data Collector: ALTER DATABASE DEFAULT SET EnableDataColle… (View Post)

What exactly do you want to audit? If you mean DB size Audit, then SELECT audit_license_size(); Will trigger an immediate audit of the database size and select GET_COMPLIANCE_STATUS(); Will display w… (View Post)