clickhouseList all users
Usage example
SHOW USERS;
output
Query id: 266335c8-5b18-4fe1-9c2a-128ab3968b31
┌─name────┐
│ default │
│ user1 │
└─────────┘
2 rows in set. Elapsed: 0.001 sec. More of Clickhouse
- Create AggregatingMergeTree materialized view
- Using anyLast() with grouped data
- Increase number of concurrent queries
- How to format date/time
- Select rows with any of specified values in array column
- Get total database size
- Get year and month from date
- Get table size
- Disable logs
- Using multiIf in query
See more codes...