[Feature] filter cluase or filter syntax support - Githubissues

apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.

https://doris.apache.org

Apache License 2.0

12.74k stars 3.28k forks source link

[Feature] filter cluase or filter syntax support #21629

Open vkingnew opened 1 year ago

vkingnew commented 1 year ago

Search before asking

[X] I had searched in the issues and found no similar issues.

Description

SQL:2003 introduced the filter clause as part of the optional feature “Advanced OLAP operations” (T612). pg had impelements.

refer to: https://modern-sql.com/feature/filter refer postgresql: https://www.postgresql.org/docs/current/sql-expressions.html#SYNTAX-AGGREGATES

refer trino: https://trino.io/docs/current/functions/aggregate.html#

Use case

simple the SQL statement

Related issues

No response

Are you willing to submit PR?

[ ] Yes I am willing to submit a PR!

Code of Conduct

[X] I agree to follow this project's Code of Conduct

vkingnew commented 1 year ago

refer clickhouse： https://clickhouse.com/docs/knowledgebase/filtered-aggregates