This is actually a server-side error in the Avro parser. I've seen this happen when the Avro file contains decimals with precision > 38. Is this the case? If you can open a support case, please do… (View Post)

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)

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)

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)

Could you IMPLODE your scalar column? https://www.vertica.com/docs/12.0.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Array/IMPLODE.htm (View Post)