LEFT (Lakehouse v2)

Returns the leftmost N characters of a string.

Analyze Syntax

func.left(<str>, <len>)

Analyze Examples

func.left('StarRocks', 4)

┌────────┐
│ 'Star'  │
└────────┘

SQL Syntax

LEFT(<str>, <len>)

SQL Examples

SELECT LEFT('StarRocks', 4);

┌──────┐
│ Star  │
└──────┘