CatalogSystem

System

Catalog that add support for various system tables

• catalogs (List registered catalogs in session)
• functions (List built in functions)
• tables (List temp tables in session)
• caches (List sessions caches)
• cachekeys (List sessions cache keys)

This table also redirects table queries to other registered catalogs (if they implement it). For example:

-- List various system tables for catalog registed with alias 'es'

select *
from sys#es.tables

select *
from sys#es.columns

select *
from sys#es.indices

These table queries can be implemented by catalogs via Catalog#getSystemTableDataSource The system catalog is automatically registered in the session with alias sys