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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
