Gabriel39 commented on PR #8678: URL: https://github.com/apache/incubator-doris/pull/8678#issuecomment-1094202386
I tested performance on SSB. Since Vectorized engine doesn't support native UDF, I ran Java UDF and native UDF on vectorized engine and row-based engine separately. And a simple `AddOne` UDF for non-null int type is used for both Java UDF and native UDF. I got results below, `set enable_vectorized_engine=true; select java_udf_add_one(c_custkey) from customer; 3000000 rows in set (49.02 sec) set enable_vectorized_engine=false; select native_udf_add_one(c_custkey) from customer; 3000000 rows in set (49.77 sec)` which means there is no obvious performance gap between Java UDF and native UDF. In the future, we should consider to provide a Doris Java UDF interface in order to support more complex types, such as HLL, Date, etc. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
