hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <>
Subject [jira] [Commented] (HIVE-4197) Bring windowing support inline with SQL Standard
Date Wed, 20 Mar 2013 21:27:15 GMT


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:
>             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:

View raw message