Bryan_H
Administrator
Bryan_H Administrator
Reactions
-
Re: Equivalent of LISTAGG that returns an ARRAY rather than delimited string?
Could you IMPLODE your scalar column? https://www.vertica.com/docs/12.0.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Array/IMPLODE.htm (View Post)1 -
Re: Calulating date after specific number of workdays
How about something like this (if you can't create function, you only need the SQL from the RETURN line): CREATE OR REPLACE FUNCTION AddBusinessDays(ts TIMESTAMP, days INT) RETURN TIMESTAMP AS B… (View Post)1 -
Re: Why unique constraint doesn't work?
I'll send your example to engineering to figure out what's going on. (View Post)1 -
Re: Vertica and Tableau
We support direct connection from Tableau to Vertica. Please see our guide: https://www.vertica.com/kb/Vertica-Integration-with-Tableau-Desktop-Connection-Guide/Content/Partner/Vertica-Integration-wi… (View Post)1 -
Re: Transaction ID cyclic or noncyclic
It's a 64-bit integer (so maximum value is 64-bit signed int limit) that is stored outside the catalog and should not repeat, but we provide no guarantee that you can't get duplicate transa… (View Post)1




















