[DRILL-6375] ANY_VALUE aggregate function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Fix Version/s: 1.14.0
• Component/s: Functions - Drill
• Labels: ready-to-commit
• Assignee: Gautam Parai
• Reporter: Gautam Parai
• Reviewer: Aman Sinha
• Created: 02/May/18 00:58
• Updated: 07/Jun/18 23:14
• Resolved: 07/Jun/18 23:14

Description

We had discussions on the Apache Calcite [1] and Apache Drill [2] mailing lists regarding an equivalent for DISTINCT ON. The community seems to prefer the ANY_VALUE. This Jira is a placeholder for implementing the ANY_VALUE aggregate function in Apache Drill. We should also eventually contribute it to Apache Calcite.

[1]https://lists.apache.org/thread.html/f2007a489d3a5741875bcc8a1edd8d5c3715e5114ac45058c3b3a42d@%3Cdev.calcite.apache.org%3E

[2]https://lists.apache.org/thread.html/2517eef7410aed4e88b9515f7e4256335215c1ad39a2676a08d21cb9@%3Cdev.drill.apache.org%3E

Issue Links

• links to: GitHub Pull Request #1256