vertica_split_to_rows.sql

; nice formatting of https://www.vertica.com/blog/vertica-quick-tip-splitting-string-rows/

=> SELECT * FROM test;
id |  c2
----+-------
1 | A|B|C
2 | D|E|F
(2 rows)

;;;;;

=> SELECT id, words FROM (
    SELECT id, StringTokenizerDelim(c2, ‘|’) 
        OVER (PARTITION BY id ORDER BY id)
    FROM test)
ORDER BY 1, 2;

id | words
—-+——-
1 | A
1 | B
1 | C
2 | D
2 | E
2 | F
(6 rows)

Thanks for this!

+1