impala行转列问题

由于impala不能使用 LATERAL VIEW EXPLODE
需要行转列时，可采用加辅助列的方式：

DROP TABLE IF EXISTS ZHYW.T0;
CREATE TABLE IF NOT EXISTS ZHYW.T0 AS 
SELECT '1' AS NM,'A,B,C' AS ID 
UNION ALL
SELECT '2' AS NM,'A,B,C,D' AS ID 
;

DROP