common-sql.md

Common SQL commands in Clickhouse

Version

SELECT version()

Tables list

select * from system.tables

TimeZones

SELECT * FROM system.time_zones;

Top executed queries

SELECT
    COUNT(*) as query_count,
    query
FROM system.query_log
GROUP BY query
ORDER BY query_count DESC ;

Find out data types

DESCRIBE ...
# DESCRIBE s3('<url>')