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

Posted by 1095193290@qq.com on
URL: http://deprecated-apache-flink-user-mailing-list-archive.369.s1.nabble.com/how-to-split-a-column-value-into-multiple-rows-in-flink-sql-tp43564.html

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