Bryan_H
Administrator
Bryan_H Administrator
Reactions
-
Re: monitoring the count of requests per second
For total requests per second: have a look at v_monitor.query_requests For requests on a specific table: have a look at v_monitor.projection_usage (View Post)2 -
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, please do… (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 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