SIGN (Lakehouse v2)

Returns the sign of a number: -1, 0, or 1.

Analyze Syntax

func.sign(<x>)

Analyze Examples

func.sign(-42)

┌────┐
│ -1  │
└────┘

SQL Syntax

SIGN(<x>)

SQL Examples

SELECT SIGN(-42);

┌────┐
│ -1  │
└────┘