Pentaho Data Integration: 'Execute SQL statement' to create trigger
You can omit the DELIMITER commands and enable the option "Send SQL as single statement":

CREATE FUNCTION Tes()
BEGIN
  SELECT * FROM actors;
END