使用explode函数就行
mysql> select e1 from (select 1 k1) as t lateral view explode(['1','2','3']) tmp1 as e1; +------+ | e1 | +------+ | 1 | | 2 | | 3 | +------+ 3 rows in set (0.04 sec)
