clickhouseHow to use user-defined function
SELECT test(date, age) FROM tblctrl + ctest(name of the created user-defined function | date, agearguments of the user-defined function (in our case - |
tbltable to select data from | |
Usage example
SELECT test(date, age) FROM tbl LIMIT 5output
┌─concat(toString(age), ', ', toString(toYear(date)))─┐
│ 0, 1970 │
│ 125, 1970 │
│ 0, 1970 │
│ 125, 1970 │
│ 0, 1970 │
└─────────────────────────────────────────────────────┘More of Clickhouse
- Convert array to rows
- Get total database size
- How to execute SQL query from a file
- How to restart Clickhouse server
- List all tables from all database
- Using variables in queries
- Select where date column is between dates
- Select countIf usage example
- Select sumIf query example
- Get table size
See more codes...