lateral_view_explode2.q

/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0


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

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

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

DROP TEMPORARY FUNCTION explode2;