PageRenderTime 15ms CodeModel.GetById 12ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/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
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;