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

Hi

  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

---

[hidden email]

[Yik San Chan]

Hi,

Maybe try row-based flatMap operation in table api. It is available on flink
1.13.x

https://ci.apache.org/projects/flink/flink-docs-master/docs/dev/table/tableapi/#flatmap

Best,
Yik San



--
Sent from: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/