/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/udtf_explode.q
text | 9 lines | 7 code | 2 blank | 0 comment | 0 complexity | 538e0e49fdf0d482f5dece176c178a46 MD5 | raw file
1DESCRIBE FUNCTION explode; 2DESCRIBE FUNCTION EXTENDED explode; 3 4EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3; 5EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol; 6 7SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3; 8SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3; 9SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;