Skip to content

Other Functions

LENGTH(expr)
returns the length of the value in expr, where <expr> is one of the following:
  • A string: returns the number of utf8 characters in the string (alias for CHAR_LENGTH)
  • A byte-array: returns the number of bytes in the array (alias for OCTET_LENGTH)
  • 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