This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push: new b0c92d408b5 [bug](function) add signature for precentile function (#26867) b0c92d408b5 is described below commit b0c92d408b557065f21974ada5848112582da239 Author: zhangstar333 <87313068+zhangstar...@users.noreply.github.com> AuthorDate: Mon Nov 13 15:43:10 2023 +0800 [bug](function) add signature for precentile function (#26867) --- .../src/main/java/org/apache/doris/catalog/FunctionSet.java | 9 +++++++++ .../suites/mv_p0/test_user_activity/test_user_activity.groovy | 5 +++-- 2 files changed, 12 insertions(+), 2 deletions(-) diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/FunctionSet.java b/fe/fe-core/src/main/java/org/apache/doris/catalog/FunctionSet.java index f22a6eeed99..70e974c40cd 100644 --- a/fe/fe-core/src/main/java/org/apache/doris/catalog/FunctionSet.java +++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/FunctionSet.java @@ -1321,6 +1321,15 @@ public class FunctionSet<T> { true, false, true, true)); //vec percentile and percentile_approx + addBuiltin(AggregateFunction.createBuiltin("percentile", + Lists.newArrayList(Type.BIGINT, Type.DOUBLE), Type.DOUBLE, Type.VARCHAR, + "", + "", + "", + "", + "", + false, true, false, true)); + addBuiltin(AggregateFunction.createBuiltin("percentile_approx", Lists.<Type>newArrayList(Type.DOUBLE, Type.DOUBLE), Type.DOUBLE, Type.VARCHAR, "", diff --git a/regression-test/suites/mv_p0/test_user_activity/test_user_activity.groovy b/regression-test/suites/mv_p0/test_user_activity/test_user_activity.groovy index 2fd50485e19..8a100b9bfb9 100644 --- a/regression-test/suites/mv_p0/test_user_activity/test_user_activity.groovy +++ b/regression-test/suites/mv_p0/test_user_activity/test_user_activity.groovy @@ -18,8 +18,8 @@ import org.codehaus.groovy.runtime.IOGroovyMethods suite ("test_user_activity") { - - sql """ DROP TABLE IF EXISTS d_table; """ + sql """set enable_nereids_planner=true""" + sql """ DROP TABLE IF EXISTS u_axx; """ sql """ CREATE TABLE u_axx ( @@ -38,6 +38,7 @@ suite ("test_user_activity") { qt_select_base " select n_dx, percentile_approx(n_duration, 0.5) as p50, percentile_approx(n_duration, 0.90) as p90 FROM u_axx GROUP BY n_dx; " + sql """ drop materialized view IF EXISTS session_distribution_2 on u_axx;""" createMV ("create materialized view session_distribution_2 as select n_dx, percentile_approx(n_duration, 0.5) as p50, percentile_approx(n_duration, 0.90) as p90 FROM u_axx GROUP BY n_dx;") sql """INSERT INTO u_axx VALUES (2, "2023-01-02", 600);""" --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org