You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (Jira)" <ji...@apache.org> on 2020/07/07 15:29:00 UTC

[jira] [Commented] (HIVE-23665) Rewrite last_value to first_value to enable streaming results

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

Jesus Camacho Rodriguez commented on HIVE-23665:
------------------------------------------------

+1

> Rewrite last_value to first_value to enable streaming results
> -------------------------------------------------------------
>
>                 Key: HIVE-23665
>                 URL: https://issues.apache.org/jira/browse/HIVE-23665
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Ramesh Kumar Thangarajan
>            Assignee: Ramesh Kumar Thangarajan
>            Priority: Major
>              Labels: pull-request-available
>         Attachments: HIVE-23665.1.patch, HIVE-23665.2.patch, HIVE-23665.3.patch
>
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> Rewrite last_value to first_value to enable streaming results
> last_value cannot be streamed because the intermediate results need to be buffered to determine the window result till we get the last row in the window. But if we can rewrite to first_value we can stream the results, although the order of results will not be guaranteed (also not important)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)