Skip to content

Other Functions

Length

A generic function to calculate the length of values.

(length <expr>)
LENGTH(<expr>)

Where <expr> is one of the following:

  • A string - returns the number of utf8 characters in the string

  • A varbinary - returns the number of bytes in the varbinary

  • A list - returns the number of elements in the list

  • A set - returns the number of elements in the set

  • A struct - returns the number of non-absent fields in the struct