Bryan_H
Administrator
-
Re: find query by session_id
v_monitor.sessions only lists open sessions. Closed sessions will be found in the history table "dc_session_starts". Also check "dc_session_ends" to find when and why the session … (View Post)1 -
Re: Error importing an Avro file into a Flex table
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, plea… (View Post)1 -
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 … (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
