--! qt:dataset:src | |
SELECT explode(col) AS myCol FROM | |
(select * from (SELECT array(1,2,3) AS col FROM src LIMIT 1)ea | |
UNION ALL | |
select * from (SELECT NULLIF(array(1,2,3),array(1,2,3)) AS col FROM src LIMIT 1)eb) a; | |
SELECT explode(col) AS (myCol1,myCol2) FROM | |
(select * from (SELECT map(1,'one',2,'two',3,'three') AS col FROM src LIMIT 1)ea | |
UNION ALL | |
select * from (SELECT NULLIF(map(1,'one',2,'two',3,'three'),map(1,'one',2,'two',3,'three')) AS col FROM src LIMIT 1)eb ) a; |