clickhouseConvert array to string
SELECT arrayStringConcat(['I', 'am', 'string'], ' ')ctrl + carrayStringConcatwill join all array elements into string using specified separator | ['I', 'am', 'string']sample array to convert to string |
' 'separator to user to join array elements | |
Usage example
SELECT arrayStringConcat(['I', 'am', 'string'], ' ')output
┌─arrayStringConcat(['I', 'am', 'string'], ' ')─┐
│ I am string │
└───────────────────────────────────────────────┘Related
More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Select rows with certain value in array column
- Create table example
- Using variables in queries
- Add row number to results
- List all tables from all database
- Select where date column is between dates
- Create table with UUID column
- String concat
See more codes...