可以用矩阵的转置transpose

 tb=table(`str+string(1..10) as name,rand(1.,10) as col1,rand(1.,10) as col2,rand(1.,10) as col3)
m=transpose(matrix(exec col1,col2,col3 from tb)).rename!(tb.name)

也可以通过unpivot和pivot by实现

tb=table(`str+string(1..10) as name,rand(1.,10) as col1,rand(1.,10) as col2,rand(1.,10) as col3)
//tb=tb.unpivot(`name, `col1`col2`col3)
select value from tb.unpivot(`name, `col1`col2`col3)  pivot by valueType as value,name