SHOW FUNCTIONS

Description

Syntax

  1. SHOW [FULL] [BUILTIN] FUNCTIONS [IN|FROM db] [LIKE 'function_pattern']

Parameters

full: Indicate to show the details of function builtin: Indicate to show the functions that doris provides db: The name of the database to query function_pattern: The parameter to filter function name

Look at all the custom(builtin) functions under the database. If the user specifies the database, then look at the corresponding database, otherwise directly query the database where the current session is located.

You need SHOW privileges for this database

example

  1. mysql> show full functions in testDb\G
  2. *************************** 1. row ***************************
  3.         Signature: my_add(INT,INT)
  4.       Return Type: INT
  5.     Function Type: Scalar
  6. Intermediate Type: NULL
  7.        Properties: {"symbol":"_ZN9doris_udf6AddUdfEPNS_15FunctionContextERKNS_6IntValES4_","object_file":"http://host:port/libudfsample.so","md5":"cfe7a362d10f3aaf6c49974ee0f1f878"}
  8. *************************** 2. row ***************************
  9.         Signature: my_count(BIGINT)
  10.       Return Type: BIGINT
  11.     Function Type: Aggregate
  12. Intermediate Type: NULL
  13.        Properties: {"object_file":"http://host:port/libudasample.so","finalize_fn":"_ZN9doris_udf13CountFinalizeEPNS_15FunctionContextERKNS_9BigIntValE","init_fn":"_ZN9doris_udf9CountInitEPNS_15FunctionContextEPNS_9BigIntValE","merge_fn":"_ZN9doris_udf10CountMergeEPNS_15FunctionContextERKNS_9BigIntValEPS2_","md5":"37d185f80f95569e2676da3d5b5b9d2f","update_fn":"_ZN9doris_udf11CountUpdateEPNS_15FunctionContextERKNS_6IntValEPNS_9BigIntValE"}
  14. *************************** 3. row ***************************
  15.         Signature: id_masking(BIGINT)
  16.       Return Type: VARCHAR
  17.     Function Type: Alias
  18. Intermediate Type: NULL
  19.        Properties: {"parameter":"id","origin_function":"concat(left(`id`, 3), `****`, right(`id`, 4))"}
  21. 3 rows in set (0.00 sec)
  22. mysql> show builtin functions in testDb like 'year%';
  23. +---------------+
  24. | Function Name |
  25. +---------------+
  26. | year          |
  27. | years_add     |
  28. | years_diff    |
  29. | years_sub     |
  30. +---------------+
  31. 2 rows in set (0.00 sec)

keyword

SHOW,FUNCTIONS