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 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...