blob: a4aa6bc8e861ce7e12c95b953feaa8743f642f63 (
plain) (
blame)
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;
|