数据湖探索 DLI-split_cursor:示例

时间:2024-11-16 13:21:41

示例

输入一条记录("student1", "student2, student3"),输出两条记录("student1", "student2") 和 ("student1", "student3") 。

create table s1(attr1 string, attr2 string) with (......);
insert into s2 select  attr1, b1 from s1 left join lateral table(split_cursor(attr2, ',')) as T(b1) on true;
support.huaweicloud.com/sqlref-flink-dli/dli_08_0357.html