将多列合成arrayVector

如图,有没有什么快捷的办法把a1~a5合成一行array vector

attachments-2023-05-Bre38zp8646d68a8ce4fd.png

请先 登录 后评论

1 个回答

peter

使用fixedLengthArrayVector

t = table(rand(10,5) as a1, rand(10,5) as a2, rand(10,5) as a3, rand(10,5) as a4, rand(10,5) as a5)
select fixedLengthArrayVector(a1,a2,a3,a4,a5) as a from t
请先 登录 后评论