[
https://issues.apache.org/jira/browse/HIVE-4197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13608243#comment-13608243
]
Alan Gates commented on HIVE-4197:
----------------------------------
bq. Stable sort issue seems to be an important one ...
Yeah, I hadn't thought about the point that even in ORDER BY our sort needs to
be stable in order to give consistent results. It sucks that we have to
introduce a sort even in queries without an ORDER BY, but oh well. I agree
that FileName and FileOffset are a good proxy, as that will maintain stability
in the sort.
> Bring windowing support inline with SQL Standard
> ------------------------------------------------
>
> Key: HIVE-4197
> URL: https://issues.apache.org/jira/browse/HIVE-4197
> Project: Hive
> Issue Type: Bug
> Components: PTF-Windowing
> Reporter: Harish Butani
> Attachments: WindowingSpecification.pdf
>
>
> The current behavior defers from the Standard in several significant places.
> Please review attached doc; there are still a few open issues. Once we agree
> on the behavior, can proceed with fixing the implementation.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
