Jim_Knicely
Administrator
-
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 -
Re: CI/CD with two env on Vertica
One option is Vertica Replication. Doc Page: https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/ReplicatingtoanAlternateCluster.htm (View Post)1 -
Re: What's difference LIKE and ILIKE ??
ILIKE is case-insensitive. Doc Page: https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Predicates/LIKE-predicate.htm (View Post)1 -
Re: Adding design table query is not working
@HyeontaeJu - Attached is an example deck showing the set up how to run the DBD functions manually. And here is another example: dbadmin=> \c - ma_dbdYou are now connected as user "ma_dbd&quo… (View Post)1
