/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

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