Querying in ClickHouse CloudThe data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the
clusterAllReplicas function. See here for further details.Description
Contains information about cached DNS records.Columns
hostname(String) — Hostname.ip_address(String) — IP address.ip_family(Enum8(‘IPv4’ = 0, ‘IPv6’ = 1, ‘UNIX_LOCAL’ = 2)) — IP address family.cached_at(DateTime) — Record cached timestamp.
Example
Query