/tags/release-0.0.0-rc0/hive/external/contrib/src/test/queries/clientpositive/lateral_view_explode2.q

# · text · 7 lines · 4 code · 3 blank · 0 comment · 0 complexity · 4a1eaf8b9e020663881f6b301ecf5c82 MD5 · raw file 

    

  1. add jar ${system:build.dir}/hive-contrib-${system:hive.version}.jar;
    2. 

  2. 

  3. CREATE TEMPORARY FUNCTION explode2 AS 'org.apache.hadoop.hive.contrib.udtf.example.GenericUDTFExplode2';
    4. 

  4. 

  5. SELECT col1, col2 FROM src LATERAL VIEW explode2(array(1,2,3)) myTable AS col1, col2 LIMIT 3;
    6. 

  6. 

  7. DROP TEMPORARY FUNCTION explode2;
    8.