/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
- DESCRIBE FUNCTION explode;
- DESCRIBE FUNCTION EXTENDED explode;
- EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
- EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;
- SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
- SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3;
- SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;