[
https://issues.apache.org/jira/browse/HIVE-24710?focusedWorklogId=554001&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-554001
]
ASF GitHub Bot logged work on HIVE-24710:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 18/Feb/21 00:49
Start Date: 18/Feb/21 00:49
Worklog Time Spent: 10m
Work Description: rbalamohan merged pull request #1940:
URL: https://github.com/apache/hive/pull/1940
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 554001)
Time Spent: 0.5h (was: 20m)
> Optimise PTF iteration for count(*) to reduce CPU and IO cost
> -------------------------------------------------------------
>
> Key: HIVE-24710
> URL: https://issues.apache.org/jira/browse/HIVE-24710
> Project: Hive
> Issue Type: Improvement
> Components: HiveServer2
> Reporter: Rajesh Balamohan
> Priority: Major
> Labels: performance, pull-request-available
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> E.g query
> {noformat}
> select x, y, count(*) over (partition by x order by y range between 86400
> PRECEDING and CURRENT ROW) r0 from foo
> {noformat}
> 1. In such cases, there is no need to iterate over the rowcontainers often
> (internally it does O(n^2) operations taking forever when window frame is
> really large). This can be optimised to reduce CPU burn and IO.
> 2. BasePartitionEvaluator::calcFunctionValue need not materialize ROW when
> parameters are empty. This codepath can also be optimised.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
