Difficulty creating equivalent of regexp_split_to_array function in Dremio

[lenoyjacob]

@Maziha Try returning ARRAY<VARCHAR> instead:

CREATE OR REPLACE FUNCTION pg_regexp_split_to_array(str VARCHAR, match_str VARCHAR) RETURNS ARRAY<VARCHAR> RETURN SELECT REGEXP_SPLIT(str, match_str, 'ALL', 1000000000);