【已解决】doris-1.2.2升级2.0之后,调用udf函数查询报错。

Viewed 66

执行sql:
select * FROM test1
WHERE
dim.GEO_Intersects('POLYGON (13.820834570312534.0485650412744,113.8340380671875 34.03565041274,13.834838671875 34.0481084909035,1.829845703125 34.046810608490a35,13.828345703123 34.04355650412744))', scene_wkt) = 1
and starttime = str_to_date('2024/03/01','%Y/%m/%d') limit 3;

已知UDF并未做调整,函数内容为空间计算的逻辑判断,更新前后数据未做变更。
另外不止一个UDF函数,试了好几个都是一样的报错,所以无法确定是否有什么bug导致调用异常。

报错内容:
ERROR 1105 (HY000): errCode = 2, detailMessage = (be的ip地址)[CANCELLED][INTERNAL_ERROR]UdfRuntimeException: UDF failed to evaluate
CAUSED BY: ClassCastException: [Z cannot be cast to [Ljava.lang.Object;

    0#  doris::JniUtil::GetJniExceptionMsg(JNIEnv_*, bool, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) at /home/zcp/repo_center/doris_release/doris/be/src/util/jni-util.h:117
    1#  doris::vectorized::JavaFunctionCall::execute_impl(doris::FunctionContext*, doris::vectorized::Block&, 
1 Answers

已解决,udf创建下就正常了。