Help Center/ Data Lake Insight/ SQL Syntax Reference (Paris Region)/ Spark SQL Syntax Reference/ Built-in Functions/ String Functions/ lengthb
Updated on 2025-01-22 GMT+08:00
View PDF
Share

lengthb

This function is used to return the length of a specified string in bytes.

Similar function: length. The length function is used to return the length of a string and return a value of the BIGINT type.

Syntax

lengthb(string <str>)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

str

Yes

STRING

Input string

Return Values

The return value is of the STRING type.

  • If the value of str is not of the STRING, BIGINT, DOUBLE, DECIMAL, or DATETIME type, an error is reported.
  • If the value of str is NULL, NULL is returned.

Example Code

The value 5 is returned.

select lengthb('hello');

The value NULL is returned.

select lengthb(null);
Parent topic: String Functions