SHOW FUNCTIONS#

Synopsis#

SHOW FUNCTIONS [ FROM schema ] [ LIKE pattern ]

Description#

List functions in schema or all functions in the current session path. For Starburst Galaxy, the only supported schema name is functions. This supported functions are User-defined functions.

For each function returned, the following information is displayed:

  • Function name

  • Return type

  • Argument types

  • Function type

  • Deterministic

  • Description

Specify a pattern in the optional LIKE clause to filter the results to the desired subset.

Examples#

List all UDFs and plugin functions in the functions schema of the galaxy catalog:

SHOW FUNCTIONS FROM galaxy.functions;

List all functions with a name beginning with array:

SHOW FUNCTIONS LIKE 'array%';

List all functions with a name beginning with cf:

SHOW FUNCTIONS LIKE 'cf%';

Example output:

     Function      | Return Type | Argument Types | Function Type | Deterministic |               Description
 ------------------+-------------+----------------+---------------+---------------+-----------------------------------------
 cf_getgroups      | varchar     |                | scalar        | true          | Returns the current session's groups
 cf_getprincipal   | varchar     |                | scalar        | true          | Returns the current session's principal
 cf_getuser        | varchar     |                | scalar        | true          | Returns the current session's user

See also#