Skip to content

Add support for distinct aggregation #100

@dai-chen

Description

@dai-chen

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
Add support for the following aggregations. Note that COUNT(DISTINCT) is highest priority and others are optional. MySQL reference: https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html#function_count

  1. COUNT(DISTINCT expr)
  2. AVG(DISTINCT expr)
  3. SUM(DISTINCT expr)
  4. MIN(DISTINCT expr)
  5. MAX(DISTINCT expr)

PPL may also needs to support count distinct. Reference: https://docs.splunk.com/Documentation/SCS/current/SearchReference/Aggregatefunctions#distinct_count.28.26lt.3Bvalue.26gt.3B.29_or_dc.28.26lt.3Bvalue.26gt.3B.29

Describe alternatives you've considered
N/A

Metadata

Metadata

Assignees

Labels

PPLPiped processing languageSQLenhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions