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 array to rows
- How to execute SQL query from a file
- Get total database size
- How to restart Clickhouse server
- List all tables from all database
- Select where date column is between dates
- Using variables in queries
- Select sumIf query example
- Select countIf usage example
- Get table size
See more codes...