our current vertica version: Vertica Analytic Database v9.2.1-28
I tried to use v_txtindex.StringTokenizerDelim function to parse list to row.
--this works
select v_txtindex.StringTokenizerDelim('1,2,3,4,5,19 ',',') over () from dual
--this not works
select list_value,v_txtindex.StringTokenizerDelim(list_value,',') over ()
from tmp_list_val
where id = '12345';
And got error: ERROR: Function v_txtindex.StringTokenizerDelim(long varchar, unknown) does not exist, or permission is denied for v_txtindex.StringTokenizerDelim(long varchar, unknown)
please advice
thanks
David