This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new 644f5f2b61a [bug](function) add signature for precentile function
(#26867) (#26926)
644f5f2b61a is described below
commit 644f5f2b61aedecfdc8d6953964a8c57009eac9b
Author: Dongyang Li <[email protected]>
AuthorDate: Tue Nov 14 16:38:37 2023 +0800
[bug](function) add signature for precentile function (#26867) (#26926)
Co-authored-by: zhangstar333
<[email protected]>
---
.../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 1b5f51ad1b7..b2cb1c9b60f 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]
