| --! qt:dataset:src |
| EXPLAIN |
| CREATE TEMPORARY FUNCTION test_max AS 'org.apache.hadoop.hive.ql.udf.UDAFTestMax'; |
| |
| CREATE TEMPORARY FUNCTION test_max AS 'org.apache.hadoop.hive.ql.udf.UDAFTestMax'; |
| |
| CREATE TABLE dest1_n34(col INT); |
| |
| FROM src INSERT OVERWRITE TABLE dest1_n34 SELECT test_max(length(src.value)); |
| |
| SELECT dest1_n34.* FROM dest1_n34; |
| |
| -- cover all the other value types: |
| SELECT test_max(CAST(length(src.value) AS SMALLINT)) FROM src; |
| SELECT test_max(CAST(length(src.value) AS BIGINT)) FROM src; |
| SELECT test_max(CAST(length(src.value) AS DOUBLE)) FROM src; |
| SELECT test_max(CAST(length(src.value) AS FLOAT)) FROM src; |
| SELECT test_max(substr(src.value,5)) FROM src; |
| |
| DROP TEMPORARY FUNCTION test_max; |