Skip to content
Trino 475 Documentation logo
Trino 475 Documentation User-defined functions
Type to start searching
    Trino
    • 11k Stars
    • 3.2k Forks
    Trino
    • 11k Stars
    • 3.2k Forks
    • Overview
    • Installation
    • Clients
    • Security
    • Administration
    • Query optimizer
    • Connectors
    • Object storage
    • Functions and operators
    • User-defined functions
      • Introduction to UDFs
      • FUNCTION
      • SQL user-defined functions
      • Python user-defined functions
    • SQL language
    • SQL statement syntax
    • Developer guide
    • Glossary
    • Appendix
    • Release notes

    User-defined functions#

    A user-defined function (UDF) is a custom function authored by a user of Trino in a client application. UDFs are scalar functions that return a single output value, similar to built-in functions.

    More details are available in the following sections:

    • Introduction to UDFs
    • FUNCTION
    • SQL user-defined functions
    • Python user-defined functions
    Previous Window functions
    Next Introduction to UDFs