[
https://issues.apache.org/jira/browse/ASTERIXDB-3369?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845306#comment-17845306
]
ASF subversion and git services commented on ASTERIXDB-3369:
------------------------------------------------------------
Commit 19cf53341ea35ed3731cacb51208d22c0528b385 in asterixdb's branch
refs/heads/master from Ali Alsuliman
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=19cf53341e ]
[ASTERIXDB-3369][FUN] Implement SQL median()
- user model changes: no
- storage format changes: no
- interface changes: yes
Details:
Implement SQL median() function. Each local partition will generate a sorted
run file. Those run files can be used to determine the median.
- add ability to generate unique ids at the joblet level in
IHyracksJobletContext.
- median() will use the unique ids for file ids when generating local run files.
- references to the generated local run files are kept in JobFileState at
Joblet level.
- use NetworkManager to receive file reading requests.
- make PartitionManager keep track of file requests.
- currently, median() will use the same sort memory configured for the cluster.
- pass the sort memory to the median() via the type inferer.
- account for the memory required by median() when calculating the
required capacity of a query.
- median() used as a WINDOW function does not support ORDER BY and FRAME.
- refactor MaterializedPartition to PartitionFileReader.
Change-Id: Id8d03f42d54b5ed4cf316c31f0b4cce9dd7c1dc0
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18210
Tested-by: Jenkins <[email protected]>
Reviewed-by: Murtadha Hubail <[email protected]>
> Implement SQL Median() function
> -------------------------------
>
> Key: ASTERIXDB-3369
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3369
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: FUN - Functions
> Reporter: Ali Alsuliman
> Assignee: Ali Alsuliman
> Priority: Major
> Labels: triaged
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
