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