--! qt:dataset:src
set hive.fetch.task.conversion=more;

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;