Information Schema
The StarRocks Information Schema is a database within each StarRocks instance. Information Schema contains several read-only, system-defined views that store extensive metadata information of all objects that the StarRocks instance maintains. The StarRocks Information Schema is based on the SQL-92 ANSI Information Schema, but with the addition of views and functions that are specific to StarRocks.
From v3.2.0, The StarRocks Information Schema supports manage metadata for external catalogs.
View metadata via Information Schemaβ
You can view the metadata information within a StarRocks instance by querying the content of views in Information Schema.
The following example checks metadata information about a table named table1 in StarRocks by querying the view tables.
MySQL > SELECT * FROM information_schema.tables WHERE TABLE_NAME like 'table1'\G
*************************** 1. row ***************************
TABLE_CATALOG: def
TABLE_SCHEMA: test_db
TABLE_NAME: table1
TABLE_TYPE: BASE TABLE
ENGINE: StarRocks
VERSION: NULL
ROW_FORMAT:
TABLE_ROWS: 4
AVG_ROW_LENGTH: 1657
DATA_LENGTH: 6630
MAX_DATA_LENGTH: NULL
INDEX_LENGTH: NULL
DATA_FREE: NULL
AUTO_INCREMENT: NULL
CREATE_TIME: 2023-06-13 11:37:00
UPDATE_TIME: 2023-06-13 11:38:06
CHECK_TIME: NULL
TABLE_COLLATION: utf8_general_ci
CHECKSUM: NULL
CREATE_OPTIONS:
TABLE_COMMENT:
1 row in set (0.01 sec)
Views in Information Schemaβ
The StarRocks Information Schema contains the following metadata views:
ποΈ analyze_status
analyze_status provides information about the status of analyze jobs.
ποΈ applicable_roles
applicable_roles provides information about roles that are applicable to the current user.
ποΈ be_bvars
be_bvars provides statistical information regarding bRPC.
ποΈ be_cloud_native_compactions
be_cloud_native_compactions provides information on compaction transactions running on CNs (or BEs for v3.0) of a shared-data cluster.
ποΈ be_compactions
be_compactions provides statistical information on compaction tasks.
ποΈ be_configs
be_configs provides information about the configuration parameters of each BE node.
ποΈ be_logs
be_logs provides information about the logs of each BE node.
ποΈ be_metrics
be_metrics provides information about the metrics of each BE node.
ποΈ be_tablets
be_tablets provides information about tablets on each BE node.
ποΈ be_threads
be_threads provides information about the threads running on each BE node.
ποΈ be_txns
be_txns provides information about transactions on each BE node.
ποΈ character_sets
character_sets identifies the character sets available.
ποΈ collations
collations contains the available collations.
ποΈ column_privileges
Information schema placeholder view not implemented in StarRocks.
ποΈ column_stats_usage
column_stats_usage provides information about the usage of column statistics.
ποΈ columns
columns contains information about all table columns (or view columns).
ποΈ engines
Information schema placeholder view not implemented in StarRocks.
ποΈ events
Information schema placeholder view not implemented in StarRocks.
ποΈ fe_metrics
fe_metrics provides information about the metrics of each FE node.
ποΈ fe_tablet_schedules
fe_tablet_schedules provides information about tablet scheduling tasks on FE nodes.
ποΈ fe_threads
fe_threads provides information about the threads running on each FE node.
ποΈ global_variables
global_variables provides information about global variables.
ποΈ key_column_usage
Information schema placeholder view not implemented in StarRocks.
ποΈ load_tracking_logs
load_tracking_logs provides error logs of load jobs.
ποΈ loads
loads provides the results of load jobs.
ποΈ materialized_views
materialized_views provides information about all materialized views.
ποΈ partitions
Information schema placeholder view not implemented in StarRocks.
ποΈ partitions_meta
partitions_meta provides information about partitions of tables.
ποΈ pipe_files
pipe_files provides the status of the data files to be loaded via a specified pipe.
ποΈ pipes
pipes provides information about all pipes stored in the current or specified database.
ποΈ recyclebin_catalogs
recyclebin_catalogs provides metadata information of deleted databases, tables, and partitions temporarily stored in the FE recycle bin.
ποΈ referential_constraints
Information schema placeholder view not implemented in StarRocks.
ποΈ routine_load_jobs
routine_load_jobs provides information about routine load jobs.
ποΈ routines
Information schema placeholder view not implemented in StarRocks.
ποΈ schema_privileges
Information schema placeholder view not implemented in StarRocks.
ποΈ schemata
schemata provides information about databases.
ποΈ session_variables
session_variables provides information about session variables.
ποΈ statistics
Information schema placeholder view not implemented in StarRocks.
ποΈ stream_loads
stream_loads provides information about stream load jobs.
ποΈ table_constraints
Information schema placeholder view not implemented in StarRocks.
ποΈ table_privileges
Information schema placeholder view not implemented in StarRocks.
ποΈ tables
tables provides information about tables.
ποΈ tables_config
tables_config provides information about the configuration of tables.
ποΈ task_runs
task_runs provides information about the execution of asynchronous tasks.
ποΈ tasks
tasks provides information about asynchronous tasks.
ποΈ triggers
Information schema placeholder view not implemented in StarRocks.
ποΈ user_privileges
Information schema placeholder view not implemented in StarRocks.
ποΈ verbose_session_variables
verbose_session_variables provides session variable details including default values and whether they have been modified.
ποΈ views
views provides information about all user-defined views.
ποΈ warehouse_metrics
warehouse_metrics provides information about the metrics of each warehouse.
ποΈ warehouse_queries
warehouse_queries provides information about queries running on each warehouse.
