When creating a view definition in Athena which contains the uuid() function, an error is thrown saying that "The function uuid is not registered".
Running the same SQL, including the uuid function, as a standalone query, works perfectly fine.
create or replace view my_db.vw_with_uuid as
select uuid() as my_unique_id
;
I'm using DBeaver as a client (using the Simba Athena jdbc driver), but I'm getting the same error using the Athena Web Query Editor.
Anyone knows how to workaround this little issue? Thank you.