Flink 如何取消多个数组列的嵌套，同时保留数组的顺序

xpcnnkqh 于 2022-12-09 发布在 Apache

关注(0)|答案(1)|浏览(137)

What is the SQL statement to unnest both columns containing arrays while preserving the array order?
| col1 | col2 |
| ------------ | ------------ |
| [1,2,3,4] | [1,2,3,4] |
Expected Result
| col1 | col2 |
| ------------ | ------------ |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |

apache-flink

来源：https://stackoverflow.com/questions/72611549/how-to-unnest-multiple-array-columns-while-preserving-the-order-of-the-array

1条答案

按热度按时间

oknrviil1#

像这样使用CROSS APPLY STRING_SPLIT函数

select * from (
select value as Col1 from test
CROSS APPLY STRING_SPLIT(replace(replace(Col1,'[',''),']',''),',') 
)a
left join (
select value as Col2 from test
CROSS APPLY STRING_SPLIT(replace(replace(Col2,'[',''),']',''),',') 
)b on a.col1 =b.col2

enter link description here

赞(0）回复(0）举报 2022-12-09

我来回答

Flink 如何取消多个数组列的嵌套，同时保留数组的顺序

1条答案

相关问题

热门标签

最新问答