SQL Reference
System Catalog Reference

System Catalog

System Catalog

The system catalog exposes read-only virtual tables that contain metadata about the system.

Alphabetical List of Tables

  • sys.active_operator_instances
  • sys.association_rules_models
  • sys.average_bb_sizes
  • sys.average_column_sizes
  • sys.channel_endpoint_parameters
  • sys.clusters
  • sys.columns
  • sys.columns_compression_info
  • sys.column_cardinalities
  • sys.column_distributions
  • sys.completed_queries
  • sys.completed_operator_instances
  • sys.compute_configurations
  • sys.config
  • sys.connectivity_pools
  • sys.connectivity_pool_participants
  • sys.databases
  • sys.decision_tree_models
  • sys.feedforward_network_models
  • sys.function_signatures
  • sys.gaussian_mixture_models
  • sys.global_map_table_info
  • sys.groups
  • sys.group_roles
  • sys.indexes
  • sys.index_columns
  • sys.k_means_models
  • sys.k_nearest_neighbors_models
  • sys.linear_combination_regression_models
  • sys.linear_discriminant_analysis_models
  • sys.locks
  • sys.logistic_regression_models
  • sys.lts_cluster_info
  • sys.machine_learning_models
  • sys.machine_learning_model_options
  • sys.metric_levels
  • sys.multiple_linear_regression_models
  • sys.naive_bayes_models
  • sys.network_interface_models
  • sys.network_interface_usage_types
  • sys.nodes
  • sys.node_config
  • sys.node_clusters
  • sys.node_network_interfaces
  • sys.node_status
  • sys.nonlinear_regression_models
  • sys.oidc_integrations
  • sys.oidc_sessions
  • sys.op_inst_debug_info
  • sys.osn_acquisitions
  • sys.pipelines
  • sys.pipeline_files
  • sys.pipeline_tables
  • sys.pipeline_task_ids
  • sys.polynomial_regression_models
  • sys.principal_component_analysis_models
  • sys.privileges
  • sys.queries
  • sys.reserved_words
  • sys.result_cache
  • sys.rights
  • sys.roles
  • sys.security_integrations
  • sys.security_settings
  • sys.segments
  • sys.segments_compression_info
  • sys.segment_group_transfers
  • sys.segment_groups
  • sys.segment_parts
  • sys.segment_part_redundancy_info
  • sys.service_classes
  • sys.service_roles
  • sys.service_role_status
  • sys.service_role_channel_endpoints
  • sys.sessions
  • sys.simple_linear_regression_models
  • sys.sql_messages
  • sys.stats_files
  • sys.storage_capacity
  • sys.storage_device_metrics
  • sys.storage_device_status
  • sys.storage_scopes
  • sys.storage_spaces
  • sys.storage_used
  • sys.stored_segments
  • sys.subtasks
  • sys.support_vector_machine_models
  • sys.system_information
  • sys.system_tables
  • sys.system_table_columns
  • sys.tables
  • sys.table_cardinalities
  • sys.tkt_table_clustering_column_indices
  • sys.tkt_table_info
  • sys.users
  • sys.user_groups
  • sys.user_roles
  • sys.vector_autoregression_models
  • sys.view_columns
  • sys.views
  • sys.vl_columns_compression_info

Alphabetical List of Categories

  • Configuration
  • Connectivity Pool Participants
  • Connectivity Pools
  • Databases
  • Functions
  • Machine Learning
  • Monitoring
  • Network
  • Pipelines
  • Procedures
  • SQL Messages
  • Security
  • Security Integrations
  • Statistics
  • Storage
  • System
  • System Information
  • User Management
  • Workload Management

Catalog Table Details

Configuration

sys.config

This table contains all configuration overrides applied on the system.

Column Name

Column Type

Column Description

scope_type

CHAR

Type of the scope.

scope_id

UUID

UUID of the storage scope where this override applies.

key

CHAR

String that represents the configuration parameter.

value

CHAR

Value for the configuration parameter key.

sys.node_config

This table contains the effective node configuration for all nodes in the system.

Column Name

Column Type

Column Description

node_id

UUID

UUID of the node where this configuration exists (sys.nodes).

key

CHAR

String that represents the configuration parameter.

value

CHAR

Value for the configuration parameter key.

Connectivity Pool Participants

sys.connectivity_pool_participants

This table contains the connectivity pool participants and their information.

Column Name

Column Type

Column Description

id

UUID

UUID of the connectivity pool that contains the participant.

node_id

UUID

UUID of the participant node.

created_at

TIMESTAMP

Timestamp that indicates the creation of the connectivity pool participant.

updated_at

TIMESTAMP

Timestamp that indicates the last update of the connectivity pool participant.

listen_address

CHAR

Address where the participant node listens.

listen_port

INT

Port number where the participant node listens.

advertised_address

CHAR

Address that the participant node advertises to the client.

advertised_port

INT

Optional port number that the participant node advertises to the client.

Connectivity Pools

sys.connectivity_pools

This table contains the connectivity pools and their information (excluding participants).

Column Name

Column Type

Column Description

id

UUID

UUID of the connectivity pool.

name

CHAR

Name of the connectivity pool.

created_at

TIMESTAMP

Timestamp that indicates the creation of the connectivity pool.

updated_at

TIMESTAMP

Timestamp that indicates the last update of the connectivity pool.

source_address

CHAR

Source address in CIDR notation for the connectivity pool.

source_port

INT

Optional source port of the connectivity pool.

priority

INT

Priority of the connectivity pool.

Databases

sys.columns

This table contains all columns in each table in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the column.

name

CHAR

Name of the column.

data_type

CHAR

Data type of the column (INT, CHAR, BOOLEAN, etc.).

position

INT

Position of the column in its table.

table_id

UUID

UUID of the table that contains this column (sys.tables).

nullable

BOOLEAN

Specifies whether the values in this column can be NULL.

default_expression

CHAR

Default value of this column when the value is unspecified.

description

CHAR

Description of the column.

ordinal

LONG

Ordinal of the column with respect to its table.

gdc_type

CHAR

Type of GDC applied to this column.

sys.databases

This table contains all databases defined in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the database.

name

CHAR

Name of the database.

created_at

TIMESTAMP

Timestamp that specifies when the database was created.

sys.global_map_table_info

This table contains the global dictionary compression (GDC) details associated with each compressed column.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

column_id

UUID

UUID of the column (sys.columns).

compressed_size

INT

Compressed column size (in bytes).

max_count

LONG

Maximum amount of unique column values allowed in the column.

current_count

LONG

Current amount of unique column values in the column.

sys.indexes

This table contains all indexes defined on tables.

Column Name

Column Type

Column Description

id

UUID

UUID of the index.

name

CHAR

Name of the index.

index_type

CHAR

Type of the index.

table_id

UUID

UUID of the table for the index (sys.tables).

index_use

CHAR

Intended use for the index by the system.

ngram_size

INT

Size of each N-gram (in bytes).

enabled

BOOLEAN

Whether the index is enabled on this table.

sys.index_columns

This table contains the index settings applied to each column.

Column Name

Column Type

Column Description

index_id

UUID

UUID that represents the index (sys.indexes).

column_id

UUID

UUID that represents the column (sys.columns).

ordinal

INT

Ordinal of the column in the index structure.

tuple_element

CHAR

Specifies the name of the component column that the index applies to if the index exists on a tuple column.

ascending

BOOLEAN

Indicates whether the values in this column are built in ascending order.

column_ordinal

LONG

Ordinal position of this column in the source table.

sys.tables

This table contains all tables defined in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the table (sys.tables).

name

CHAR

Name of the table.

schema

CHAR

Schema name in which the table resides.

database_id

UUID

UUID of the database (sys.databases).

storage_space_id

UUID

UUID of the storage space (sys.storage_spaces).

maximum_segment_size_gib

INT

Maximum size of a segment for the table in GiB.

description

CHAR

Detailed description of the table.

streamloader_property_string

CHAR

Additional properties assigned to control the stream loading behavior for the table.

created_at

TIMESTAMP

Timestamp that represents when the table was created.

altered_at

TIMESTAMP

Timestamp that represents when the table's structure was last modified via DDL.

sys.tkt_table_clustering_column_indices

This table contains the columns defined as part of a clustering index.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

column_id

UUID

UUID of the column (sys.columns).

sys.tkt_table_info

This table contains the columns that are defined as the time key on each user-defined table and the size of the time bucket in use.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

time_column_id

UUID

UUID of the column that represents the time column on the table (sys.columns).

time_bucket_width

LONG

Time bucket width used to segment data in nanoseconds.

sys.view_columns

This table contains all columns in each view in the system.

Column Name

Column Type

Column Description

id

UUID

The UUID of the column.

name

CHAR

The name of the column.

data_type

CHAR

The data type of the column.

view_id

UUID

The UUID of the view this column comes from.

nullable

BOOLEAN

Whether or not this column is nullable.

default_expression

CHAR

The default expression of this column, if it exists.

ordinal

LONG

The ordinal of this column.

sys.views

This table contains all user-defined database views created on the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the view.

name

CHAR

Name of the view.

database_id

UUID

UUID of the database (sys.databases).

schema

CHAR

Schema name where the view exists.

query

CHAR

Query used to generate the view content.

description

CHAR

Detailed description of the view.

view_type

CHAR

Type of the view.

global_dictionary_compression_table_id

UUID

UUID of the table with the GDC column (sys.tables).

created_at

TIMESTAMP

Timestamp that represents the date and time for the creation of the view.

updated_at

TIMESTAMP

Timestamp that represents the date and time for the last update of the view.

Machine Learning

sys.association_rules_models

This table contains the name of the snapshot table for an association rules model.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

num_arguments

INT

Number of arguments in the machine learning model data.

table_name

CHAR

Name of the snapshot table.

sys.decision_tree_models

This table contains all model parameters for Decision Tree Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

case_statement

CHAR

The case statement that defines the decision tree.

num_arguments

INT

Number of arguments in the machine learning model data.

correctly_classified

DOUBLE

Percentage of training data that is correctly classified by the decision tree model.

sys.feedforward_network_models

This table contains all model parameters for Feedforward Neural Network Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of coefficients associated with the feedforward network model.

num_arguments

INT

Number of arguments in the machine learning model data.

average_loss

DOUBLE

Average value of the loss function.

sys.gaussian_mixture_models

This table contains all model parameters for Gaussian Mixture Models.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of coefficients associated with the Gaussian Mixture Model.

num_distributions

INT

Number of distributions in the Gaussian Mixture Model.

average_loss

DOUBLE

Average value of the loss function.

sys.k_means_models

This table contains all model parameters for K-Means Clustering Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

centroids

ARRAY(DOUBLE)

Values that represent the centroid values of each cluster.

num_arguments

INT

Number of arguments in the machine learning model data.

means

ARRAY(DOUBLE)

Means of each of the feature columns in the data.

standard_deviations

ARRAY(DOUBLE)

Standard deviations of each of the feature columns in the data.

sys.k_nearest_neighbors_models

This table contains the number of arguments and the target table for K-Nearest Neighbors Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

num_arguments

INT

Number of arguments in the machine learning model data.

table_name

CHAR

Name of the target table for the K Nearest Neighbors (KNN) model.

correctly_classified

DOUBLE

Percentage of training data that is correctly classified by the KNN model.

means

ARRAY(DOUBLE)

Means of each of the feature columns in the data.

standard_deviations

ARRAY(DOUBLE)

Standard deviations of each of the feature columns in the data.

sys.linear_combination_regression_models

This table contains all model parameters for Linear Combination Regression Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of model coefficients associated with the regression.

y_intercept

DOUBLE

y-intercept of the regression.

coefficient_of_determination

DOUBLE

R^2 value of the regression, if calculated, otherwise NULL.

num_arguments

INT

Number of arguments in the machine learning model data.

rmse

DOUBLE

Root mean square error of the regression.

adjusted_r2

DOUBLE

Adjusted R^2 value of the regression.

sys.linear_discriminant_analysis_models

This table contains all model parameters for Linear Discriminant Analysis (LDA) Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of coefficients associated with the LDA model.

num_features

INT

Number of features returned by the LDA model.

importance

ARRAY(DOUBLE)

Importance of each of the output features that represent the data.

sys.logistic_regression_models

This table contains all model parameters for Logistic Regression Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of coefficients associated with the logistic regression model.

correctly_classified

DOUBLE

Percentage of training data that is correctly classified by the logistic regression.

num_arguments

INT

Number of arguments in the machine learning model data.

zero_case

CHAR

The case where the logistic regression uses a value of 0.

one_case

CHAR

The case where the logistic regression uses a value of 1.

classes

ARRAY(CHAR)

Target classes for the logistic regression.

sys.machine_learning_models

This table contains the machine learning models that are defined in the database.

Column Name

Column Type

Column Description

id

UUID

UUID of the machine learning model.

name

CHAR

Name of the machine learning model.

schema

CHAR

Schema of the machine learning model.

machine_learning_model_type

CHAR

Type of the machine learning model.

database_id

UUID

UUID of the database that contains the machine learning model definition (sys.databases).

on_select

CHAR

The SELECT SQL statement used to create this model.

sys.machine_learning_model_options

This table contains options defined for each machine learning model. The database stores these options as key-value pairs.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

machine_learning_model_key

CHAR

Machine learning model configuration option key.

machine_learning_model_value

CHAR

Machine learning model configuration option value.

sys.multiple_linear_regression_models

This table contains the y-intercept and coefficient of determination values for the multiple linear regression machine learning models.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

y_intercept

DOUBLE

y-intercept of the regression.

coefficient_of_determination

DOUBLE

R^2 value of the regression, if calculated, otherwise NULL.

rmse

DOUBLE

Root mean square error of the regression.

adjusted_r2

DOUBLE

Adjusted R^2 value of the regression.

slopes

ARRAY(DOUBLE)

Slopes for each variable in the regression.

sys.naive_bayes_models

This table contains all model parameters for Naive Bayes Classification Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

num_arguments

INT

Number of arguments in the machine learning model data.

result_probability_table

CHAR

Name of the internal result probability table.

feature_result_matrix_table

CHAR

Name of the internal feature result matrix table.

correctly_classified

DOUBLE

Percentage of training data that is correctly classified by the Naive Bayes model.

sys.nonlinear_regression_models

This table contains all model parameters for Nonlinear Regression Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of coefficients associated with the nonlinear regression model.

coefficient_of_determination

DOUBLE

R^2 value of the regression, if calculated, otherwise NULL.

num_arguments

INT

Number of arguments in the machine learning model data.

rmse

DOUBLE

Root mean square error of the regression.

adjusted_r2

DOUBLE

Adjusted R^2 value of the regression.

sys.polynomial_regression_models

This table contains all model parameters for Polynomial Regression Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of model coefficients associated with the polynomial regression model.

y_intercept

DOUBLE

y-intercept of the regression.

coefficient_of_determination

DOUBLE

R^2 value of the regression, if calculated, otherwise NULL.

num_arguments

INT

Number of arguments in the machine learning model data.

rmse

DOUBLE

Root mean square error of the regression.

adjusted_r2

DOUBLE

Adjusted R^2 value of the regression.

sys.principal_component_analysis_models

This table contains all model parameters for Principal Component Analysis (PCA) Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of coefficients associated with the PCA model.

num_features

INT

Number of features returned by the PCA model.

importance

ARRAY(DOUBLE)

Importance of each of the output features that represents the data.

means

ARRAY(DOUBLE)

Means of each of the feature columns in the data.

standard_deviations

ARRAY(DOUBLE)

Standard deviations of each of the feature columns in the data.

sys.simple_linear_regression_models

This table contains the slope, y-intercept, and coefficient of determination values for single linear regression machine learning models.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

slope

DOUBLE

Slope of the regression.

y_intercept

DOUBLE

The y-intercept of the regression.

coefficient_of_determination

DOUBLE

R^2 value of the regression, if calculated, otherwise NULL.

rmse

DOUBLE

Root mean square error of the regression.

adjusted_r2

DOUBLE

Adjusted R^2 value of the regression.

sys.support_vector_machine_models

This table contains all model parameters for Support Vector Machine (SVM) Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of coefficients associated with the SVM model.

correctly_classified

DOUBLE

Percentage of training data that is correctly classified by the SVM model.

num_arguments

INT

Number of arguments in the machine learning model data.

negative_case

CHAR

Case when the SVM model classifies data as negative.

positive_case

CHAR

Case when the SVM model classifies data as positive.

classes

ARRAY(CHAR)

Target classes for the SVM model.

sys.vector_autoregression_models

This table contains all model parameters for Vector Autoregression Models in the system.

Column Name

Column Type

Column Description

machine_learning_model_id

UUID

UUID of the machine learning model (sys.machine_learning_models).

coefficients

ARRAY(DOUBLE)

List of coefficients associated with the vector autoregression model.

coefficient_of_determination

DOUBLE

R^2 value of the autoregression, if calculated, otherwise NULL.

Monitoring

sys.active_operator_instances

This table contains information about operator instances that are active in the database.

Column Name

Column Type

Column Description

query_id

UUID

A unique identifier of the query this operator belongs to.

operator_id

UUID

A unique identifier of the operator that finalized.

node_id

UUID

The unique identifier of the node that stores the information about this operator.

silo_id

LONG

The unique identifier of the silo that stores the information about this operator.

core_id

LONG

The unique identifier of the vm core that stores the information about this operator.

op_runtime_id

INT

Unique operator instance identifier that the system assigns at runtime.

op_instance_type

CHAR

Name of the type for this operator instance.

bloom_filtered_rows

INT

Rows filtered by Bloom filters.

rows_received

INT

Number of rows fetched by the operator instance.

rows_processed

INT

Number of rows processed by this operator instance during execution.

rows_emitted

INT

Number of rows returned by the operator instance.

blocks_emitted

INT

Number of data blocks returned by the operator instance.

finalization_time

TIMESTAMP

Timestamp at which the operator completed all work

first_block_receive_time

TIMESTAMP

Timestamp that specifies the receipt of the first data block.

first_block_emitted_time

TIMESTAMP

Timestamp that specifies the return of the first data block.

num_cycles

INT

The number of cycles that run on this operator instance.

num_oom_cycles

INT

The number of run cycles that an operator received for processing out of memory issues.

num_failed_oom_cycles

INT

Number of out of memory cycles received that failed to do any work.

run_count

INT

Number of times that the scheduler has reviewed this operation and isRunnable is true.

no_work_cycles

INT

Number of times that the read and write cycle executed and performed no work.

backed_up_cycles

INT

Number of times a cycle stopped because a backup of the parent exists.

leaf_branch_blocked_cycles

INT

Number of times a cycle stopped on a leaf operator because of multi-child scheduling heuristics.

num_eof_cycles

INT

Number of end of file cycles received.

normal_run_time_in_ms

DOUBLE

Time span in milliseconds of the normal run (no out of memory issues) for the operator instance.

oom_run_time_in_ms

DOUBLE

Time span in milliseconds of the out of memory issue for the operator instance.

dispatch_queue_time_in_ms

DOUBLE

Time span in milliseconds of the amount of time the operator instance spent processed non-work-cycle events

max_hp_mem_usage

INT

Maximum heap memory usage by the operator instance.

num_blocks_written

INT

Number of data blocks written into the memory.

num_blocks_read

INT

Number of data blocks read from memory.

num_fragments_written

INT

Number of written memory fragments.

num_fragments_read

INT

Number of read memory fragments.

cycles_over_1_sec

INT

Count of cycles that ran over 1 second for this operator instance.

cycles_over_3_sec

INT

Count of cycles that ran over 3 seconds for this operator instance.

long_dispatch_queue_events

INT

Count of dispatch queue events processed by the operator with a runtime over 0.5s

mandatory_alloc_attempts

INT

Count of cycles where the scheduler enabled mandatory allocation.

mandatory_alloc_success_count

INT

Count of cycles where the scheduler enabled mandatory allocation, and this operator broke an out-of-memory deadlock.

max_num_pending_blocks

INT

Maximum number of pending blocks across all partitions during the lifetime of this operator

sys.completed_queries

This table contains information about queries that finished execution in the database.

Column Name

Column Type

Column Description

query_id

UUID

A unique identifier of the query that ran.

user

CHAR

The name of the user that executed the query.

database_name

CHAR

The name of the database that runs this query.

database_id

UUID

The unique identifier of the database this query ran in.

sql

CHAR

The executed SQL statement.

sql_text_length

LONG

The length of the SQL statement.

referenced_tables

ARRAY(CHAR)

The tables and views referenced by the query.

total_time

LONG

The total time in milliseconds the query took to run. This time includes generation_time, optimization_time, and execution_time.

generation_time

LONG

The time in milliseconds it took to generate the query before any processing happened.

optimization_time

LONG

The time in milliseconds the optimizer processed the query and built an optimized plan for the query.

execution_time

LONG

Time in milliseconds the query was executed by the database on the LTS nodes to return the query result.

timestamp_start

LONG

A UNIX® timestamp that represents the point in time when the query entered the system.

time_start

CHAR

An ISO 8601 representation in milliseconds of the timestamp_start value.

parsing_time

LONG

The time in milliseconds the query was parsing.

validation_time

LONG

The time in milliseconds the query was validating.

plangen_time

LONG

The time in milliseconds the query plan was being generated.

queue_time

LONG

The time in milliseconds the query was queued in the system before any processing happened.

timestamp_optimization_start

LONG

A UNIX timestamp that represents the point in time when optimization of the query started.

time_optimization_start

CHAR

An ISO 8601 representation in milliseconds of the timestamp_optimization_start value.

timestamp_execution_start

LONG

A UNIX timestamp that represents the point in time when execution of the query started.

time_execution_start

CHAR

An ISO 8601 representation in milliseconds of the timestamp_execution_start value.

tree_probe_time

LONG

The time in milliseconds taken by the VM tree probe during query execution.

vm_initialization_time

LONG

Time in milliseconds the query was initializing on all participating nodes during execution.

timestamp_first_byte_sent

LONG

A UNIX timestamp that represents the point in time when the first byte of the result set from the query was returned to the application.

time_first_byte_sent

CHAR

An ISO 8601 representation in milliseconds of the timestamp_first_byte_sent value.

timestamp_complete

LONG

A UNIX timestamp that represents the point in time when the execution of the query completed from the client's perspective.

time_complete

CHAR

An ISO 8601 representation in milliseconds of the timestamp_complete value.

timestamp_execution_complete

LONG

A UNIX timestamp that represents the point in time when the internal execution of the query completed.

time_execution_complete

CHAR

An ISO 8601 representation in milliseconds of the timestamp_execution_complete value.

awaiting_client_eof_fetch_time

LONG

A UNIX timestamp that represents the difference between when the client fetched the eof for the query and when the eof was queued internally.

rows_returned

LONG

The number of rows returned by the query.

bytes_returned

LONG

The number of bytes returned by the query.

rows_inserted

LONG

The number of rows that the query inserts. This value is NULL when the database does not insert any rows. The value is 0 when the database does not identify any rows to insert from a CREATE TABLE AS SELECT or INSERT AS SELECT SQL statement.

rows_deleted

LONG

The number of rows that the query deletes. This value is NULL when the database does not delete any rows. The value is 0 when the database does not identify any rows to delete from a DELETE FROM TABLE SQL statement.

update_subquery_execution_time

LONG

The time in milliseconds taken by the virtual machine (VM) to execute a subquery that identifies the rows for insertion or deletion. This value is NULL when you execute a SQL statement that is not one of these statements: CREATE TABLE AS SELECT, INSERT AS SELECT, or DELETE FROM TABLE.

transferred_bytes_per_second

LONG

The transfer rate in bytes per second for the result set of the query.

code

INT

The SQL code returned at the end of the query.

state

CHAR

The SQL state returned at the end of the query.

reason

CHAR

A message associated with the SQL code and SQL state.

initial_priority

DOUBLE

Priority based on the service class, session, and query-level limits.

initial_effective_priority

DOUBLE

initial_priority adjusted for total cost and memory usage.

final_effective_priority

DOUBLE

Final dynamically adjusted priority.

cost_estimate

DOUBLE

The cost estimate of the optimizer.

concurrency_service_class_name

CHAR

Name of the service class this query executes in.

concurrency_service_class_id

UUID

The unique identifier of the service class used for the query.

priority_adjust_factor

DOUBLE

The percentage amount by which the database adjusts the priority.

priority_adjust_time

INT

How frequently the database adjusts the priority during query execution.

cached_query

BOOLEAN

Flag that indicates whether the result was returned from the result set cache.

resultset_cached

BOOLEAN

Flag that indicates whether the result of the query was stored in the result set cache.

temp_disk_consumed

LONG

Flag that indicates how much temporary disk space was used by the query.

protocol_version

CHAR

The version of the client-server protocol for this connection.

driver_version

CHAR

The version of the client driver.

client_ip

CHAR

The IP address of the client that executed the query.

client_name

CHAR

The name of the client that executed the query.

client_session_id

CHAR

The session id of the client that executed the query.

num_client_threads

INT

The maximum number of client threads determined by the server.

node_id

UUID

The unique identifier of the node that stores the information about this query.

participating_nodes

ARRAY(VARCHAR)

The nodes that participated in the execution of this query.

ocient_db_version

CHAR

The Ocient database version used to run this query.

ocient_db_commit

CHAR

The Ocient database git commit used to run this query.

ocient_db_dirtied_commit

CHAR

The dirtied Ocient database git commit used to run this query.

max_temp_disk_usage

INT

The maximum temporary disk usage for this query, expressed as a percentage.

max_elapsed_time

INT

The maximum elapsed time for this query, in seconds.

max_rows_returned

LONG

The maximum number of rows this query can return.

num_root_operator_instances

INT

The number of created root operator instances.

approx_system_peak_vm_node_heap_mem_bytes

LONG

The max observed heap memory in use during execution on a single non-SQL vm node. The memory in use is not necessarily associated with this query.

approx_system_peak_vm_cluster_heap_mem_bytes

LONG

The max observed heap memory in use during execution totaled across all non-SQL vm nodes. The memory in use is not necessarily associated with this query.

approx_system_peak_vm_node_huge_mem_bytes

LONG

The max observed huge page memory in use during execution on a single non-SQL vm node. The memory in use is not necessarily associated with this query.

approx_system_peak_vm_cluster_huge_mem_bytes

LONG

The max observed huge page memory in use during execution totaled across all non-SQL vm nodes. The memory in use is not necessarily associated with this query.

approx_system_peak_sql_node_heap_mem_bytes

LONG

The max observed heap memory in use during execution on the SQL Node. The memory in use is not necessarily associated with this query.

approx_system_peak_sql_node_huge_mem_bytes

LONG

The max observed huge page memory in use during execution on the SQL Node. The memory in use is not necessarily associated with this query.

sys.completed_operator_instances

This table contains information about operator instances that have finalized in the database.

Column Name

Column Type

Column Description

query_id

UUID

A unique identifier of the query this operator belongs to.

operator_id

UUID

A unique identifier of the operator that finalized.

node_id

UUID

The unique identifier of the node that stores the information about this operator.

silo_id

LONG

The unique identifier of the silo that stores the information about this operator.

core_id

LONG

The unique identifier of the vm core that stores the information about this operator.

op_runtime_id

INT

Unique operator instance identifier that the system assigns at runtime.

op_instance_type

CHAR

Name of the type for this operator instance.

bloom_filtered_rows

INT

Rows filtered by Bloom filters.

rows_received

INT

Number of rows fetched by the operator instance.

rows_processed

INT

Number of rows processed by this operator instance during execution.

rows_emitted

INT

Number of rows returned by the operator instance.

blocks_emitted

INT

Number of data blocks returned by the operator instance.

finalization_time

TIMESTAMP

Timestamp at which the operator completed all work

first_block_receive_time

TIMESTAMP

Timestamp that specifies the receipt of the first data block.

first_block_emitted_time

TIMESTAMP

Timestamp that specifies the return of the first data block.

num_cycles

INT

The number of cycles that run on this operator instance.

num_oom_cycles

INT

The number of run cycles that an operator received for processing out-of-memory issues.

num_failed_oom_cycles

INT

Number of out of memory cycles received that failed to do any work.

run_count

INT

Number of times that the scheduler has reviewed this operation and isRunnable is true.

no_work_cycles

INT

Number of times that the read and write cycle executed and performed no work.

backed_up_cycles

INT

Number of times a cycle stopped because a backup of the parent exists.

leaf_branch_blocked_cycles

INT

Number of times a cycle stopped on a leaf operator because of multi-child scheduling heuristics.

num_eof_cycles

INT

Number of end of file cycles received.

normal_run_time_in_ms

DOUBLE

Time span in milliseconds of the normal run (no out-of-memory issues) for the operator instance.

oom_run_time_in_ms

DOUBLE

Time span in milliseconds of the out of memory issue for the operator instance.

dispatch_queue_time_in_ms

DOUBLE

Time span in milliseconds of the amount of time the operator instance spent processed non-work-cycle events

max_hp_mem_usage

INT

Maximum heap memory usage by the operator instance.

num_blocks_written

INT

Number of data blocks written into the memory.

num_blocks_read

INT

Number of data blocks read from memory.

num_fragments_written

INT

Number of written memory fragments.

num_fragments_read

INT

Number of read memory fragments.

cycles_over_1_sec

INT

Count of cycles that ran over 1 second for this operator instance.

cycles_over_3_sec

INT

Count of cycles that ran over 3 seconds for this operator instance.

long_dispatch_queue_events

INT

Count of dispatch queue events processed by the operator with a runtime over 0.5s

mandatory_alloc_attempts

INT

Count of cycles where the scheduler enabled mandatory allocation.

mandatory_alloc_success_count

INT

Count of cycles where the scheduler enabled mandatory allocation, and this operator broke an out-of-memory deadlock.

max_num_pending_blocks

INT

Maximum number of pending blocks across all partitions during the lifetime of this operator.

sys.metric_levels

This table contains settings for metric levels.

Column Name

Column Type

Column Description

match

CHAR

Metric name match.

match_type

CHAR

The type of match for the name of the metric.

level

CHAR

Metric level.

node_id

UUID

The unique node identifier for this setting. This setting might be NULL for system-wide metrics.

sys.node_status

This table contains the status of nodes in the system and the core node monitoring metrics.

Column Name

Column Type

Column Description

node_id

UUID

The UUID of the node.

operational_status

CHAR

The operational status of the node. Values are ACTIVE, STARTING, STOPPING, ERROR, UNKNOWN, or UNREACHABLE.

loadavg_1

DOUBLE

Average load on the node over the last 1 minute. Represents the average number of processes in the system run queue.

loadavg_5

DOUBLE

Average load on the node over the last 5 minutes. Represents the average number of processes in the system run queue.

loadavg_15

DOUBLE

Average load on the node over the last 15 minutes. Represents the average number of processes in the system run queue.

max_rss

LONG

Maximum resident set size (RSS) of the process on the node in bytes.

heap

LONG

Heap memory allocated on the node in bytes.

software_start

TIMESTAMP

Timestamp for the last start of the Ocient software on the node.

system_start

TIMESTAMP

Timestamp for the last start of the node hardware.

sys.op_inst_debug_info

op inst debug info test table

Column Name

Column Type

Column Description

operator_id

UUID

The UUID of the operator

node_id

UUID

The unique identifier of the node that stores the information about this operator.

silo_id

LONG

The unique identifier of the silo that stores the information about this operator.

vm_core_id

LONG

The unique identifier of the vm core that stores the information about this operator.

runtime_id

INT

The process-wide unique identifier of this operator instance.

key

CHAR

debugInfo key

value

CHAR

debugInfo value

op_inst_type

CHAR

Type of the operator Instance

sys.osn_acquisitions

client IDs for osn acquisitions

Column Name

Column Type

Column Description

node_id

UUID

The UUID of the node

client_id

UUID

The query ID of the osn acquisition

osn

LONG

The osn locked

acquisition_time

TIMESTAMP

Timestamp that represents when the osn was acquired.

sys.queries

This table contains information about queries that the database is currently executing.

Column Name

Column Type

Column Description

query_id

UUID

A unique identifier of the query that is currently running.

user

CHAR

The name of the user that executes the query.

database_name

CHAR

The name of the database that runs this query.

database_id

UUID

A unique identifier of the database this query is running in.

status

CHAR

One of these three states represents the current state of the query: QUEUED (Query is not yet executing), PAUSED (Query is not actively processing but ready to begin), RUNNING (Query is being processed).

sql

CHAR

The SQL statement that is executing.

sql_text_length

LONG

The length of the SQL statement.

referenced_tables

ARRAY(CHAR)

The tables and views referenced by the query.

total_time

LONG

The total time in milliseconds the query has run. This time includes generation_time, optimization_time, and execution_time.

generation_time

LONG

The time in milliseconds the query was generated or is still generating. This number might increase if generation is in progress.

optimization_time

LONG

The time in milliseconds the optimizer processed or is still processing the query. This number might be 0 if optimization of the query has not started yet. This number might increase if optimization is in progress.

execution_time

LONG

Time in milliseconds the query executes. This number might be 0 if execution of the query has not started yet. This number might increase if execution of the query is still in progress.

timestamp_start

LONG

A UNIX timestamp that represents the point in time when the query entered the system.

time_start

CHAR

An ISO 8601 representation in milliseconds of the timestamp_start value.

parsing_time

LONG

Time in milliseconds the query was parsing or is still parsing. This number might be 0 if parsing of the query has not started yet. This number might increase if the query is still parsing.

validation_time

LONG

Time in milliseconds the query was validating or is still being validated. This number might be 0 if validation of the query has not started yet. This number might increase if the query is still validating.

plangen_time

LONG

Time in milliseconds the query plan was being generated or is still generating. This number might be 0 if generation of the query plan has not started yet. This number might increase if the query plan is still generating.

queue_time

LONG

Time in milliseconds the query was queued or is still queuing. This number might be 0 if queuing of the query has not started yet. This number might increase if the query is still in the queue.

timestamp_optimization_start

LONG

A UNIX timestamp that represents the point in time when optimization of the query started. This value might be 0 if optimization has not started yet.

time_optimization_start

CHAR

An ISO 8601 representation in milliseconds of the timestamp_optimization_start value.

timestamp_execution_start

LONG

A UNIX timestamp that represents the point in time when execution of the query started. This value might be 0 if execution of the query has not started yet.

time_execution_start

CHAR

An ISO 8601 representation in milliseconds of the timestamp_execution_start value.

tree_probe_time

LONG

Time in milliseconds the query was in the VM tree probe stage during execution. This number might be 0 if VM tree probe has not started yet. This number might increase if the probe is still happening.

vm_initialization_time

LONG

Time in milliseconds the query was initializing on all participating nodes during execution. This number might be 0 if the VM has not begin initializing the query for execution yet.

timestamp_first_byte_sent

LONG

A UNIX timestamp that represents the point in time when the first byte of the result set from the query was returned to the application. This value might be 0 if execution of the query has not started yet or no bytes have been transferred yet.

time_first_byte_sent

CHAR

An ISO 8601 representation in milliseconds of the timestamp_first_byte_sent value.

rows_returned

LONG

The number of rows returned by the query. This value might be 0 if no rows have been transferred so far.

bytes_returned

LONG

The number of bytes returned by the query. This value might be 0 if no rows have been transferred so far.

rows_inserted

LONG

The number of rows that the query inserts. This value is NULL when the database does not insert any rows. The value is 0 when the database does not identify any rows to insert from a CREATE TABLE AS SELECT or INSERT AS SELECT SQL statement.

rows_deleted

LONG

The number of rows that the query deletes. This value is NULL when the database does not delete any rows. The value is 0 when the database does not identify any rows to delete from a DELETE FROM TABLE SQL statement.

update_subquery_execution_time

LONG

The time in milliseconds taken by the VM to execute a subquery that identifies the rows for insertion and deletion. This value is NULL when you execute a SQL statement that is not one of these statements: CREATE TABLE AS SELECT, INSERT AS SELECT, or DELETE FROM TABLE.

initial_priority

DOUBLE

Priority based on the service class, session, and query level limits.

initial_effective_priority

DOUBLE

initial_priority adjusted for total cost and memory usage.

effective_priority

DOUBLE

Current dynamically adjusted priority.

estimated_time

INT

The estimate of the optimizer for the time in milliseconds to process the query.

estimated_result_rows

LONG

The estimate of the optimizer for the number of rows in the result set.

estimated_result_size

LONG

The estimate of the optimizer for the size of the result set in bytes.

concurrency_service_class_name

CHAR

Name of the service class this query executes in.

concurrency_service_class_id

UUID

The unique identifier of the service class used for the query.

priority_adjust_factor

DOUBLE

The percentage amount by which the database adjusts the priority.

priority_adjust_time

INT

How frequently the database adjusts the priority during query execution.

cached_query

BOOLEAN

Flag that indicates whether the result is returned from the result set cache.

server_ip

IPV4

The IP address of the SQL node that executed the query.

protocol_version

CHAR

The version of the client-server protocol for this connection.

driver_version

CHAR

The version of the client driver.

client_ip

CHAR

The IP address of the client that executed the query.

client_name

CHAR

The name of the client that executed the query.

client_session_id

CHAR

The session id of the client that executed the query.

num_client_threads

INT

The maximum number of client threads determined by the server.

node_id

UUID

The unique identifier of the node that provided the information about this query.

participating_nodes

ARRAY(VARCHAR)

The nodes that are currently known to be participating in the execution of this query. If the query is not in the RUNNING state, this list might not include all nodes that participate.

max_temp_disk_usage

INT

The maximum temporary disk usage for this query, expressed as a percentage.

max_elapsed_time

INT

The maximum elapsed time for this query, in seconds.

max_rows_returned

LONG

The maximum number of rows this query can return.

num_root_operator_instances

INT

The number of created root operator instances.

approx_system_peak_vm_node_heap_mem_bytes

LONG

The max observed heap memory in use during execution on a single non-SQL vm node. The memory in use is not necessarily associated with this query.

approx_system_peak_vm_cluster_heap_mem_bytes

LONG

The max observed heap memory in use during execution totaled across all non-sql vm nodes. The memory in use is not necessarily associated with this query.

approx_system_peak_vm_node_huge_mem_bytes

LONG

The max observed huge page memory in use during execution on a single non-SQL vm node. The memory in use is not necessarily associated with this query.

approx_system_peak_vm_cluster_huge_mem_bytes

LONG

The max observed huge page memory in use during execution totaled across all non-SQL vm nodes. The memory in use is not necessarily associated with this query.

approx_system_peak_sql_node_heap_mem_bytes

LONG

The max observed heap memory in use during execution on the sql node. The memory in use is not necessarily associated with this query.

approx_system_peak_sql_node_huge_mem_bytes

LONG

The max observed huge page memory in use during execution on the sql node. The memory in use is not necessarily associated with this query.

sys.result_cache

This table contains queries that have cached results in the system.

Column Name

Column Type

Column Description

node_id

UUID

The UUID of the node that holds the cache results.

query_id

UUID

The UUID of the query.

database_id

UUID

The database of the query.

service_class_id

UUID

The UUID of the service class of the query.

timestamp

LONG

The timestamp in seconds after the UNIX epoch when the result set entered the cache.

time

CHAR

The human-readable time when the result set entered the cache.

time_remaining

LONG

The amount of time remaining in seconds before the cached result set expires.

referenced_tables

ARRAY(CHAR)

All referenced tables in this query.

sys.service_role_status

This table contains the status of each service role on the system.

Column Name

Column Type

Column Description

node_id

UUID

The UUID of the node.

service_role_id

UUID

The UUID of the service role. References sys.service_roles.

service_role_name

CHAR

The human-readable name of the service role on the node.

status

CHAR

The current status of the role on this node.

sys.storage_device_metrics

This table contains monitoring metrics collected on each storage device that is controlled by Ocient.

Column Name

Column Type

Column Description

id

CHAR

Unique and persistent serial number of the drive. This serial number is not a UUID.

key

CHAR

Name of the measured statistic on the drive.

value

CHAR

Value of the named statistic on the drive.

transient

BOOLEAN

When the value is true, the value indicates that it is transient in nature and is reset when the node is restarted.

node_id

UUID

The UUID of the node that contains the storage device.

sys.storage_device_status

This table contains real-time information about the storage devices for each online node.

Column Name

Column Type

Column Description

node_id

UUID

The UUID of the node that contains the storage device.

device_id

INT

ID of the drive.

role_name

CHAR

The name of the role or roles active on the node that contains the storage device.

id

CHAR

Unique and persistent serial number of the drive. This serial number is not a UUID.

pci_address

CHAR

PCI address where the drive is mounted.

device_model

CHAR

Model information about the drive.

manufacturer

CHAR

Manufacturer information about the drive.

firmware_version

CHAR

Firmware version active on the drive.

capacity

LONG

Capacity, in bytes, of the drive.

utilization

LONG

Utilization, in bytes, of the drive.

endurance_percentage_used

DOUBLE

Value from 0 to 1 that represents an estimate of the percentage of the drive used, as it applies to drive endurance.

device_status

CHAR

Human-readable version of the drive status. Values are ACTIVE, FAILED, or NOT PRESENT.

encryption_drive_locking_supported

BOOLEAN

Indicates whether encryption drive locking (e.g., OPAL) is enabled on the device.

encryption_drive_locking_enabled

BOOLEAN

Indicates whether encryption drive locking (e.g., OPAL) is supported on the device.

encryption_drive_locking_status

CHAR

Indicates the status of drive locking (e.g., OPAL): LOCKED, or UNLOCKED. If drive locking is not supported, this value is UNLOCKED.

sys.subtasks

This table contains the status and details of subtasks in the system

Column Name

Column Type

Column Description

id

UUID

Task identifier

name

CHAR

Task name

task_type

CHAR

Task type

execution_type

CHAR

Task execution type

location_type

CHAR

Location type where the task must run

location_id

CHAR

Location where the task must run

task_options

CHAR

Task arguments

start_time

TIMESTAMP

Task start time

end_time

TIMESTAMP

Task end time

last_poll_time

TIMESTAMP

Last time the task was polled for status

duration

LONG

Task duration in milliseconds

status

CHAR

Current task status

details

CHAR

Current task status details or results

task_owner_id

UUID

Identifier of the node that is running the task

admin_owner_id

UUID

Identifier of the node that is monitoring the task

parent_task_id

UUID

Identifier of the parent task of the task

root_task_id

UUID

Identifier of the root task of the task

database_id

UUID

Database identifier

parallelization

CHAR

Parallelization type of the task

Network

sys.channel_endpoint_parameters

This table contains details for the endpoints defined on the nodes in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the channel endpoint.

node_id

UUID

UUID of the node where the endpoint is located (sys.nodes).

name

CHAR

Name of the channel endpoint.

endpoint_type

CHAR

Type of the channel endpoint (FULL or EXTERNAL).

port

INT

Port that the channel endpoint is using.

ip_address

CHAR

IP address of the channel endpoint.

context_type

CHAR

Context type of the channel endpoint

listener_type

CHAR

Listener type of the channel endpoint

initiator_type

CHAR

Initiator type of the channel endpoint.

encrypted

BOOLEAN

Specifies whether the channel endpoint is encrypted.

sys.network_interface_models

This table contains the network devices registered on the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the NIC.

manufacturer

CHAR

Manufacturer of the NIC.

model_name

CHAR

Model name of the NIC.

pci_id

CHAR

PCI identifier.

pci_subsys_id

CHAR

PCI Subsystem identifier.

driver_type

CHAR

Driver type of NIC.

bits_per_second

LONG

Bits per second.

sys.network_interface_usage_types

This table contains the uses of each network device in the system.

Column Name

Column Type

Column Description

network_interface_id

UUID

UUID of the network interface (sys.network_interfaces).

network_interface_model_id

UUID

UUID of the network interface model (sys.network_interface_models).

network_type

CHAR

Usage type of NIC (ADMIN, DATA, EXTERNAL, LOCAL_HSI).

sys.node_network_interfaces

This table contains the network interfaces on each node.

Column Name

Column Type

Column Description

network_interface_model_id

UUID

UUID of the network interface model (sys.network_interface_models).

network_interface_id

UUID

UUID of the network interface.

node_id

UUID

UUID of the node where this interface exists (sys.nodes).

interface_type

CHAR

Type of interface (PHYSICAL, BOND_SLAVE, BOND_MASTER).

address

CHAR

MAC address of the NIC.

name

CHAR

Name of the NIC.

netmask

CHAR

Netmask of the NIC.

gateway

CHAR

Gateway of the NIC.

pci_address

CHAR

PCI address of the NIC.

master_interface_name

CHAR

Master interface name of the NIC.

bond_type

CHAR

Network bond type of the NIC.

sys.service_role_channel_endpoints

This table contains the channel endpoint parameters that are enabled for each network type and service role.

Column Name

Column Type

Column Description

service_roles_id

UUID

UUID of the service role of this endpoint (sys.service_roles).

channel_endpoint_parameters_id

UUID

UUID of the parameters for this endpoint (sys.channel_endpoint_parameters).

network_type

CHAR

Network type for this endpoint (ADMIN, DATA, EXTERNAL, LOCAL_HSI).

Pipelines

sys.pipelines

This table contains all of the pipelines in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the pipeline.

name

CHAR

Name of the pipeline.

database_id

UUID

UUID of the database of this pipeline (sys.databases).

loading_mode

CHAR

Specifies whether the pipeline runs in a one-time (BATCH) or continuous (CONTINUOUS) way.

source_type

CHAR

Source of the data (S3, KAFKA, FILESYSTEM).

data_format

CHAR

Structure of the data (DELIMITED, CSV, JSON).

created_at

TIMESTAMP

Timestamp of when this pipeline was created.

updated_at

TIMESTAMP

Timestamp of when this pipeline was last updated.

task_id

UUID

UUID of the task (sys.tasks).

creator_id

UUID

UUID of the user who created the pipeline (sys.users).

sys.pipeline_files

This table contains all of the pipeline files.

Column Name

Column Type

Column Description

pipeline_id

UUID

UUID of the pipeline (sys.pipelines).

name

CHAR

Name of the file.

create_timestamp

TIMESTAMP

Timestamp that represents when this file is created.

modified_timestamp

TIMESTAMP

Timestamp that represents when this file is last modified.

size

LONG

Size of the file.

status

CHAR

Status of the file that updates throughout the process of a pipeline load.

stream_source_id

LONG

Identifier of the associated partition stream source.

extractor_task_id

UUID

UUID of the task requested to load this file (sys.subtasks).

sys.pipeline_tables

This table contains all of the tables currently associated with pipeline objects in the system.

Column Name

Column Type

Column Description

pipeline_id

UUID

UUID of the pipeline (sys.pipelines).

table_id

UUID

UUID of the table (sys.tables).

sys.pipeline_task_ids

This table contains all of the pipeline tasks.

Column Name

Column Type

Column Description

pipeline_id

UUID

UUID of the pipeline (sys.pipelines).

pipeline_task_id

UUID

UUID of the pipeline task associated with this pipeline run (sys.subtasks).

SQL Messages

sys.sql_messages

This table contains information about the SQL errors and warnings Ocient DB can produce.

Column Name

Column Type

Column Description

name

CHAR

SQL error or warning name.

code

INT

SQL error or warning code.

state

CHAR

SQL error or warning state.

reason

CHAR

Description of the SQL error or warning.

is_error

BOOLEAN

Whether or not this SQL message is an error or warning.

Security

sys.security_settings

This table contains security settings.

Column Name

Column Type

Column Description

database_id

UUID

The database for this setting. This might be NULL for system-wide settings

group_id

UUID

The group for this settings when the setting is for a group

password_minimum_length

INT

Minimum password length.

password_complexity_level

INT

Password complexity requirement.

password_lifetime_days

INT

Password lifetime in days.

password_no_repeat_count

INT

Password repetition count.

password_invalid_attempt_limit

INT

Invalid password attempt limit.

Security Integrations

sys.oidc_integrations

This table enumerates the configuration for OpenID Connect Single Sign-On integrations (i.e. OKTA®). You can modify this configuration using the ALTER DATABASE ALTER SSO INTEGRATION oidc DDL statement where is the name of your database.

Column Name

Column Type

Column Description

security_integration_id

UUID

The id of this OpenID Connect (OIDC) Single Sign-On integration.

database_id

UUID

The id of the database using this Single Sign-On authorization to this integration.

disabled

BOOLEAN

When true, all new connections made using this Single Sign-On integration will fail.

default_group

CHAR

The group which all users of this Single Sign-On integration are granted membership to.

issuer

CHAR

The complete URL for the OAuth 2.0 / OpenID Connect Authorization Server. This is the expected "iss" claim in an access token.

client_id

CHAR

The provider-supplied ID of this Single Sign-On integration.

public_client

BOOLEAN

When true, PKCE is used in place of a client authentication method

enable_id_token_authentication

BOOLEAN

When true, a fat ID Token is sufficient to connect to the database.

user_id_claims

ARRAY(CHAR)

The id token claim(s) used to identify users in audit trails.

additional_scopes

ARRAY(CHAR)

Request scopes for authorization requests.

additional_audiences

ARRAY(CHAR)

Additional token audience to accept when validating tokens. This is useful for Authorization Servers without a token exchange capability.

groups_claim_ids

ARRAY(CHAR)

The token claims that can be used to map the user to a Database group. You must provide groups_claim_ids if groups_claim_mappings is provided.

groups_claim_mappings

CHAR

The mappings from Provider group => Database group.

roles_claim_ids

ARRAY(CHAR)

The token claims that can be used to map the user to a Database role. You must provide roles_claim_ids if roles_claim_mappings is provided.

roles_claim_mappings

CHAR

The mappings from Provider role => Database role.

blocked_groups

ARRAY(CHAR)

Provider groups that are restricted from connecting to the database.

blocked_roles

ARRAY(CHAR)

Provider roles that are restricted from connecting to the database.

enable_debug_flow

BOOLEAN



request_scopes

ARRAY(CHAR)

All request scopes for authorization requests.

sys.oidc_sessions

The sys.oidc_sessions table contains information about active database connections established using an OpenID Connect (oidc) Single Sign-On integration.

Column Name

Column Type

Column Description

id

UUID

The unique identifier for this session.

user

CHAR

The Fully Qualified User Name (FQUN) of this user.

database_id

UUID

The id of the database associated with this session.

security_integration_id

UUID

The id of the OpenID Connect (OIDC) Single Sign-On integration that authorized.

has_access_token

BOOLEAN

True if the identity provider supplied an Access Token.

has_refresh_token

BOOLEAN

True if the identity provider supplied a Refresh Token.

compact_id_token

CHAR

The JWS compact serialization form of the ID Token.

id_token_json

CHAR

The ID Token claims.

sys.security_integrations

This table contains the OIDC security integrations installed on the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the OIDC security integration.

database_id

UUID

UUID of the database associated with this security integration (sys.databases).

integration_type

CHAR

The type of the security integration (SSO, SCIM, LDAP, etc.).

table_descriptor

CHAR

An indirect pointer to the table where you can view the objects of this integration.

sys.sessions

This table contains information about active client connections.

Column Name

Column Type

Column Description

id

UUID

The unique identifier for this session.

user

CHAR

The Fully Qualified User Name (FQUN) of this user.

sso_protocol

CHAR

The Single Sign-On (SSO) protocol used to authorize the connection request. Null if basic password authentication was used. Tables exists for each SSO protocol using the following naming scheme: "_sessions". For example, all sessions created using the OpenID Connect (oidc) protocol will be listed in the "sys.oidc_sessions" table.

database_id

UUID

The id of the database associated with this session.

default_schema

CHAR

The default schema used for queries submitted by this user.

created_at_timestamp

LONG

The number of seconds from epoch the session was established.

duration

LONG

The number of seconds since the session was established.

expires_at_timestamp

LONG

The number of seconds from epoch the session will expire.

is_renewable

BOOLEAN

When true, the database will attempt to extend the session when it expires.

client_ip

CHAR

The IP address of the client.

client_name

CHAR

The human-readable name of the client.

client_session_id

CHAR

An opaque identifier provided by client implementations. Used to correlate events across application boundaries.

protocol_version

CHAR

The version of the client-server protocol for this connection.

driver_version

CHAR

The version of the client driver.

tls_enabled

BOOLEAN

True if TLS is enabled for this client connection.

node_id

UUID

The unique identifier of the node the client is connected to.

connectivity_pool_id

UUID

The unique identifier of the connectivity pool the client is connected on.

group_names

CHAR

Names of all groups in the session.

role_names

CHAR

Names of all roles in the session.

active_service_class_names

CHAR

Names of all active service classes in the session.

inactive_service_class_names

CHAR

Names of all inactive service classes in the session.

Statistics

sys.average_bb_sizes

This table contains the average size of bounding boxes in the database for geospatial data types.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

column_id

UUID

UUID of the column (sys.columns).

avg_width

DOUBLE

Average width of bounding boxes in this column.

avg_height

DOUBLE

Average height of bounding boxes in this column.

sys.average_column_sizes

This table contains the average size of each column in the database.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

column_id

UUID

UUID of the column (sys.columns).

size

DOUBLE

Average size of the column.

sys.columns_compression_info

This table contains column-level compression statistics for fixed-length columns. The system calculates statistics from the column data across all segments.

Column Name

Column Type

Column Description

node_id

UUID

UUID of the node that owns the segments included in these statistics.

table_id

UUID

UUID of the table of this column (sys.tables).

ordinal

INT

Ordinal of the column.

is_deltadelta_enabled

BOOLEAN

Specifies whether deltadelta compression is enabled.

is_rle_enabled

BOOLEAN

Specifies whether RLE compression scheme is enabled.

is_ne_enabled

BOOLEAN

Specifies whether the NULL elimination compression scheme is enabled.

raw_size

LONG

Size of the data in bytes before compression.

compressed_size

LONG

Size of the data in bytes after compression.

num_deltadelta_blocks

LONG

Number of data blocks compressed using the deltadelta compression.

num_rle_blocks

LONG

Number of data blocks compressed using the RLE (Run-Length Encoding) compression scheme.

num_nerle_blocks

LONG

Number of data blocks compressed using a combination of the RLE and NE (NULL Elimination) compression schemes.

num_uncompressed_blocks

LONG

Number of uncompressed data blocks.

num_total_blocks

LONG

Total number of data blocks.

sys.column_cardinalities

This table contains the number of unique values of each column in the database.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

column_id

UUID

UUID of the column (sys.columns).

cardinality

LONG

Number of unique values in this column.

stats_type

CHAR

Represents the type of values, either 'COLUMN' or 'INNER_ARRAY'.

sys.column_distributions

This table contains some statistical characteristics of the calculated Kernel Density Distribution of data in the database columns.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

column_id

UUID

UUID of the column (sys.columns).

bandwidth

DOUBLE

Smoothing parameter for the distribution.

minimum_value

DOUBLE

Minimum value found in the distribution.

maximum_value

DOUBLE

Maximum value found in the distribution.

stats_type

CHAR

Represents the type of values in the distribution, either 'TABLE' or 'INNER_ARRAY'.

sys.segments_compression_info

This table contains segment-level compression statistics. The system calculates statistics from the data within the specified segment. All block statistics apply only to fixed-length columns within the segment. Non-block specific statistics (e.g., size information) include both fixed and variable-length columns.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table relevant to this segment (sys.tables).

segment_id

UUID

UUID for the segment.

num_deltadelta_blocks

LONG

Number of data blocks compressed using deltadelta compression

num_rle_blocks

LONG

Number of data blocks compressed using RLE (Run-Length Encoding) compression scheme

num_nerle_blocks

LONG

Number of data blocks compressed using a combination of RLE and NE (Null Elimination) compression schemes

num_uncompressed_blocks

LONG

Number of uncompressed data blocks

num_total_blocks

LONG

Total number of data blocks

raw_size

LONG

Size of the data part before any compression and without any parity data

compressed_size

LONG

Size of the data part after compression and without any parity data + Size of the manifest part

compressed_data_part_size

LONG

Size of the data part after compression and without any parity data

num_cluster_keys

LONG

Number of unique cluster keys in the segment

num_time_buckets

LONG

Number of time buckets in the segment

sys.stats_files

This table contains information about the on-disk cache for each Foundation Node of the local table probability density functions (PDFs) and array PDFs.

Column Name

Column Type

Column Description

node_id

UUID

The UUID of the node. References id in sys.nodes.

table_id

UUID

The UUID of the table. References id in sys.tables.

file_id

UUID

The UUID of the file.

file_type

CHAR

The type of this file. Values are ARRAY_PDF, TABLE_PDF, or TABLE_CDE.

file_size

LONG

Size in bytes of the file.

column_ordinal

LONG

Ordinal of the column where the stats file applies. The ordinal references sys.columns for the specified table. The value is NULL when file_type is TABLE_PDF.

updated_at

TIMESTAMP

Timestamp of the last update to this file.

is_stale

BOOLEAN

Whether any rows are present on disk that were not present when this stats file was last updated

rows_computed_from

LONG

Number of rows present on the node when this stats file was last updated

sys.table_cardinalities

This table contains the overall cardinality of the individual tables in the database.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

cardinality

LONG

Number of elements in this table.

sys.vl_columns_compression_info

This table contains column-level compression statistics for variable-length columns. The system calculates statistics from the column data across all segments.

Column Name

Column Type

Column Description

node_id

UUID

UUID of the node that owns the segments included in these statistics.

table_id

UUID

UUID of the table (sys.tables).

ordinal

INT

Ordinal of the column.

is_compression_enabled

BOOLEAN

Whether compression is enabled.

raw_size

LONG

Size of the data in bytes before compression.

compressed_size

LONG

Size of the data in bytes after compression.

num_lz4_rows

LONG

Number of lz4 compressed rows.

num_uncompressed_rows

LONG

Number of uncompressed rows.

num_null_rows

LONG

Number of NULL rows.

num_total_rows

LONG

Total number of rows.

Storage

sys.segments

This table contains the individual segments stored in each storage cluster including basic information about the segment and the segment group where the segment belongs. The table contains queryable segments only. Quarantined segments or segments not yet activated do not appear in this table (they are present in the sys.stored_segments table).

Column Name

Column Type

Column Description

segment_group_id

CHAR

UUID of the segment group (sys.segment_groups).

segment_type

CHAR

Type of the segment (TKT).

ida_offset

INT

Unique index of the segment in the segment group.

row_count

LONG

Count of rows in the segment.

storage_id

UUID

UUID for the stored segment (sys.stored_segments.storage_id).

segment_size

LONG

Size of the segment in bytes.

sys.segment_group_transfers

This table contains all segment group transfers between clusters.

Column Name

Column Type

Column Description

id

UUID

UUID of the segment group transfer.

src_cluster_id

UUID

UUID of the source cluster (sys.clusters).

dst_cluster_id

UUID

UUID of the destination cluster (sys.clusters).

status

CHAR

The status of the transfer.

segment_group_ids

ARRAY(LONG)

List of the identifiers of segment groups in this transfer.

src_committed_osn

CHAR

The Ownership Storage Number (OSN) in which the segment groups are considered fully transferred from the source cluster.

dst_committed_osn

CHAR

The OSN in which the segment groups are considered fully transferred from the destination cluster.

sys.segment_groups

This table contains all segment groups stored on the cluster with details about the ownership, associated table, data structure, and other metadata.

Column Name

Column Type

Column Description

id

CHAR

ID of the segment group.

cluster_id

UUID

UUID of the internal cluster of this segment group.

segment_type

CHAR

Type of the segment (TKT, PAGE, etc.).

status

CHAR

The availability and health status of the segment group.

primary_owner

UUID

For a replicated segment group, the UUID of the node that serves the segment (sys.nodes).

loader_id

UUID

The streamloader node that wrote the segment group (sys.nodes).

table_id

UUID

UUID of the table (sys.tables).

scope_id

UUID

UUID of the storage scope (sys.storage_scopes).

block_size

LONG

Disk block size used to store segments in this group in bytes.

begin_time

LONG

Start time of the bucket of this segment group in the time bucket column of its table.

end_time

LONG

End time of the bucket of this segment group in the time bucket column of its table.

coding_algorithm

CHAR

Coding algorithm used to erasure code this group (NO_CODING, PQ_PARITY, REED_SOLOMON).

coding_block_size

INT

The unit size that is erasure coded in bytes.

coding_threshold

INT

The number of coding blocks required to rebuild all blocks in a coding line.

coding_width

INT

The number of coding blocks in a coding line.

replication

INT

The number of replicas of each segment in the group.

parity_cycle

INT

Parity cycle that the system calculates by multiplying by the coding_width to return the number of segments in the segment group.

created_time

TIMESTAMP

Specifies the time, in nanoseconds, when this segment group was created.

rolehostd_version

CHAR

The version of the rolehostd binary at the time of the segment group generation.

commit_hash

CHAR

The commit hash of the rolehostd binary at the time of the segment group generation.

timestamp

CHAR

The build timestamp or commit timestamp of the rolehostd binary at the time of the segment group generation.

build_user

CHAR

The build user of the rolehostd binary at the time of the segment group generation.

sys.segment_parts

This table contains the segment parts associated with each segment group. These segment parts belong to queryable segments. The table does not display parts that belong to quarantined segments or segments not yet activated.

Column Name

Column Type

Column Description

segment_group_id

CHAR

UUID of the segment group.

ida_offset

INT

Unique index of the segment. The original copy of this segment part belongs to this segment.

name

CHAR

Name of the segment part.

part_type

CHAR

Partial identifier of a segment part (DATA, INDEX, MANIFEST, STATS).

size

LONG

Size of the segment part in bytes.

segment_ida_offset

INT

Unique index of a segment within a segment group.

segment_lba_offset

LONG

Offset of this segment part within the Logical Block Address (LBA) on disk.

sys.segment_part_redundancy_info

This table contains the redundancy strategy for each table and the segment part type.

Column Name

Column Type

Column Description

table_id

UUID

UUID of the table (sys.tables).

part_name

CHAR

Name of the segment part.

redundancy_type

CHAR

The redundancy strategy for this part (COPY, PARITY).

sys.storage_capacity

This table contains information about storage capacity for each node.

Column Name

Column Type

Column Description

node_id

UUID

UUID of the node (sys.nodes).

capacity_bytes

LONG

Approximate storage capacity of the node in bytes.

cluster_id

UUID

UUID of the cluster (sys.clusters).

sys.storage_scopes

This table contains the storage scopes defined in the system with the number of rows, page groups, and segment groups in each storage scope.

Column Name

Column Type

Column Description

id

UUID

UUID of the storage scope.

row_count

LONG

The number of rows that have been currently loaded onto the scope.

num_page_groups

LONG

The number of page groups currently present in the scope.

num_tkt_segment_groups

LONG

Number of TKT segment groups currently present in the scope.

cluster_id

UUID

UUID of the cluster (sys.clusters).

sys.storage_spaces

This table contains information for all defined storage spaces.

Column Name

Column Type

Column Description

id

UUID

UUID of the storage space.

name

CHAR

Name of the storage space.

is_system_storage_space

BOOLEAN

Is this storage space the system storage space.

block_size

INT

Unit size that is erasure coded in bytes.

total_width

INT

The coding width. (The N in an M of N parity configuration.)

parity_width

INT

Within a coding line, the number of blocks dedicated to storing parity information.

parity_type

CHAR

The methodology used to compute parity blocks (P+Q, XOR, REED, SOLOMON, NONE).

parity_cycles

INT

Parity cycles calculated by multiplying by total_width to return the number of segments in the segment group.

page_replication

INT

Specifies the number of nodes for replication of stored pages.

sys.storage_used

This table contains information about storage utilization for each node.

Column Name

Column Type

Column Description

node_id

UUID

UUID of the node (sys.nodes).

table_id

UUID

UUID of the table (sys.tables).

used_bytes

LONG

Approximate storage utilization of the table on the node in bytes.

cluster_id

UUID

UUID of the cluster (sys.clusters).

sys.stored_segments

This table contains details for each segment that is saved to disk.

Column Name

Column Type

Column Description

segment_group_id

CHAR

UUID of the segment group (sys.segment_groups).

cluster_id

UUID

UUID of the cluster (sys.clusters).

ida_offset

INT

Index of the segment in the segment group.

storage_id

UUID

UUID of this stored segment.

node_id

UUID

UUID of the node (sys.nodes).

status

CHAR

The current status of the segment (MISSING, INTACT, etc.).

kind

CHAR

The kind of segment (DISK, VIRTUAL).

start_osn

CHAR

The start OSN for the latest OSN range of the segment.

end_osn

CHAR

The end OSN for the latest OSN range of the segment.

visibility

CHAR

Whether the segment is visible.

row_count

LONG

Count of rows in the segment.

segment_size

LONG

Size of the segment in bytes.

System

sys.clusters

This table contains all clusters defined in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the cluster (sys.clusters.id).

name

CHAR

Name of the cluster.

cluster_type

CHAR

Type of the cluster.

storage_space_ids

ARRAY(UUID)

UUIDs of the storage spaces used in this cluster (sys.storage_spaces.id).

sys.compute_configurations

This table contains the compute configurations for nodes and clusters in the system.

Column Name

Column Type

Column Description

cluster_id

UUID

UUID of the cluster that this node belongs to (sys.clusters.id).

node_id

UUID

UUID of the node (sys.nodes.id).

level

LONG

Execution level for this node or cluster.

csn

LONG

Compute sequence number.

sys.locks

This table contains information of the currently queued and granted lock requests.

Column Name

Column Type

Column Description

request_id

UUID

The unique identifier of the lock.

owner_identifier

CHAR

The unique identifier of the owner of the lock. Should be of format <node uuid with lowercase chars>.<locking system>.<locking reason>.<process uuid>

lock_scope_id

CHAR

An identifier on the scope of the lock, should be of format <system>.<type>.<target unique identifier>

lock_type

CHAR

Whether the lock is to READ or WRITE on the elements in its scope.

status

CHAR

The status of the lock, QUEUED means that it is waiting to be accepted, GRANTED means it is currently active.

createTime

TIMESTAMP

A unix timestamp of when the lock was created.

lastRefreshTime

TIMESTAMP

A unix timestamp of when the lock was last refreshed.

priortyId

UUID

The identifier to facilitate lock prioritization.

sys.lts_cluster_info

This table contains the storage clusters defined in the system.

Column Name

Column Type

Column Description

cluster_id

UUID

UUID of the storage cluster (sys.clusters.id).

storage_space_ids

ARRAY(UUID)

UUIDs of the storage spaces used in this cluster (sys.storage_spaces.id).

sys.nodes

This table contains all nodes defined in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the node.

unique_node_number

INT

Ordinal number assigned to the node.

name

CHAR

Name of the node.

status

CHAR

Status of the node (ACCEPTED, UNACCEPTED, INVALID).

hostname

CHAR

Hostname of the node.

software_version

CHAR

Version of the software running on this node.

kernel_version

CHAR

Version of the kernel running on this node.

system_version

CHAR

Version of Linux® running on this node.

system_memory

LONG

Amount of available system memory in bytes.

sockets

INT

Number of CPU sockets.

cores_per_socket

INT

Number of cores per CPU socket.

hugepages_1gb

INT

Number of configured 1GB huge pages.

hugepages_2mb

INT

Number of configured 2MB huge pages.

hyperthreaded

BOOLEAN

Whether the node is hyperthreaded.

sys.node_clusters

This table contains nodes that are members of each cluster.

Column Name

Column Type

Column Description

cluster_id

UUID

UUID of the cluster that this node belongs to.

node_id

UUID

UUID of the node.

ordinal

INT

Ordinal of this node.

sys.service_roles

This table contains the service roles defined on each node.

Column Name

Column Type

Column Description

id

UUID

UUID of the service role.

service_role_type

CHAR

Type of the service role.

node_id

UUID

UUID of the node. (sys.nodes.id)

level

CHAR

Execution level of the node.

System Information

sys.function_signatures

This table contains all function signatures defined in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the function signature.

name

CHAR

Name of the function.

return_type

CHAR

Return type of the function.

arg_types

ARRAY(VARCHAR)

The types of all arguments in the function.

function_type

CHAR

Type of the function.

sys.reserved_words

This table contains all reserved words defined in Ocient.

Column Name

Column Type

Column Description

reserved_word

CHAR

A word that is a reserved keyword for use by Ocient.

sys.system_information

This table contains the system name for the Ocient system.

Column Name

Column Type

Column Description

id

UUID

UUID for the overall system.

name

CHAR

User-defined name of the system.

minimum_software_version

INT

Minimum software version.

sys.system_tables

This table contains all tables available in the system catalog.

Column Name

Column Type

Column Description

id

UUID

UUID of the table (sys.tables).

name

CHAR

Name of the table.

sys.system_table_columns

This table contains all columns for tables available in the system catalog.

Column Name

Column Type

Column Description

id

UUID

The UUID of this column (sys.columns).

name

CHAR

The name of this column.

data_type

CHAR

The data type of the column.

nullable

BOOLEAN

Whether or not this column is nullable.

ordinal

LONG

The ordinal of this column.

table_name

CHAR

The name of the table to which this column belongs.

description

CHAR

Description of the column.

User Management

sys.groups

This table contains information, including the service class, related to each group.

Column Name

Column Type

Column Description

id

UUID

UUID of the group.

name

CHAR

Name of the group.

database_id

UUID

UUID of the database (sys.databases).

service_class_id

UUID

UUID of the service class of this group (sys.service_classes).

sys.group_roles

This table contains roles that belong to each group.

Column Name

Column Type

Column Description

group_id

UUID

UUID of the group (sys.groups).

role_id

UUID

UUID of the role (sys.roles).

sys.privileges

This table contains information related to the privileges granted in Ocient.

Column Name

Column Type

Column Description

timestamp

TIMESTAMP

Timestamp of the grant given.

grantor

CHAR

The user who granted this privilege.

grantee

CHAR

The user who received this privilege.

privilege

CHAR

The privilege for the grant.

object_type

CHAR

The type of object on which this privilege was granted.

object_id

UUID

UUID of the object.

grantable

BOOLEAN

Whether the user can grant this privilege to another user.

sys.rights

This table contains information related to the rights granted in Ocient.

Column Name

Column Type

Column Description

entity_type

CHAR

Owner of the right (user, group, role).

entity_id

UUID

UUID of the owner.

target_type

CHAR

Type of the target.

target_id

UUID

UUID of the target.

value

CHAR

The right being given (CREATE, READ, UPDATE, DELETE, SECURITY).

sys.roles

This table contains roles in the system.

Column Name

Column Type

Column Description

id

UUID

UUID of the role.

database_id

UUID

UUID of the database of this role (sys.databases).

name

CHAR

Name of this role.

description

CHAR

Detailed description of this role.

sys.users

This table contains information about users in Ocient.

Column Name

Column Type

Column Description

id

UUID

UUID of the user.

user_name

CHAR

Username.

database_id

UUID

UUID of the database.

first_name

CHAR

First name of the user.

last_name

CHAR

Last name of the user.

email

CHAR

Email address of the user.

password_updated_at

TIMESTAMP

Timestamp that represents the date and time for the last time the password for this user was updated

state

CHAR

State.

invalid_login_attempts

INT

Number of invalid login attempts since last successful login.

sys.user_groups

This table contains the users that belong to groups in Ocient.

Column Name

Column Type

Column Description

user_id

UUID

UUID of the user (sys.users).

group_id

UUID

UUID of the group where the user belongs (sys.groups).

sys.user_roles

This table contains roles associated with each user.

Column Name

Column Type

Column Description

user_id

UUID

UUID of the user (sys.users).

role_id

UUID

UUID of the role (sys.roles).

Workload Management

sys.service_classes

This table shows information about the service classes used for workload management in Ocient. For more details on workload management, see the corresponding section of the user documentation.

Column Name

Column Type

Column Description

id

UUID

The ID of the service class.

database_id

UUID

The ID of the database that has the service class.

name

CHAR

The name of the service class.

max_temp_disk_usage

LONG

The maximum temporary disk usage for a query running with this service class.

max_elapsed_time

LONG

The maximum time, in seconds, that a query running with this service class can run.

max_concurrent_queries

LONG

The maximum number of queries that can run concurrently with this service class.

max_rows_returned

LONG

The maximum number of rows a query running with this service class can return.

scheduling_priority

DOUBLE

The initial priority for a query running with this service class.

cache_max_bytes

LONG

The maximum number of bytes in a result set, if it is eligible for cache storage, for a query running with this service class.

cache_max_time

LONG

The maximum amount of time, in seconds, that the system caches rows for a query running with this service class.

max_elapsed_time_for_caching

LONG

The maximum amount of time, in seconds, that a query running with this service class can run and have its result set cached. This value must be higher than the max_elapsed_time value.

max_columns_in_result_set

LONG

The maximum number of columns allowed in the result set of a query running with this service class.

priority_adjustment_factor

DOUBLE

The amount that the system adjusts the query priority in each time interval, as specified by the priority_adjustment_time value, for a query running with this service class.

priority_adjustment_time

LONG

The frequency, in seconds, of each priority adjustment for a query running with this service class.

min_priority

DOUBLE

The minimum value of the adjusted priority for a query running with this service class.

max_priority

DOUBLE

The maximum value of the adjusted priority for a query running with this service class.

statement_text

CHAR

Specifies the comparison string to use for matching statement text to queries. This string takes the format specified by the statement_text_matcher_type field.

statement_text_matcher_type

CHAR

Specifies the type of string comparison to use for matching statement text to queries. This value must be LIKE or REGEX and is required if you specify a statement_text field.

half_parallelism

BOOLEAN

Determines whether the VM uses half of the available cores for each operator in this query rather than the maximum possible parallelism. Setting this value can reduce overhead and latency for queries, but it significantly decreases data throughput. So, updating this value should be rare outside of Ocient Support work.

load_balance_shuffle

BOOLEAN

Determines whether the optimizer includes a load-balancing network operator above I/O for each query. This field can add latency to queries, but it will likely increase data throughput. If unset, the choice is left to the optimizer. So, updating this value should be rare outside of Ocient Support work.

parallelism

INT

Determines the number of parallel cores to use for each operator in the VM. This value must be nonzero. If unset, the choice is left to the VM. So, updating this value should be rare outside of Ocient Support work.

memory_optimal_strategy

BOOLEAN

This field is currently an unimplemented placeholder. This value determines whether the optimizer and VM should attempt to lower the memory requirements of a query regardless of potential execution time penalties. So, updating this value should be rare outside of Ocient Support work.