/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/udf_explode.q
text | 9 lines | 7 code | 2 blank | 0 comment | 0 complexity | 538e0e49fdf0d482f5dece176c178a46 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- 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;