aboutsummaryrefslogtreecommitdiff
path: root/sql/hive/src/test/resources/ql/src/test/queries/clientpositive/udf_compare_java_string.q
blob: 6c12f81304e46705faa1fa45ca93bc529ce4b4fb (plain) (blame)
1
2
3
4
5
6
7
8
9
10
EXPLAIN
CREATE TEMPORARY FUNCTION test_udf_get_java_string AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaString';

CREATE TEMPORARY FUNCTION test_udf_get_java_string AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaString';

select * from src where value = test_udf_get_java_string("val_66"); 
select * from (select * from src where value = 'val_66' or value = 'val_8') t where value <> test_udf_get_java_string("val_8"); 


DROP TEMPORARY FUNCTION test_udf_get_java_boolean;