PersistentQueryConfigurationLogV2

Every time a Persistent Query (PQ) is created or modified, details on the query are stored in the PersistentQueryConfigurationLogV2 table. Deephaven uses this log when a query is reverted to a previous version.

Note

The PersistentQueryConfigurationLogV2 table replaces the Legacy PersistentQueryConfigurationLog table.

Columns

Column Name	Column Type	Description
`Date`	String	The date on which the state change occurred. This is the partitioning column.
`Timestamp`	DateTime	The timestamp for the state change.
`SerialNumber`	long	The query's serial number (a system-generated identifier unique to each PQ).
`VersionNumber`	long	The query's version number (a number that starts at 1 for each query and is incremented each time the query is updated).
`Owner`	String	The owner of the PQ.
`Name`	String	The name of the PQ.
`EventType`	long	The query configuration event that triggered the log entry: `ADDED` - a PQ was added or modified `INITIAL` - a controller logs all queries it is managing with EventType of INITIAL when it first starts `REMOVED` - a PQ was deleted
`Enabled`	boolean	`true` - the query is enabled `false` - the query is disabled (will not be started by the controller)
`HeapSizeInGB`	double	The heap size for the query in GB (the memory the query has available)
`DataBufferPoolToHeapSizeRatio`	double	The data buffer to heap size ratio - this is the fraction of the query's heap that will be dedicated to caching binary data from the underlying Deephaven data sources.
`DetailedGCLoggingEnabled`	boolean	If `true`, then Java garbage collection details are logged for the query.
`OmitDefaultGCParameters`	boolean	This parameter is deprecated.
`DbServerName`	String	The server on which the query will be run; this is shown as `DB_SERVER_<number>`, and these names are translated to physical or virtual servers by the controller.
`RestartUsers`	String	Specifies which group of users are allowed to restart the query: `Admin` - only administrators of the query can restart it `AdminAndViewers` - administrators and viewers of the query can restart it `ViewersWhenDown` - administrators can restart the query, and viewers only if it is not running
`ScriptCode`	String	The code for the script if it is not stored in git.
`ScriptPath`	String	The script path if it is stored in git.
`ExtraJvmArguments`	String[]	Extra JVM arguments to be passed to Java when the query is started.
`ExtraEnvironmentVariables`	String[]	Environment variables to be set before the query is started.
`ClassPathAdditions`	String[]	Additional elements to be added to the class path for the JVM.
`AdminGroups`	String[]	Additional administrators for the query (i.e., users or groups that can edit, start, stop, or delete the query).
`ViewerGroups`	String[]	Additional viewers for the query (i.e., users or groups that can view the query and its resulting tables).
`ConfigurationType`	String	The type of the configuration: Live Query Replay - (ReplayScript) - a configuration that replays data. Revert Helper - a Deephaven internal query that is used to help to revert PQs to previous versions; this should not be modified except by a system administrator. Batch Query (RunAndDone) - a query that runs and terminates once the queries are complete. Live Query (Script) - a query that runs until it is terminated.
`Scheduling`	String[]	Specifies the scheduling details for the query.
`Timeout`	long	Timeout value in milliseconds.
`TypeSpecificFields`	`java.util.Map`	Map for fields specific to configuration types.
`JVMProfile`	String	The JVM profile to be used for the query.
`LastModifiedByAuthenticated`	String	The authenticated user who last modified this query.
`LastModifiedByEffective`	String	The effective user who last modified this query.
`LastModifiedTime`	DateTime	The last time this query was modified.

PersistentQueryConfigurationLogV2

Columns

Related documentation