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

  2. DESCRIBE FUNCTION EXTENDED explode;
    3. 

  3. 

  4. EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
    5. 

  5. 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;
    6. 

  6. 

  7. SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3;
    8. 

  8. SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3;
    9. 

  9. SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol;
    10.