CONCAT (Lakehouse v2)

Concatenates two or more strings.

Analyze Syntax

func.concat(<str1>, <str2>[, ...])

Analyze Examples

func.concat('Star', 'Rocks')

┌─────────────┐
│ 'StarRocks'  │
└─────────────┘

SQL Syntax

CONCAT(<str1>, <str2>[, ...])

SQL Examples

SELECT CONCAT('Star', 'Rocks');

┌───────────┐
│ StarRocks  │
└───────────┘