Bryan_H
Administrator
Bryan_H Administrator
Reactions
-
Re: Unable to Move Data location in Vertica
Vertica doesn't create the filesystem path when CREATE LOCATION is run. As the error message indicates, it is necessary to create the filesystem path and assign correct permissions on all nodes befor… (View Post)1 -
Re: Error loading FLOAT INFINITY using FJSONPARSER
It looks like you can load NaN and Inf as float by enclosing with double quotes: d2=> create flex table floatinf(); d2=> copy floatinf from local stdin parser fjsonparser(); Enter data to be co… (View Post)1 -
Re: ST_ReverseGeocode
I've posted a Python UDSF example using GeoPy and Nominatim at https://github.com/bryanherger/vertica-python-udx Please see the instructions and example under "UDSF example: reverseGeocode"… (View Post)2 -
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 BEGIN … (View Post)1