clickhouseHow to split a string
SELECT splitByString(' ', 'Hello all of you')ctrl + csplitByStringwill split given string (second argument) by a specified substring (first argument) | ' 'string to split by (space) |
'Hello all of you'sample string to split | |
Usage example
SELECT splitByString(' ', 'Hello all of you')output
┌─splitByString(' ', 'Hello all of you')─┐
│ ['Hello','all','of','you'] │
└────────────────────────────────────────┘More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Create table example
- Add row number to results
- Select rows with certain value in array column
- Create table with UUID column
- Select where date column is between dates
- Insert array of strings in CSV format
- List all tables from all database
- String concat
See more codes...