clickhouseHow to create user-defined function
CREATE FUNCTION test AS (date, age) -> CONCAT(toString(age), ', ', toString(toYear(date)))ctrl + cCREATE FUNCTIONcreates specified function | testname of the function to create (so it can later be used) |
(date, age)arguments list of the function | ->implementation expression goes after this symbol |
CONCAT(toString(age), ', ', toString(toYear(date)))example of extracting a year from | |
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...