SQL routine not found in Glue catalog

I've got a Hive catalog that uses Glue as the metastore:

connector.name=hive
hive.metastore=glue
hive.metastore.glue.region=eu-central-1
hive.s3.path-style-access=true
hive.allow-drop-table=true
hive.s3.endpoint=s3.eu-central-1.amazonaws.com
hive.non-managed-table-writes-enabled=true
hive.storage-format=ORC
hive.cache.enabled=true
hive.cache.location=/opt/hive-cache
hive.cache.start-server-on-coordinator=true
hive.allow-add-column=true

I've also set it as the default catalog for routines:

sql.default-function-catalog=hive
sql.default-function-schema=default
sql.path=hive.default

I can create a function in this catalog, but then I can't use it:

-- format_topn makes it easier to print results for approx_most_frequent in descending order
CREATE OR REPLACE FUNCTION format_topn(input map<varchar, bigint>)
    RETURNS VARCHAR
    NOT DETERMINISTIC
    RETURNS NULL ON NULL INPUT
    BEGIN
    DECLARE freq_separator VARCHAR DEFAULT '=';
    DECLARE entry_separator VARCHAR DEFAULT ', ';
    RETURN array_join(transform(
            reverse(array_sort(transform(
                transform(
                    map_entries(input),
                    r -> cast(r AS row(key varchar, value bigint))
                ),
                r -> cast(row(r.value, r.key) AS row(value bigint, key varchar)))
            )),
            r -> r.key || freq_separator || cast(r.value as varchar)),
        entry_separator);
    END;

WITH
data AS (
    SELECT lpad('', 3, chr(65+(s.num / 3))) AS value
    FROM table(sequence(start=>1, stop=>10)) AS s(num)
)
, aggregated AS (
    SELECT
        array_agg(data.value ORDER BY data.value) AS all_values
      , approx_most_frequent(3, data.value, 1000) AS top3
    FROM data
)
SELECT
    a.all_values
  , a.top3
  , format_topn(a.top3) AS top3_formatted
FROM aggregated a;

/* expected output:
CREATE FUNCTION
                     all_values                     |         top3          |        _col2
----------------------------------------------------+-----------------------+---------------------
 [AAA, AAA, BBB, BBB, BBB, CCC, CCC, CCC, DDD, DDD] | {AAA=2, CCC=3, BBB=3} | CCC=3, BBB=3, AAA=2
(1 row)
*/

I'm getting the following error:

CREATE FUNCTION
Query 20231204_121421_00001_db4cq failed: line 15:5: Function 'format_topn' not registered

I can confirm the function is present in Glue (redacted some values):

% aws glue get-user-defined-functions --region eu-central-1 --pattern '.*'      
{
    "UserDefinedFunctions": [
        {
            "FunctionName": "trino__format_topn__zzz",
            "DatabaseName": "default",
            "ClassName": "TrinoFunction",
            "OwnerName": "trino-client",
            "OwnerType": "USER",
            "ResourceUris": [
                {
                    "ResourceType": "FILE",
                    "Uri": "xxx"
                }
            ],
            "CatalogId": "yyy"
        }
    ]
}

trinodb / trino

SQL routine not found in Glue catalog #20012