Clickhouse系统表简介

-- 聚合函数组合器
select * from `system`.aggregate_function_combinators;
-- 异步度量
select * from `system`.asynchronous_metrics;
-- 构建选项
select * from `system`.build_options;
-- 集群信息
select * from `system`.clusters;
-- 编码类型
select * from `system`.collations;
-- 字段属性
select * from `system`.columns;
-- 贡献者
select * from `system`.contributors;
-- 现有角色
select * from `system`.current_roles;
-- 数据类型系列
select * from `system`.data_type_families;
-- 数据库
select * from `system`.databases;
-- 独立的分区
select * from `system`.detached_parts;
-- 字典
select * from `system`.dictionaries;
-- 数据库磁盘目录
select * from `system`.disks;
-- 分发队列
select * from `system`.distribution_queue;
-- 启用角色额
select * from `system`.enabled_roles;
-- 事件描述
select * from `system`.events;
-- 格式化类型
select * from `system`.formats;
-- 内置函数
select * from `system`.functions;
-- TODO
select * from `system`.grants;
-- 保留图形
select * from `system`.graphite_retentions;
-- 许可证
select * from `system`.licenses;
-- 集群宏配置
select * from `system`.macros;
-- 合并设置
select * from `system`.merge_tree_settings;
-- 合并
select * from `system`.merges;
-- 度量
select * from `system`.metrics;
-- 模型
select * from `system`.models;
-- TODO 
select * from `system`.mutations;
select * from `system`.numbers;
select * from `system`.numbers_mt;
-- dummy
select * from `system`.one;
-- 分区
select * from `system`.parts;
-- 分区字段
select * from `system`.parts_columns;
-- 语法定义
select * from `system`.privileges;
-- 进程
select * from `system`.processes;
-- 查询日志
select * from `system`.query_log;
-- 查询线程日志
select * from `system`.query_thread_log;
-- TODO 
select * from `system`.quota_limits;
select * from `system`.quota_usage;
select * from `system`.quotas;
select * from `system`.quotas_usage;
-- 副本
select * from `system`.replicas;
-- 副本队列
select * from `system`.replication_queue;
-- TODO
select * from `system`.role_grants;
select * from `system`.roles;
select * from `system`.row_policies;
-- 配置项
select * from `system`.settings;
-- TODO
select * from `system`.settings_profile_elements;
select * from `system`.settings_profiles;
-- 堆栈跟踪
select * from `system`.stack_trace;
-- 存储策略
select * from `system`.storage_policies;
-- 表引擎
select * from `system`.table_engines;
-- 表函数
select * from `system`.table_functions;
-- 表信息
select * from `system`.tables;
-- 跟踪日志
select * from `system`.trace_log;
-- TODO
select * from `system`.users;
-- zeros
select * from `system`.zeros;
-- zeros
select * from `system`.zeros_mt;
-- TODO
select * from `system`.zookeeper;