[jira] [Comment Edited] (HIVE-24710) Optimise PTF iteration for count(*) to reduce CPU and IO cost

["Rajesh Balamohan (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-24710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17290564#comment-17290564 ] 

Rajesh Balamohan edited comment on HIVE-24710 at 2/25/21, 12:15 AM:
--------------------------------------------------------------------

[~kgyrtkirk]: That is strange. What is the error/warning in eclipse? I haven't seen intellij warnings/errors. Are you referring to classes like SumPartitionEvaluator trying to access Range? If so, note that these classes extend BasePartitionEvaluator.


was (Author: rajesh.balamohan):
[~kgyrtkirk]: That is strange. What is the error/warning in eclipse? Are you referring to classes like SumPartitionEvaluator trying to access Range? If so, note that these classes extend BasePartitionEvaluator.

> 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
>            Assignee: Rajesh Balamohan
>            Priority: Major
>              Labels: performance, pull-request-available
>             Fix For: 4.0.0
>
>          Time Spent: 40m
>  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)