[
https://issues.apache.org/jira/browse/HIVE-16541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16005857#comment-16005857
]
Gopal V commented on HIVE-16541:
--------------------------------
[~ashutoshc]: can you review this patch? - this is a performance fix for large
{{create temporary table result24 as select row_number() over() as r_pkey, *
from (<query>);}}
result tables (and different queries fetch off r_pkey BETWEEN to incrementally
update a screen to simulate OFFSET + LIMIT queries in mysql).
> PTF: Avoid shuffling constant keys for empty OVER()
> ---------------------------------------------------
>
> Key: HIVE-16541
> URL: https://issues.apache.org/jira/browse/HIVE-16541
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Affects Versions: 3.0.0
> Reporter: Gopal V
> Assignee: Gopal V
> Attachments: HIVE-16541.1.patch, HIVE-16541.2.patch
>
>
> Generating surrogate keys with
> {code}
> select row_number() over() as p_key, * from table;
> {code}
> uses a sorted edge with "0 ASC NULLS FIRST" as the sort order.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
