Jim_Knicely
Administrator
Jim_Knicely Administrator
Reactions
-
Re: Need help on vsql connection in shell script.
This works: [dbadmin@localhost ~]$ vsql -q -c "\q" (View Post)1 -
Re: Vertica SSL Keystore configuration on DBeaver
Maybe another option (dbeaver.ini) here? https://github.com/dbeaver/dbeaver/issues/4341 (View Post)1 -
Database Storage - Raw and Compressed Size
One of the files generated by the /opt/vertica/scripts/collect_diag_dump.sh script details the raw and compressed size for every table in the Vertica database. At the bottom of the report there is a … (View Post)1 -
Re: What is Merge out?
@HyeontaeJu is probably refering to the MERGE SQL statement (i.e. MERGE INTO...) Doc Page: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Statements/MERGE.htm (View Post)1 -
Re: Can we do a regex search on vertica's ARRAY (complex type) data type?
You can EXPLODE the array and look at each element. Example: dbadmin=> CREATE TABLE a (c ARRAY[VARCHAR]);CREATE TABLEdbadmin=> INSERT INTO a SELECT ARRAY['CAT','DOG','P… (View Post)1

















