SELECT explode(array(1,2,3)) as myCol FROM src GROUP BY key;