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

EXPLAIN
CREATE TEMPORARY FUNCTION test_udf_get_java_boolean AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaBoolean';

CREATE TEMPORARY FUNCTION test_udf_get_java_boolean AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaBoolean';

select 1 from src where test_udf_get_java_boolean("false") and True limit 1; 
select 1 from src where test_udf_get_java_boolean("true") and True limit 1; 
select 1 from src where True and test_udf_get_java_boolean("false") limit 1; 
select 1 from src where False and test_udf_get_java_boolean("false") limit 1; 
select 1 from src where test_udf_get_java_boolean("true") and test_udf_get_java_boolean("true") limit 1; 
select 1 from src where test_udf_get_java_boolean("true") and test_udf_get_java_boolean("false") limit 1;
select 1 from src where test_udf_get_java_boolean("false") and test_udf_get_java_boolean("true") limit 1; 
select 1 from src where test_udf_get_java_boolean("false") and test_udf_get_java_boolean("false") limit 1; 

select 1 from src where test_udf_get_java_boolean("false") or True limit 1; 
select 1 from src where test_udf_get_java_boolean("true") or True limit 1; 
select 1 from src where True or test_udf_get_java_boolean("false") limit 1; 
select 1 from src where False or test_udf_get_java_boolean("false") limit 1; 
select 1 from src where test_udf_get_java_boolean("true") or test_udf_get_java_boolean("true") limit 1; 
select 1 from src where test_udf_get_java_boolean("true") or test_udf_get_java_boolean("false") limit 1;
select 1 from src where test_udf_get_java_boolean("false") or test_udf_get_java_boolean("true") limit 1; 
select 1 from src where test_udf_get_java_boolean("false") or test_udf_get_java_boolean("false") limit 1; 

select 1 from src where not(test_udf_get_java_boolean("false")) limit 1; 
select 1 from src where not(test_udf_get_java_boolean("true")) limit 1; 


DROP TEMPORARY FUNCTION test_udf_get_java_boolean;