SHOW FUNCTIONS

    • function_kind

      • USER - Looks up the function(s) among the user defined functions.
      • SYSTEM - Looks up the function(s) among the system defined functions.
      • ALL - Looks up the function(s) among both user and system defined functions.

    • { FROM | IN } database_name

    • regex_pattern

      • Except for * and | character, the pattern works like a regular expression.
      • * alone matches 0 or more characters and | is used to separate multiple different regular expressions, any of which can match.
      • The leading and trailing blanks are trimmed in the input pattern before processing. The pattern match is case-insensitive.
    1. -- List a system function `trim` by searching both user defined and system
    2. -- defined functions.
    3. SHOW FUNCTIONS trim;
    4. +--------+
    5. |function|
    6. +--------+
    7. |    trim|
    8. +--------+
    10. -- List a system function `concat` by searching system defined functions.
    11. SHOW SYSTEM FUNCTIONS concat;
    12. +--------+
    13. +--------+
    14. |  concat|
    15. +--------+
    17. -- List a qualified function `max` from database `salesdb`. 
    19. +--------+
    20. |function|
    21. +--------+
    22. |     max|
    23. +--------+
    25. -- List all functions starting with `t`
    26. SHOW FUNCTIONS LIKE 't*';
    27. +-----------------+
    28. |         function|
    29. +-----------------+
    30. |              tan|
    31. |             tanh|
    32. |        timestamp|
    33. |          tinyint|
    34. |           to_csv|
    35. |          to_date|
    36. |          to_json|
    37. |     to_timestamp|
    38. |to_unix_timestamp|
    39. |        transform|
    40. |   transform_keys|
    42. |        translate|
    43. |             trim|
    44. |            trunc|
    45. |           typeof|
    46. +-----------------+
    48. -- List all functions starting with `yea` or `windo`
    49. SHOW FUNCTIONS LIKE 'yea*|windo*';
    50. +--------+
    51. |function|
    52. +--------+
    53. |  window|
    54. |    year|
    55. +--------+
    57. -- Use normal regex pattern to list function names that has 4 characters
    58. -- with `t` as the starting character.
    59. SHOW FUNCTIONS LIKE 't[a-z][a-z][a-z]';
    60. +--------+
    61. |function|
    62. +--------+
    63. |    tanh|
    64. |    trim|