sql/hive/src/test/resources/ql/src/test/queries/clientpositive/udf_logic_java_boolean.q


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

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;