Show Functions


This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See SHOW FUNCTIONS.

SHOW [USER | SYSTEM |ALL ] FUNCTIONS ([LIKE] regex | [db_name.]function_name)

Show functions matching the given regex or function name. If no regex or name is provided, then all functions are shown. IF USER or SYSTEM is declared then these will only show user-defined Spark SQL functions and system-defined Spark SQL functions respectively.


This qualifier is allowed only for compatibility and has no effect.