用逗号将一个字符串分割成几列

用逗号将一个字符串分割成几列

在我看来，您只需要使用

split_part

function创建列，就像这样：

SELECt    split_part(Block, ',', 1) AS Block1,    split_part(Block, ',', 2) AS Block2,    split_part(Block, ',', 3) AS Block3,    split_part(Block, ',', 4) AS Block4,    split_part(Block, ',', 5) AS Block5,    split_part(Block, ',', 6) AS Block6,    split_part(Block, ',', 7) AS Block7,    split_part(Block, ',', 8) AS Block8,    split_part(Block, ',', 9) AS Block9FROM    your_table