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
This view does not apply to the available features 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
This view does not apply to the available features in StarRocks.
ποΈ events
This view does not apply to the available features 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
This view does not apply to the available features 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
This view does not apply to the available features 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
This view does not apply to the available features in StarRocks.
ποΈ routine_load_jobs
`routine_load_jobs` provides information about routine load jobs.
ποΈ routines
This view does not apply to the available features in StarRocks.
ποΈ schema_privileges
This view does not apply to the available features in StarRocks.
ποΈ schemata
`schemata` provides information about databases.
ποΈ session_variables
`session_variables` provides information about session variables.
ποΈ statistics
This view does not apply to the available features in StarRocks.
ποΈ stream_loads
`stream_loads` provides information about stream load jobs.
ποΈ table_constraints
This view does not apply to the available features in StarRocks.
ποΈ table_privileges
This view does not apply to the available features 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
This view does not apply to the available features in StarRocks.
ποΈ user_privileges
This view does not apply to the available features in StarRocks.
ποΈ verbose_session_variables
`verbose_session_variables` provides detailed information about session variables, including their default values and whether they have been changed from the default.
ποΈ 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.
