how to split a column value into multiple rows in flink sql?

Classic

List

2 messages Options

May 07, 2021; 6:28pm

8 posts

For example , a table like this:

A B C

------------------

a1 b1 c1,c2,c3

-------------------

how to split c1,c2,c3 into multiple rows like this in flink sql function:

A  B   C
--------
a1  b1  c1
a1  b1  c2
a1  b1  c3

Thank you

May 10, 2021; 2:24am

Re: how to split a column value into multiple rows in flink sql?

97 posts