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 datetime to unix timestamp
- Convert hex to text
- Select countIf usage example
- Add row number to results
- Create table example
- String concat
- List all tables from all database
- Select rows with certain value in array column
- Insert array of strings in CSV format
- Select where date column is between dates
See more codes...