| --! qt:dataset:src |
| dfs -cp ${system:hive.root}/contrib/target/hive-contrib-${system:hive.version}.jar ${system:test.tmp.dir}/udfexampleadd-1.0.jar; |
| |
| ADD JAR ivy://:udfexampleadd:1.0; |
| |
| CREATE TEMPORARY FUNCTION example_add AS 'org.apache.hadoop.hive.contrib.udf.example.UDFExampleAdd'; |
| |
| EXPLAIN |
| SELECT example_add(1, 2), |
| example_add(1, 2, 3), |
| example_add(1, 2, 3, 4), |
| example_add(1.1, 2.2), |
| example_add(1.1, 2.2, 3.3), |
| example_add(1.1, 2.2, 3.3, 4.4), |
| example_add(1, 2, 3, 4.4) |
| FROM src LIMIT 1; |
| |
| SELECT example_add(1, 2), |
| example_add(1, 2, 3), |
| example_add(1, 2, 3, 4), |
| example_add(1.1, 2.2), |
| example_add(1.1, 2.2, 3.3), |
| example_add(1.1, 2.2, 3.3, 4.4), |
| example_add(1, 2, 3, 4.4) |
| FROM src LIMIT 1; |
| |
| DROP TEMPORARY FUNCTION example_add; |
| |
| DELETE JAR ivy://:udfexampleadd:1.0; |
| |
| dfs -rm ${system:test.tmp.dir}/udfexampleadd-1.0.jar; |